When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Microsoft Excel: Scenario based training. Basic to Advance.
Scenario based training on Excel for learners of all levels.
This Course Includes
udemy
0 (0 reviews )
2 total hours 
english
Online - Self Paced
course
Udemy
About Microsoft Excel: Scenario based training. Basic to Advance.
How does learning from someone who started Excel training in his company in 1995 sound?
Today you have this opportunity!
For over 26 years Wilkie has laid the foundation for thousands of people teaching Microsoft Excel.
In this course, he will share his knowledge with you.
He will lay the foundation starting with the Basic principles and then build towards the Advanced features. Whether you have never opened an Excel file ever before, you want to brush up on your skills and the newest features, or you are well versed in Excel and want to learn more advanced functions, this course has it all!
The course also includes valuable tips and tricks to work more effectively in Excel, and is designed from a basic to advanced level. We'll discuss topics such as:
Entering and editing data
Autofill
formatting of cells
working with functions
sorting of data
past special
The What-if-analysis
One- and two data table
validations
conditional format
charts
subtotals
links
protection
Lookups
Pivot tables, and macros
The training is built on scenarios and you can practice what you have learned using downloadable Excel working files, and is for anyone who wants to work more effectively in Microsoft excel. Whether in a corporate or personal capacity, if you use excel regularly this course is for you!
Remember: You don’t know what you don’t know, so it is worth your time investing in this course.
See you online!
What You Will Learn?
- Build a solid understanding on the Basics of Microsoft Excel.
- Microsoft Excel from Beginner to Advanced using real scenarios and downloadable working files.
- Practice the use of dynamic functions like IF, VLOOKUP, HLOOKUP, PMT, INDEX, MATCH, SUBTOTALS and many more.
- Create great looking reports using Pivot tables, Slicers and Sparklines.
- Automate daily routine work using Macros.
- Practice Excel Tips and Tricks to work more effective.