Search form

 

Excel 2016 - From essentials to advanced skills

Aim

Discover Excel and master all its features. From the essential to the advanced commands, this training programme, organised by topic, will make it possible for you to progress in all themes of the application (entering and formatting data, formula for simple and advanced calculations, charts, managing long tables, pivot tables and advanced tools…).  

Approach

ENI offers you a unique educational interactivity with practical exercises directly within the applications and with an immediate result analysis, that respects the 4 training steps:

  1. The learner watches a video
  2. The learner carries out the exercise directly within the application
  3. MEDIAplus instantaneously checks the answer
  4. MEDIAplus provides the answer

Target Audience and Prerequisites

Any user who wishes to discover or deepen their knowledge of Excel’s features. No prior knowledge of Excel is necessary. However, some use of the software may make it possible to progress faster. 

Course content

Excel 2016 – Level 1: Essential skills 

  • Get started in Excel   
  • Set out your first Excel calculations 
  • Look good with easy formatting
  • Print an attractive document 
  • Increase your efficiency 
  • Multiple worksheets and various views

Excel 2016 – Level 2: Intermediate skills 

  • Move on to more complex tables
  • Let charts explain your data
  • Illustrate your data 
  • Database functionality with an Excel table
  • Create striking charts
  • See your data from a different angle: pivot tables and chart

Excel 2016 – Level 3: Advanced skills

  • Grasped the basics? Take the next step 
  • Find the right function for your calculation
  • Learn some new functionality 
  • Share and collaborate effectively
  • Find out more…

Complementary material

  • Excel 2016 – Reference book