Excel Data

Excel Data 1: Sorting and Filtering

• Handout
• Class Files (ZIP)
• Recorded Zoom Session
• Filters Exercises start at 25:00

Excel Data 2: Advanced Filter and Basic PivotTables

• Handout
• Class Files (ZIP)
• Recorded Zoom Session
• Advanced Filters – 2:10; SubTotals 13:57; PivotTable 34:57

Excel Data 3: PivotTables

• Handout
• Class Files (ZIP)
• Recorded Zoom Session
• Sales 0:30; Survey 32:27; Customers 40:00; Kangaroo Rats 46:20

Excel Data 4: Text Files, Text to Columns, and Flash Fill

• Handout
• Class Files (ZIP)
• Recorded Zoom Session

Excel Data 5: Substitution List vLookups/PivotTables

• Handout
• Class Files (ZIP)
• Recorded Zoom Session
• Accounts 2:00; Sales 12:37; Sessions 22:45

Excel Data 6: Pivot Charts, Slicers, and Dashboards

• Handout
• Class Files (ZIP)
• Recorded Zoom Session
• Dashboard1 0:48 – PivotTable; PivotChart; Linked Drawings
• Dashboard2 24:21 – Pivot Tables, Pivot Charts, Slicers
• Dashboard3 44:15 – Formatted Table, Sparklines; Conditional Formatting, Charts