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 right 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:
- quickly automate standard procedures
- create models and dashboards from scratch and visualize them in dynamic charts
- retrieve data from the internet and integrate them directly into your workbook
- 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!