Excel mastery certificate: Beyond the basics

Excel Academy

Intermediate8 episodes • 1h 38m1.1K views

Excel

Dashboard

Data

Visualization

Analysis

certificate

1. Learn Excel: From basics to pro

4m 09s Playing...

Learn the key differences between Excel skill levels and solutions to common workplace challenges.

2. How to master Excel pivot tables?

11m 04s

Let's organise and analyse complex data using Excel's powerful pivot table features in just minutes!

3. How to use Excel for duplicate cleanup?

8m 27s

Transform messy data into clean insights with Excel's distinct count for powerful data summaries.

4. Turn Excel data into stunning charts

3m 35s

Turn boring Excel pivot tables into dynamic visuals with powerful slicers and interactive timelines!

5. Master interactive charts and dashboards

12m 11s

Combine pivot tables, charts, slicers, and timelines into powerful interactive Excel dashboards.

6. How Excel's waterfall charts show trend?

19m 20s

Master waterfall charts and sparklines to reveal data patterns and create compelling visual stories.

7. Sort and organize Excel data fast

25m 47s

Control messy spreadsheets using advanced sorting, filtering, and validation techniques in Excel.

8. Learn Excel solver for smart projections

13m 51s

Navigate best-case and worst-case scenarios using Excel's Goal Seek and Solver forecasting tools.