MS Office Excel

Analysis Toolpack Add-in
(more...)
Discover trough examples of real case studies in detail all options available in the MS Excel analysis tool add-in for business or statistics analysis.

Analytical Tools and Decisioneering (Business Analysis)
(more...)
Being able to set up and use common business mathematical models and tools in relation to business decision support (in various fields such as finance, quality, R&D, Marketing, etc.) using specialized functions, the solver and the MS Excel analysis toolpack.

Automation with recorded macros
(more...)
Learn the procedures to automate simple repetitive taks in MS Excel with recorded macros. The main objective of this training is to get prepared to the VBA training (automate without the macro limitations)

Charts
(more...)
Master all the different types of charts and their options of formatting, analyzing, printing and dynamic behavior.

Conditional formatting
(more...)
Learn every MS Excel 2007 and 2010 conditional formatting features by using basic or advanced criteria.

Create and format basic tables
(more...)
Learn the basic features of a worksheet application such as creation of small tables with basic functions and formulas. Create basic charts using the standard options from the wizard. Learn the worksheets' basic settings for printing layout.

Create workbook templates
(more...)
Create professional forms and tables ready for corporate deployment, to be used as corporate templates.

Creation of Dashboards
(more...)
Learn to create dynamic, interactive and user-friendly reports and dashboards within the limits of the possibilities of the tools made available in Microsoft Excel in order to manage and track activities.

DAX (Data Analysis Expression)
(more...)
Indeep the PowerPivot and Power BI courses by addressing the 120 most important functions (formulas) of the DAX formula and query language (Data Analysis eXpressions) to create more complex dynamic Pivot tables with statistical measures or elaborated time intelligence measures, or to create DAX queries. This training also prepares the attendee for the Power BI 70-778 certification and for the Power BI Desktop training.

Financial analysis and modeling
(more...)
Learn to use the advanced functions of the software (possibly with VBA) for calculations of NPV, IRR, eVAN, depreciation, portfolio optimization, Monte-Carlo simulation, operational research (combinatorial optimization), inferential statistics, hypothesis testing (ANOVA, T-Test).

Importing and exporting data
(more...)
Import/export of data from or to MS Excel using various available data files type.

Lists (database)
(more...)
Learn the useful and essential techniques for the management, the synthesis and the analysis of data lists (databases) with the standard tools and options of MS Excel.

Operational risk management and modeling
(more...)
The objective of this training is to acquire the basic techniques of risk modeling and control using Microsoft Excel and to move on from the naïve What-if analysis.

PivotTables and PivotCharts
(more...)
Extract data from various sources and benefit from calculation functions and formatting tools of PivotTables and PivotCharts to aggregate and report simple data collection.

Planning creation
(more...)
Create a Microsoft Excel visual with functionalities close to Microsoft Project (Calendar and Gantt) for micro-projects management, for personal tasks management or team planning.

Power Query
(more...)
The objective of this training is to acquire the necessary knowledge in Power Query to process, clean or link large amounts of data from different sources for post-analysis in the spreadsheet software as a table or in the PowerPivot model. The trainer will also introduce most common business cases that makes problems to Power Query users in MS Excel or MS Power BI. This training also prepares the attendee for the Power BI 70-778 certification and for the Power BI Desktop and M language training.

Power View (Power BI)
(more...)
Take a look at the Power View add-in, which allows you to publish dynamic, interactive, and real-time updated dashboards on the SharePoint Intranet or Office 365. The various tabular, matrix, charts, columns, lines, pie charts and geographic charts will be studied in detail and their known limitations will be communicated by the trainer. This training also prepares the attendee for the Power BI Desktop training.

PowerPivot (Power BI)
(more...)
This training allows you to take control of the PowerPivot add-in of Microsoft Excel and is part of a comprehensive approach ranging from data modeling to building dashboards using more complex dynamic PivotTables and interactive charts. The current problematic limitations of the tool will also be known by the trainees as a result of the training. This training is a prerequisite for the DAX functions course.

The Top 100 essential functions
(more...)
Learn to use and combine the 100 most common MS Excel functions in statistics, logic, database, time management, text modification and finance.

Tools for accountants and controllers
(more...)
Allow the participants to master the functions of Microsoft Excel for the implementation of tools useful for financial missions and control management and to exploit the advantages of Excel to draw up and present relevant financial reports (annual accounts, schedules, provisional budgets or others). Also learn the bad practices to avoid when using a spreadsheet software for this particular area and therefore acquire methods to speed up and make reliable the construction of dashboards and management reports. This training is also useful to prepare the technical skills necessary for the Microsoft Excel training on dashboards (ID1158).

Trainings, Courses available in Chicago, Dallas, Geneva, Huston, Los Angeles, New York, San-Antonio, San Diego, San Francisco, Washington, Zurich and anywhere in Switzerland, USA, Great Britain and Germany.

Contents