Quickly gain confidence with the most intimidating features in Excel. Unlock the power of VLOOKUP, PivotTables, Flash Fill, Conditional Formatting, and more.
Overview
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
Taught by
Oz du Soleil
Related Courses
-
Microsoft Excel for Beginners: Learn The Essentials in 50 Minutes
-
Excel Level II: Intermediate
-
Excel PRO TIPS Part 1: Productivity
-
Excel Essentials for the Real World (Complete Excel Course)
-
The Ultimate Microsoft Excel Mastery Bundle - 8 Courses
-
Excel at Microsoft Excel - The Complete Beginner to Advanced Excel Mastery Course -
