Advanced formulas

Range names

Specialized functions.

Logical & Lookup functions

Text

Logical

Lookup

Date

Financial functions

Excel Tables

Create And modify Tables

Sort and filter data

Subtotal

Database functions

Charts

Charts

Trendline

Advanced charts.

PivotTables

Create pivot tables

Filters, slicers

Pivot charts

Graphics

Shapes

SmartArt

Enhancing workbooks

Templates

Protect files

‍