BZMIND

Welcome - let me introduce myself

How to use this course

Suggested path forward

Content for reference

Learn how to name cells and ranges - and why you should (6:14)

Format numbers and dates - make your data easier to use and to read (7:23)

Use brackets to show negative Numbers (2:53)

Prepare your data for use in tables and PivotTables - best practices (9:04)

What do you wish you knew how to do?

Create links between cells, worksheets and workbooks (4:11)

Create links from Excel to Word or PowerPoint (6:13)

Test your linking knowledge

Organize your data in a table (6:19)

Make use of structured references, summarize data using SUMIF (11:37)

Add totals to a table and subtotals to data (6:13)

Test you table knowledge

Use VLOOKUP to find an exact match in tabular data (9:31)

Use VLOOKUP to find the closest match (5:43)

Look It Up (6:04)

Use Index and Match - a perfect pair

Two things you need to know before tackling Pivot Tables

Create your first PivotTable and add some formatting (5:49)

Use grouping, slicers and PivotCharts (6:27)

Use the data provided to create a specific report (9:04)

Test your PivotTable knowledge