Microsoft Excel 2018 - Microsoft Excel - Excel from Beginner to Advanced - Simpliv

About this Course
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
What you will learn
Master Microsoft Excel from Beginner to Advanced
Build a solid understanding on the Basics of Microsoft Excel
Writing Formulas and performing Calculations
Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more
Create charts with Trend Lines, and Dual Axis
Use Excel as a Database with Sort and Filter options
How to avoid the most common Database Design flaws
Taught by Certified Microsoft Office Excel 2016 Specialist and Expert with over 16 years of Excel training
To join this course: https://www.simpliv.com/excel/microsoft-excel-exce...