Mastering calculations: Formulas and functions
- Refresher on absolute/relative references and basic formulas
- Learning the statistical functions: AVERAGE, MAX...
- Using conditional formulas: IF, OR...
- Auditing formulas and correcting errors: #NOM?, #DIV/0!...
- Using advanced functions: VLOOKUP...
Hands-on work
Overview of the TOSA® test, and head count of participants when going around the room. Using functions in active tables.
Working with decision support tools
- Mastering target values and the Solver.
- Using the scenario manager.
- Managing data tables.
Hands-on work
Implementing multi-variable simulations.
Connecting to outside data
- Consolidating data.
- Importing data.
- Using data models for Pivot Tables.
Hands-on work
Using external data and a data model.
Analyzing data and creating Pivot Tables.
- Standardizing lists for analysis.
- Creating Pivot Tables with custom formulas and groups.
- Designing Pivot Tables built on multiple ranges or with a data model.
- Mastering interactive data mining tools.
- Using performance indicators.
Hands-on work
Analyzing data along multiple axes with Pivot Tables
Building charts
- Choosing a chart type
- Creating two-axis charts and combination charts.
- Designing specific charts.
- Incorporating trend curves, Sparkline, and forecasts.
Hands-on work
Creating elaborate charts.
Mastering control, sharing, and protection tools
- Inserting controls and advanced validation criteria.
- Protecting cells, a sheet, and a workbook.
- Sharing a workbook online, viewing it via a browser.
Hands-on work
Creating an interactive formula. Using a shared workbook.
Using macros
- Defining and saving macros.
- Assigning and customizing macros.
- Managing a workbook of personal macros.
- Discovering Visual Basic for Applications (VBA) and creating a simple function.
Hands-on work
Implementing macros. Certify your skills with TOSA®
3d
- 21h00 
