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.
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.
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)
Master all the different types of charts and their options of formatting, analyzing, printing and dynamic behavior.
Learn every MS Excel 2007 and 2010 conditional formatting features by using basic or advanced criteria.
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 professional forms and tables ready for corporate deployment, to be used as corporate templates.
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.
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.
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).
Import/export of data from or to MS Excel using various available data files type.
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.
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.
Extract data from various sources and benefit from calculation functions and formatting tools of PivotTables and PivotCharts to aggregate and report simple data collection.
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.
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.
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.
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.
Learn to use and combine the 100 most common MS Excel functions in statistics, logic, database, time management, text modification and finance.
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).