Vous avez déjà un compte client ORSYS
Se connecter
Vous êtes nouveau chez ORSYS
Créer un compte
Vous ne souhaitez pas créer de compte
Poursuivre sans me connecter

Course : TOSA® Excel - Advanced: Certification

Version 2016/2013/2010

TOSA® Excel - Advanced: Certification

Version 2016/2013/2010

Average of customer reviews Average of customer reviews Average of customer reviews Average of customer reviews
4,5 / 5




INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class

Ref. EXO
  3d - 21h00
Price : Contact us

Download in PDF format

Share this course by email






Teaching objectives
At the end of the training, the participant will be able to:
Create advanced calculation formulas
Correlate data from multiple sources
Analyze data with Pivot Tables/Charts
Create interactive simulations
Create elaborate charts
Implementing macros to automate certain tasks
Certify your skills with TOSA®

Certification
Information needed to register for TOSA® certification is collected at the start of the training session. The exam is proctored by the instructor and is carried out online during the last hour of the course. When carried out remotely, a special system is used for monitoring. Certification is in the form of a 60-minute adaptive test with 35 exercises. The result indicates your skill level. Merely taking the course is not sufficient to achieve a maximum score.

Practical details
Hands-on work
Hands-on and practice exercises to prepare you to take the TOSA® certification exam.
Teaching methods
Active learning based on discussions, real-world exercises, practice for taking the TOSA® certification exam, and an evaluation of what was learned from the training.

Course schedule

1
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.

2
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.

3
Connecting to outside data

  • Consolidating data.
  • Importing data.
  • Using data models for Pivot Tables.
Hands-on work
Using external data and a data model.

4
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

5
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.

6
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.

7
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®


Customer reviews
4,5 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.