30 Days Excel Course

Day 1 Introduction to Excel & Formatting Data
Day 2 Basic Formulas
Day 3 Sorting Data
Day 4 Filtering Data
Day 5 Excel Shortcuts
Day 6 Merge and Freeze
Day 7 Conditional Formatting
Day 8 Text to Columns
Day 9 Remove Duplicates & Unique Formula
Day 10 Paste Special
Day 11 IF and Advanced IF Formula
Day 12 Adding $ Sign in Formula
Day 13 CountIF, SumIF & AverageIF
Day 14 Left, Right & Mid Formulas
Day 15 VLOOKUP
Day 16 HLOOKUP
Day 17 Data Cleaning Formulas
Day 18 Flash Fill
Day 19 Text Formula
Day 20 Pivot Tables
1 of 2
Previous Lesson
Next Lesson

Day 20 Pivot Tables

30 Days Excel Course Day 20 Pivot Tables
Previous Lesson
Back to Course
Next Lesson