Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Navi Advanced Google Sheet & MS Excel Batch 1
Class Recordings
S1 19-07-2022 Pivot Tables (93:16)
S2 21-07-2022 Splitting of Pivot Reports, Vlookup Exact (92:56)
S3 26-07-2022 Lookups, Match, Lookup Approx (87:42)
S4 28-07-2022 Logical Operators, AND , OR, Conditional Formatting (89:43)
S5 04-08-2022 Conditional Formatting Rule 1 (86:49)
S6 09-08-2022 Lookups, Index, Concatenate, Case Study (88:33)
S7 17-08-2022 Charts, Types of Charts and Usage (83:55)
S8 18-08-2022 Dashboard Key Elements, Regional Analysis (79:21)
S9 23-08-2022 Dashboard, Slicers, Graphs (81:54)
S10 25-08-2022 Dashboard-Loans Dataset (79:08)
S11 30-08-2022 Dashboards (60:13)
S12 13-09-2022 Macros, Import Range, Append Date (90:26)
Class Files
Session File Links
Dashboard - Exercise
Dashboard - Loan Dataset - Exercise
Assignment
Pivots
If Functions
Lookups
Conditional Formatting
Final Assessment
20-09-2022 Final Assessment
S12 13-09-2022 Macros, Import Range, Append Date
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock