Microsoft Excel in the business context - Advanced course

Microsoft Excel in the business context - Advanced course

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 in Microsoft 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!

Jump-start your productivity and take your knowledge of Excel functionalities to the next level!

Url: View Details

What you will learn

• Make your day-to-day work in Excel more effective with productivity hacks
• Learn how to create dynamic dashboards and how you can visualize them
• Understand and apply complex formulas such as indirect, offset, and brand-new Office 365 functionalities

Rating: 3.66667

Level: Intermediate Level

Duration: 5 hours

Instructor: Felix Stockkamp