Search form

 

Excel 2016 - Advanced techniques

Aim

You master the essential commands and wish to evolve towards more advanced techniques. This training programme will make it possible for you to discover or improve your knowledge on formula, tools for calculations, pivot tables, sharing workbooks… 

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

Users who have already mastered the essential commands and wish to move towards more advanced techniques. 

Course content

Excel 2016 – Level 2: Intermediate skills 

This module offers interactive training consisting of 52 training videos, 52 exercises and 4 additional resources.

  • 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 charts

Excel 2016 – Level 3: Advanced skills

  • This module offers interactive training consisting of 40 training videos, 40 exercises and 6 additional resources
  • 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 
  • Excel 2016 – Level 1: Essential skills