Microsoft Excel in the business context - Advanced course
What you'll 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
- Run queries to extract data from websites
- Introduction into using VBA for automation purposes
Requirements
- Solid understanding of Excel and the use of formulas - ideally, you have completed my beginner's course
- Have Excel installed on your computer. Your Excel version does not matter! If you are not using Office365, I will show you workarounds how you get to the same results
Description
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.
In this course, you will:
- 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!
Who this course is for:
- Students
- Advanced Excel users
- People working in business
Instructor
- 4.3 Instructor Rating
- 121 Reviews
- 598 Students
- 4 Courses
Throughout my undergraduate studies, I worked part-time in a corporation, and I was surprised at how inefficiently many people operate in their day-to-day work. Upon completing business school, I then joined the Finance department of a multinational corporation, where I managed to render my own position "obsolete", after I had automated the majority of my tasks.
Time is scarce, and it was then that I decided to venture into teaching Microsoft Excel. I have since been teaching in universities and companies, helping people to make the best out of their time by learning how to use Microsoft Excel in the most efficient and effective way.