Overview
-
Quickly gain confidence with the most intimidating features in Excel. Unlock the power of VLOOKUP, PivotTables, Flash Fill, Conditional Formatting, and more.
Syllabus
-
1. Excel: You Can Do This
- Flash Fill: Merge data in different cells
- Linking sheets
- Copying, coloring, and naming tabs
- SUM: Calculating a basic sum
- Freeze panes: See your data while scrolling
- Conditional formatting
- Data validation: Ensure users don't input crazy data
- Create a drop-down list
- Create basic charts from scratch
- Split text in Power Query: Split real-world data fields
- IF statement
- COUNTIFS: Count entries based on conditions
- The #N/A error: What does it mean and what causes it?
- VLOOKUP
