Nested IFs, IFERROR, IFS

LOOKUP, VLOOKUP, HLOOKUP, INDEX & MATCH

TEXT, DATE, and TIME functions

Using named ranges

Creating dropdown lists and input messages

Restricting data entry with rules

Protecting cells, sheets, and workbooks

Hiding formulas and locking ranges

Applying built-in rules (highlight cells, top/bottom)

Creating custom rules with formulas

Using color scales, icon sets, and data bars

Managing conditional formatting

Creating combo charts and dual-axis charts

Customizing chart elements and layouts

Sparklines and trendlines

Using charts for dashboards

Creating and customizing PivotTables

Grouping and filtering data

Calculated fields and value summaries

Creating interactive PivotCharts

Using tables for data management

Sorting and filtering data

Using Subtotals and Outline view

Removing duplicates and blank rows

Goal Seek, Scenario Manager, and Data Tables

Using Solver Add-in

Flash Fill and Text to Columns

Consolidating data from multiple sheets

Importing data from text files, web, and databases

Using Power Query basics

Cleaning and transforming data

Refreshing linked data

Recording basic macros

Running and assigning macros to buttons

Editing macro code (Intro to VBA)

Macro security settings

Sharing and tracking changes

Adding and managing comments

Inspecting and protecting workbooks

Passwords and digital signatures

Post-Test