arrow_back
MS EXCEL COURSE OVERVIEW
Lesson 1 - Introduction to MS Excel
1.1 - Understanding About Excel Interface
1.2 - QUICK ACCESS TOOLBAR
1.3 - Workbook, Worksheets, Cells, Rows, and Columns
Lesson 2: Data Entry and Formatting
2.1 - Data Entry - Entering data into cells
2.2 - Data Formatting - Basic text formatting
2.3 - Data Formatting : Basic Number formatting
Lesson 3 - Basic Shortcut Keys, Templates & Help Menu
3.1 - MS Excel Basic Shortcut Keys
3.2 - Understanding Help Menu in Excel
3.3 - Understanding MS Excel Templates
Lesson 4 - Introduction to Formulas
4.1 - Understanding Excel Basic Functions
4.2 - IF And Nested IF Function in Excel
4.3 - Relative and Absolute Reference
4.4 - SUMIF & SUMIFS Function
4.5 - COUNTIF & COUNTIFS Functions
Lesson 5 - Worksheet Formatting
5.1 - Excel Sheet Formatting - Part 1
5.2 - Excel Sheet Formatting - Part 2
5.3 - Conditional Formatting in Excel - Part 1
Lesson 6 - Charts & Graphs
6.1 - How to Draw Charts and Graphs
Lesson 7 - Sorting and Filtering Data
7.1 - How to Sort Data in Excel
7.2 - Data Filters in MS Excel
7.3- Advance Filter in MS Excel
Lesson 8 - Excel Page & Print Setup
8.1 - Mastering Page Setup in MS Excel
8.2 - How to Print Large Data in Excel Quickly
8.3 - Page Numbering In Excel
Lesson 9 - Advance Features of MS Excel
9.1 - Macros in MS Excel
9.2 - Excel Interatve Dashboard
Lesson 10 - Excel AI Tools
10.1 - Excel Data Cleaning using AI
10.2 - Convert Image to Text Using AI
10.3 - Excel Number to Words using AI
Tips and Tricks
Excel Crtl + A TO Z Shortcut Keys
Part 1 - Time Saving Excel Tips and Tricks
Part 2 -Time Saving Excel Tips and Tricks
Part 3 - Excel Time Saving Shortcut Keys
Part 1 - Data Entry Tips & Tricks
Part 2 - Data Entry Using Forms
Part 3 - Data Entry Tips & Tricks