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 : Excel: Advanced

Excel: Advanced


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




INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class

Ref. ECE
  3d - 21h00
Price : Contact us
En option :
Dynamique.Model.Bean_FormationOption
: 60 € HT

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
Implement macros to automate certain tasks

Practical details
Hands-on work
Discussions, experience-sharing, demonstrations, tutorials, and real cases to help you throughout the training.
Teaching methods
Active learning based on discussions, real-world cases, practice exercises if 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
Using functions in 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, 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. Optional: Certifying your skills with TOSA®.


Options
: 60 € HT
If registering for the TOSA® certification option, you must do so at the same time as course registration. The exam is made up 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. The exam is proctored by the instructor and is carried out online during the last half-hour of the course. If taking place in a remote classroom, the exam must be both scheduled and then taken online within 4 weeks following the start of your session.

Customer reviews
4,6 / 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.


Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class