Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel for Office Productivity
Level 1 : Introductory Tricks
Warm-up - Key Shortcuts (10:07)
Formula Tricks - SUM, AUTOSUM, MAX, MIN, AVERAGE (13:55)
Formula Tricks - SUMPRODUCT, POWER, ROUND, MROUND (12:26)
Formatting Tricks: Table Concept, Using Format Painter uninterruptedly etc. (11:33)
Auto fill options - Variations & Settings (7:48)
Paste Special - Value, Transpose; Formula TRANSPOSE() (6:54)
Range Selection; GO TO - Special (11:09)
Course Review
Level 2 : Sort & Filter
Multi-level Sort, Custom Sort, Color Sort (10:52)
Filter & SUBTOTAL() formula (17:04)
Level 3 : Cell Referencing for writing Formulas
Cell Referencing using $ - Introduction (3:23)
Cell Referencing using $ - Practice #1 (5:39)
Cell Referencing using $ - Practice #2 (4:22)
Cell Referencing using $ - Practice #3 (4:34)
Cell Referencing using $ - Special Trick (2:49)
Course Review
Level 3 : 1D Lookup, 2D Lookup and Conditional Sum
Dashboard I: Grouping, Data Validation (List), Cell-Range Naming (19:31)
Dashboard III: Hide/Unhide Columns-Rows, Freeze Panes (5:32)
VLOOKUP Introduction - Where/Why/How to use (5:49)
VLOOKUP - Pre-requisites and Common Pitfalls (6:46)
VLOOKUP - True (1) vs. False (0) (10:38)
HLOOKUP (3:29)
Using MATCH with VLOOKUP/HLOOKUP - 2x2 matrix lookup (12:43)
VLOOKUP with MATCH - Practice #1 (5:31)
SUMIFS - Introduction (5:33)
Level 4 : Data Cleaning
Date Cleaning techniques using Text-to-Columns (10:13)
Find & Replace – Advanced (10:14)
Level 5 : Logical Formulas - IF, AND, OR
Logical formulas I - IF, Nested IFs (6:48)
Logical formulas II - AND, OR with IF (9:01)
Logical formulas III - more case studies (9:30)
ISERROR, ISBLANK, ISNUMBER, ISTEXT, IFERROR (9:01)
Level 6 : MIS Reporting
Conditional Formatting I (Blanks, Errors, Values, Duplicates) (10:51)
Pivot Table Trick - Generating 600+ reports in <1 min (6:47)
3D Data Lookup using VLookup, Match, Indirect, Naming (7:53)
Logical formulas II - AND, OR with IF
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock