Excel 2016 – Advanced techniques

Course goals

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…

Prerequisites

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

Level required:
The essential commands must be mastered in order to access Excel’s advanced techniques without difficulty.

Course goals

MEDIAplus eLearning
This module offers interactive training consisting of 53 training videos, 53 exercises and 5 additional resources.
Excel 2016 – Level 2: Intermediate skills
• Move on to more complex tables
• Let charts explain your data
• Create striking charts
• Illustrate your data
• Database functionality with an Excel table
• See your data from a different angle: pivot tables and charts

MEDIAplus eLearning
This module offers interactive training consisting of 42 training videos, 42 exercises and 7 additional resources.
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…

Additional book
This module includes digital course material.
Excel 2016 – Reference book

Additional MEDIAplus eLearning content
This module offers interactive training consisting of 45 training videos, 45 exercises and 6 additional resources.
Excel 2016 – Level 1: Essential skills