Back

Excel 2016/2019/365 - Level 2

Handling the important basic functions. Nesting functions. Using the powerful analysis tools. Creating automated templates and macros. The new Office interface, using the File tab ("Backstage"), ...

Handling the important functions. Nesting functions. Using the powerful data analysis tools. Creating automated templates and macros.

  • Review tips & tricks to optimize calculation operations
  • Manipulating categories of functions
  • Automating worksheets by using Formulas and Functions
  • Introduction to databases
  • Analyzing data by using Pivot tables
  • Creating customized charts
  • Working with templates
  • Recording macros
  • Tips and tricks
  • Exercises

This course is addressed to good basic users, who wish to learn Excel furthermore in fields such as accountability, finances or science

You might also be interested in:

Programming with VBA Excel

Dans cette formation pratique, vous apprenez les bases de la programmation et le VBA depuis le début. Vous acquérrez les savoir-faire nécessaires à l'automatisation de tâches répétitives, vous construisez des interfaces utilisateurs et vous augmentez votre niveau de performance afin d'améliorer la productivité des utilisateurs.

Outlook 2016/2019/365 Productivity

The course teaches participants how to stop "living in their inbox" and start prioritizing tasks, messages, and appointments to achieve what's most important to the organization and themselves.

Word 2016/2019/365 - Level 1

Microsoft Word is a very powerful word processing application designed to save you time and make creating letters, CVs, reports and other documents easy. This is an introductory Microsoft Word training course that will provide you with a working understanding of the basic features of MS Word. Like being able to create and format documents.