Share

Excel 2016 : Advanced skills - Online training

Objectives

You have mastered basic and intermediate commands and would like to progress towards advanced feature. This course will enable you to discover or perfect your knowledge concerning advanced calculation functions, control tools and the search, protection and sharing of your workbooks and data. You will also discover macros.

Targeted audience

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

Prerequisite

Special Note

Complete online self-paced training. Accessible anytime from anywhere. One year access to the training and the digital book.

Content

Converting data

Custom views

Advanced functions (time, date, text, AND, OR, NOT, IF, etc.)

Financial and matrix functions

Creating styles, templates and forms

Sharing and security

Macros

General Note

The peculiarity of this online training consists of real training in the software. To enjoy this asset, after connecting to the portal, the identified user is directed to the solution MEDIAplus eLearning in the Cloud. A virtual machine will open on the user’s desktop.