Excel training

927 total views, 3 views today

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.

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.

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.

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.

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 an MS Excel table with functionalities close to MS Project 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.


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.