arrow_back
2.2 Operator Precedence
Day 1
Day 1 Intro
Basic Features of Excel
1.1 Cells & Range
1.2 Working with Rows and Columns
1.3 Working with Worksheets
1.4 Cell Formatting & Data Types
1.5 Wrap Text, Merge Cells, Autofit, Row Height & Column Width
1.6 Flash Fill
1.6 Comments
Summary, Notes & Assignment
Day 1 Summary
Notes Day 1
Day 1 Task
Day 1 Quiz
Day 1 Task
Day 2
Day 2 Intro
Formulas & Functions
2.1 Formulas & Sum ()
2.2 Operator Precedence
2.3 Copy & Paste Formulas
2.4 Auto Sum
2.5 Count, Countif () & Sumif ()
2.6 SumProduct ()
Cell Referencing
2.7 Relative & Absolute Referencing
Summary, Notes & Assignment
Day 2 Summary
Notes Day 2
Day 2 Quiz
Day 2 Task
Day 3
Day 3 Intro
Named Ranges
3.1 Range Names
Logical Functions
3.2 If (), Nested If, And (), Or ()
Basic Statistical Functions
3.3 Average (), Min (), Max ()
Summary, Notes & Assignment
Day 3 Summary
Notes Day 3
Day 3 Quiz
Day 3 Task
Day 4
Day 4 Intro
Conditional Formatting
4.1 Conditional Formatting
Sorting
4.2 Sorting
Filter
4.3 Filter
Find & Select
4.4 Find & Select
Summary, Notes & Assignment
Day 4 Summary
Day 4 Notes
Day 4 Quiz
Day 4 Task
Day 5
Day 5 Intro
String Based Functions
5.1 String Based Functions
Transpose, Freeze Panes
5.2 Transpose, Freeze Panes
Date Functions
5.3 Year(), Month(), Day(), Today(), Date(), Datedif()
Data Validation
5.4 Entry Restriction, Drop Down List, Custom Rules
Summary, Notes & Assignment
Day 5 Summary
Day 5 Notes
Day 5 Quiz
Day 5 Task
Level 1 Live Doubt Clearance Session - 30th April 2021
Day 6
Day 6 Intro
Security Features
6.1 Security Features
Charts & Graphs
6.2 Graphs
Summary, Notes & Assignment
Day 6 Summary
Day 6 Notes
Day 6 Quiz
Day 6 Task
Day 7
Day 7 Intro
Lookup
7.1 Lookup
Financial Functions
7.2 Financial Functions
Tables
7.3 Tables
Formula Auditing
7.4 Evaluate Formula, Trace Precedents, Trace Dependents
Summary, Notes & Assignment
Day 7 Summary
Day 7 Notes
Day 7 Quiz
Day 7 Task
Day 8
Day 8 Intro
Whatif Analysis
8.1 Scenario Manager, Goal Seek
Pivot Tables
8.2 Pivot Table, Calculated Field, Pivot Slicers, Pivot Charts
Summary, Notes & Assignment
Day 8 Summary
Day 8 Notes
Day 8 Quiz
Day 8 Task 1
Day 8 Task 2
Day 9
Day 9 Intro
Macros
9.1 Macros
Introduction to VBA
9.2 Introduction to VBA
Summary, Notes
Day 9 Summary
Day 9 Notes
Day 9 Quiz
Live Doubt Clearance Session - Level 2 2nd April 2021