Preview Excel: Beginners to Advanced Course

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: 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

Generating data , Sort operations

Arithmetic operations

Conditional statements in Excel

Arithmetic operations

Filtering

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

Preview - Excel: Beginners to Advanced Course