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
- 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
Price: $ 12.00
Visit the Course Page