Microsoft Excel: From Beginner to Advanced

The Simpliv course “Microsoft Excel – Excel from Beginner to Advanced” will enable you to master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks. It will also give you the training you need to help pass both: Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified.

Here 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.

Microsoft Excel – Excel from Beginner to Advanced – Course Content

The course comprises 157 Lectures organized into the following sections:

Excel Level 1 – Beginner
Basics
Functions & Formulas
Editing Worksheets
Formatting
Print
Modifying Worksheet Appearance
Excel Level 2 – Intermediate
Advanced Formulas & Functions
Tables
Charts
PivotTables & PivotCharts
Graphics
Customize
Excel Level 3 – Advanced
Workbook
Collaborating
Audit Worksheets
Analyzing Data
Excel Level 3 – Advanced

Knowledge Required

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

Summary of Course Main Features

Instructor: Kirt Kershaw
Lectures: 157
Level: All
Includes:
- Life Time Access
- Certificate of Completion
- Access on Android and iOS App