Microsoft Excel All-In-One Training
This Microsoft Excel course includes all three Levels from Beginner to Advanced
Microsoft Excel Level 1 – Beginner
Microsoft Excel Level 2 – Intermediate
Microsoft Excel Level 3 – Advanced
As your instructor I will use my 16+ years of Excel training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Excel.
At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass both: Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified, like me. Below are just a few of the topics that you will master:
Creating effective worksheets
Writing and editing formulas and calculations
Use sorting and filtering options
Build a database right the first time and avoid common design flaws
Creating informative and captivating Charts
Eliminate repetitive tasks instantly using Macros
Create many scenarios with varying groups of data
Manage large ranges of data in a List or Table
Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more
Basic knowledge
This course was created with Excel 2016. However, Excel 2007, 2010, or 2013 will work with most, or all features
You will need Microsoft Excel installed on your computer to follow along and complete the exercise files
