EL441

Excel 2016 : Advanced skills - Online training

  • Duration 5 HOURS
  • Regular fee 140
SUMMARY
DETAILS

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

Excel basics (EL440).

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.

NO SETUP is required on the user's computer. Supported operating systems: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista, Windows XP, SP3, Mac OS X 10.6 or higher. Supported browsers: recent versions of Internet Explorer (10 and 11), Edge, Chrome, Firefox, Safari.

Subscription

  • Subscription french version

  • Subscription english version