Back

Excel 2016/2019 - Level 2

Handling the important basic functions. Nesting functions. Using the powerful analysis tools. Creating automated templates with Excel.

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

In this hands-on course, you learn the fundamentals of programming and VBA from the ground up. You gain the skills you need to automate repetitive tasks, build user interfaces and increase performance in order to improve user productivity.

Visio 2016/2019

In this course students will get acquainted with an overview of the features and functions of Microsoft Office Visio 2016.

MS Project 2016/2019 - Level 1

In this Introduction to Microsoft Project 2013/2016: Getting Started class, students will spend time getting comfortable with the Project 2013/2016 user interface, including project views and the ribbon. They will also learn to enter, organize, and link tasks, work with resources, create basic reports, and create projects independently. The course allows time to practice fundamental basic skills essential for efficient use of this
program.