arrow_back
Introduction and getting acquainted with to Excel
Creating Basic Workbooks
Importing Data, Sorting and Filtering
Fill handle and flash fill
Charts and graphs
Basic Maths, Cell referencing
Basic Statistical Functions
Functions and formulas in excel
Logic, Date and Time Functions
Text functions-1
Text functions-2
Excel tables and properties
Pivot Tables
Overview/ exercises of the above sessions
Quick recap of Basic concepts
Data cleaning
Conditional formatting
Lookup functions-1
Lookup functions-2
Conditional statements
Arrays and Matrices
Data validation-1
Data validation-2
Advanced Pivot tables
Slicers
Basic Dashboards
Macros
Overview/ exercises of the above sessions
Recordings of the top batch
Introduction and getting acquainted with Excel
Creating Basic Workbooks
Importing Data, Sorting and Filtering
Fill handle and flash fill
Charts and Graphs
Basic Statistical Functions
Functions and formulas in excel
Logic, Date and Time Functions
Text Functions
Excel tables and properties
Pivot Tables
Overview: Exercises of the above sessions
Data Cleaning
Quick Recap of Basic Concepts
Conditional Formatting
Lookup Functions- 1
Lookup Functions- 2
Conditional Statements
Arrays and Matrices
Data Validation- 1
Data Validation- 2 & Advanced Pivot Tables
Slicers & Basic Dashboards
Macros & Overview, Exercises of the above sessions
Recordings: September'24
Day 1: 2nd September
Day 2: 3rd September
Day 3: 4th September
Day 4: 5th September
Day 5: 8th September
Day 6: 9th September
Day 7: 10th September
Day 8: 11th September
Day 9: 12th September
Day 10: 13th September
Day 11: 14th September
Day 12: 15th September
Day 13: 16th September
Day 14: 17th September
Day 15: 18th September
Day 16: 20th September
Day 17: 21st September
Day 18: 22nd September
Day 19: 23rd September
Day 20: 24th September
Day 21: 25th September
Day 22: 26th September
Day 23: 27th September
Day 24: 28th September
Day 25: 29th September
Day 26: 30th September
Day 27: 1st October
Day 28: 2nd October
Recordings: May 2023
Session 1
Session 2
Session 3
Session 4
Excel File (Session 4): SORT AND CUSTOM SORT
Session 5
Session 6
Session 7
Session 8
Session 9
Session 10
Session 11
Session 12
Session 13
Session 14
Session 15
Excel File (Session 15): VLOOKUP and HLOOKUP
Session 16
Session 17
Session 18
Session 19
Excel File (Session 19): CLEAN
Session 20
Session 21
Session 22
Session 23
Session 24
Session 25
Session 26
Session 27
Recordings: July 2023
Session 1
Session 2
Session 3
Session 4
Session 5
Session 6
Session 7
Session 8
Session 9
Session 10
Session 11
Session 12
Session 13
Session 14
Session 15
Session 16
Session 17
Session 18
Session 19
Session 20
Session 21
Session 22
Session 23
Session 24
Session 25
Session 26
Session 27
Session 28
Recordings: September 2023
Session 1
Session 2
Session 3
Session 4
Session 5
Session 6
Session 7
Session 8
Session 9
Session 10
Session 11
Session 12
Session 13
Session 14
Session 15
Session 16
Session 17
Session 18
Session 19
Session 20
Session 21
Session 22
Session 23
Session 24
Session 25
Session 26
Session 27
Session 28
Recordings: November 2023
Session 1
Session 2
Session 3
Session 4
Session 5
Session 6
Session 7
Session 8
Session 9
Session 10
Session 11
Session 12
Session 13
Session 14
Session 15
Session 16
Session 17
Session 18
Session 19
Session 20
Session 21
Session 22
Session 23
Session 24
Session 25
Session 26
Session 27
Session 28
Recordings: Jan'24
Pivot-Table-Data
Quality Sleep
Diabetes
Introduction
Excel ribbon tabs
Excel ribbon tabs
Generating data , Sort operations
Arithmetic operations
Conditional statements in Excel
Arithmetic operations
Filtering
Text functions
Text functions
Text functions
Conditional formatting
Conditional formatting based on rules
Referencing
Vlookup and Hlookup
VLOOKUP and HLOOKUP
Index and Match
Pivot tables
Pivot table continued
slicers
Data Validation
Session on 25th Jan
Session on 27th Jan
Session on 28th Jan
Session on 29th Jan
Session on 30th Jan
Session on 31st Jan
Recordings: March'24
Introduction
Session on 2nd March
Session on 3rd March
Session on 4th March
Session on 5th March
Session on 6th March
Session on 7th March
Session on 12th March
Session on 13th March
Session on 14th March
Session on 15th March
Session on 16th March
Session on 17th March
Session on 18th March
Session on 19th March
Session on 20th March
Session on 21st March
Session on 22nd March
Session on 23rd March
Session on 24th March
Session on 26th March
Session on 27th March
Session on 28th March
Session on 29th March
Session on 30th March
Session on 1st April
Session on 2nd April
Session on 6th April
Session on 7th April
Recordings: May'24
Session on 1st May
Session on 2nd May
Session on 3rd May
Session on 5th May
Session on 6th May
Session on 7th May
Session on 8th May
Session on 10th May
Session on 11th May
Session on 12th May
Session on 13th May
Session on 14th May
Session on 15th May
Session on 16th May
Session on 17th May
Session on 18th May
Session on 20th May
Session on 21st May
Session on 22nd May
Session on 23rd May
Session on 24th May
Session on 25th May
Session on 26th May
Session on 27th May
Session on 28th May
Session on 29th May
Session on 30th May
Session on 31st May
Recordings: July'24
Session on 1st July
Session on 2nd July
Session on 3rd July
Session on 4th July
Session on 5th July
Session on 6th July
Session on 7th July
Session on 8th July
Session on 9th July
Session on 10th July
Session on 11th July
Session on 12th July
Session on 13th July
Session on 15th July
Session on 16th July
Session on 17th July
Session on 18th July
Session on 19th July
Session on 20th July
Session on 22nd July
Session on 23rd July
Session on 24th July
Session on 25th July
Session on 26th July
Session on 30th July
Session on 1st Aug
AdditionalPractice
Data cleaning
How to use VLOOKUP with approximate match
logicalfunct
pivot_table_example
Product_Comparison_Data
SampleData
Session on 2nd Aug
Session on 3rd Aug
Recording: November 2024
Session on 4th November 2024
Session on 5th November 2024
Session on 6th November 2024
Session on 9th November 2024
Session on 10th November 2024
Session on 11th November 2024
Session on 12th November 2024
Session on 13th November 2024
Session on 15th November 2024