Understanding the underlying logic of Excel and the ability to use advanced formulas are key to getting an edge at work. If you already have a solid understanding of basic functionalities inMicrosoft Excel, and would like to take your skills to the next level, this is the right class for you.

Together, we will expand our knowledge of Microsoft Excel by working on typical work-related problems such as creating a dashboard to show sales by country, keeping track of employees' time spent at work, or planning project activities. The course is designed so that you will understand what is possible in Excel, and how to best tackle different situations whilst being aware of the advantages and disadvantages of different approaches.

Upon completion of the course, you will be able to:

- ramp up your productivity with the productivity boosters in chapter 1

- use advanced filters to dynamically filter your data set

- create models and dashboards from scratch and visualize them in dynamic charts

- retrieve data from the internet and integrate them directly into your workbook

- apply Visual Basic, the programming language in Microsoft Excel

- understand how Excel treats date and time, and what you can do with the different formulas

Don't waste your time at work carrying out mundane tasks, which could easily be automated! Leverage advanced formulas and a solid understanding of the inherent logic of Excel to free up your time to focus on the truly important activities!