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
Requirements
This course was created with Excel as compiled in Microsoft Office 365 ProPlus.
Do not worry if you have a lower version of Excel. The functions are the same across the versions and you will easily find your way
Description
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
Homepage

https://www.udemy.com/course/microsoft-excel-from-zero-to-hero/

Related Downloads :

{related-news}