English → Office at its best! → Excel at its best!

Excel at its best! Optimalisation (XLS-OP-OD-ENG)


Beschrijving
• Do you sometimes find that you can't get the necessary information from your tables?
• Is your calculator at your fingertips when you do calculations in Excel?
• Does the term 'briefly' apply to your (pivot) tables and graphs?
• And do you often have to use tricks to print your output?
With this online training, learn to control your own data and get started with Excel without digistress.
At the top of the screen, click 'Complete and continue' for the next part.

SME portfolio?
Would you like to benefit from up to 30% support via the SME portfolio? Apply for it now.
Our accreditation number is DV.O203103.

Extra benefit?
You can submit your question to the ifficiency trainer up to one year after the training.

What is the rate?
€ 199 excl. VAT - € 240.79 incl. VAT

niveau: Optimalisatie duur: 8 taal: EN

Inhoud
  • What is Excel?
  • Introduction
  • Short knowledge test
  • Download files
  • The ideal Excel file
  • Input without frustration
  • Compatibility mode
  • Real tables
  • Data validation
  • Conditional formatting
  • Formulas and functions
  • Formulas and functions: introduction
  • Absolute and relative cell reference
  • AVERAGE
  • COUNT – MIN - MAX
  • SUBTOTAL
  • IF-function
  • Other IF-functions
  • Date functions
  • Time functions
  • Output without frustration
  • Pivot tables: introduction
  • Pivot tables: formatting
  • Pivot tables: exercice
  • Pivot tables: refresh data
  • Pivot tables: percentages
  • Report lay-out
  • Course material
  • Course material
  • Training evaluation
  • Good luck!
Voltooiingsregels
  • Je moet de onderdelen "Training evaluation" afronden
  • Leidt naar een certificaat met een duur van: 1 jaar