Advanced MS Excel 2016 Certification Training

Module 1: Overview of Advanced MS Excel 2016

⏳ 20 minutes

• Topics: What’s New in Excel 2016; advanced concept introduction

• Hands-on: Explore updated interface features and shortcuts

Module 2: Custom & Conditional Formatting

⏳ 30 minutes

• Topics: Quick Access Toolbar customization; conditional formatting rules

• Hands-on: Apply dynamic formatting to highlight trends and outliers

Module 3: Advanced Functions & Formulas

⏳ 45 minutes

• Topics: Logical, text, lookup/reference functions; formula auditing; named ranges

• Hands-on: Craft and debug complex, multi-step formulas

Module 4: Advanced Data Tools

⏳ 30 minutes

• Topics: Text to Columns; data validation; What-If Analysis; duplicate removal

• Hands-on: Clean and prepare a messy dataset for analysis

Module 5: Data Analysis

⏳ 45 minutes

• Topics: PivotTables; PivotCharts; sparklines; regression and ANOVA analyses

• Hands-on: Build interactive reports and run statistical tests in Excel

Module 6: Introduction to Macros

⏳ 30 minutes

• Topics: Recording, editing, and running Macros; VBA overview

• Hands-on: Automate a repetitive reporting task with a custom Macro

Module 7: Data Security

⏳ 25 minutes

• Topics: Protecting cells, sheets, workbooks, and ranges; permission management

• Hands-on: Secure sensitive data with password and range restrictions

Module 8: Certification Project Prep

⏳ 20 minutes

• Topics: Capstone project guidelines; end-to-end application of skills

• Hands-on: Plan your certification project to demonstrate mastery

Get certificate