Microsoft Excel: Scenario based training. Basic to Advance.
Learn Microsoft Excel from beginner to advanced with real scenarios and downloadable working files. Master dynamic functions like IF, VLOOKUP, HLOOKUP, and more. Create impressive reports using Pivot tables, Slicers, and Sparklines. Automate tasks with Macros and discover useful tips and tricks. Taught by an experienced Excel trainer since 1995, this course covers everything from basic principles to advanced features. Suitable for beginners and experienced users alike, this course will enhance your Excel skills and productivity. Don’t miss out on advanced features you may not be aware of. Enroll now!
What you’ll 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
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!
Who this course is for:
- This Microsoft Excel course is for anyone who wants to work smart and more effective and productive using Excel
- Take this course to make sure you do not miss out on advanced features you are not aware of
User Reviews
Be the first to review “Microsoft Excel: Scenario based training. Basic to Advance.”
You must be logged in to post a review.
There are no reviews yet.