Excel 2013/2016 - 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 in 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.

MS Project 2013/2016 - Level 2

Being able to update a project, communicate about the project, customise fields and use graphical indicators. Exchange data with other software applications, work with multiple projects and a resource pool...

Programming in VBA Access

This intensive 3-day course is designed to introduce new Access programmers to the Visual Basic for Applications programming language and help them create robust and powerful database applications by taking a structured look at Access VBA. It will help new database developers to plan and automate their applications.