1. Introduction to MS-Excel
Microsoft Excel
Why Should I Learn Microsoft Excel?
Basic Terms in Excel
Microsoft Excel Window Components
2. Data Formatting
Format Column Headings and Totals
Bold Format
Data alignment
Wrap Text
Merge & Center
Borders
Autosum
Quick Insert
3. Basic Excel Formulas
Insert Data into Excel
Simple insertion
SUM
AVERAGE
COUNT
COUNTA
IF
TRIM
MAX & MIN
4. List Sort & Filter
Create a Custom List of Items in Excel
Import a List of Items From Cells
Use Your Custom List
Edit or Delete a Custom List
Create Custom Lists in Excel
Quick sort
Multi-Level Sorting
Custom Sort Order
SUBTOTAL Function
Advanced filter
Filter Data From One Worksheet To Another Excel
5. Bill Invoice Creation
Search and Select an Invoice Template
Edit and Customize the Excel Invoice Template
GST Bill Calculation
What is GST?
Page Layout and Printing
6. Lookups & Function
LOOKUP Function
VLOOKUP function
HLOOKUP function
Nested lookups
7. Advanced & Logical Function
Logical Functions
Cell reference
Income tax calculation
8. Forms & Data
Data Validation
Developer tab
Merge Sheets Remove Duplicates
9. Protection Workbook
Protect a workbook
Record and Run Macro
Assignment 1: Basic Spreadsheet Skills
Assignment 2: Arithmetic Formulas
Assignment 3: Basic Formulas and Functions
Assignment 4: Percentage Calculations
Assignment 5: Date Calculations
Assignment 6: Basic Data Sorting
Assignment 7: Data Sorting and Filtering
Assignment 8: Advanced Data Sorting
Assignment 9: Data Filtering
Assignment 10 : Create a Bill Invoice
Assignment 11 : Lookup and Function
Assignment 12: VLOOKUP function
Assignment 13: HLOOKUP Function
Assignment 14: Nested Lookup Function
Assignment 15: Logical Function
Assignment 16: Advanced Logical Function
Assignment 17: Income Tax Calculation
Assignment 18: GST Bill Calculation
Assignment 19: Data Validation
Assignment 20: Protecting a Worksheet
Assignment 21: Analyzing Sales Data and Creating Dynamic Dashboards
Assignment 22: Building a Financial Model for Investment Analysis
Assignment 23: Analyzing Marketing Campaign Performance and Creating Visualizations
Assignment 24: Optimizing Inventory Control and Analysis
Assignment 25: Personal Budgeting and Expense Analysis
1. Introduction to MS-Excel
Microsoft Excel
Why Should I Learn Microsoft Excel?
Basic Terms in Excel
Microsoft Excel Window Components
2. Data Formatting
Format Column Headings and Totals
Bold Format
Data alignment
Wrap Text
Merge & Center
Borders
Autosum
Quick Insert
3. Basic Excel Formulas
Insert Data into Excel
Simple insertion
SUM
AVERAGE
COUNT
COUNTA
IF
TRIM
MAX & MIN
4. List Sort & Filter
Create a Custom List of Items in Excel
Import a List of Items From Cells
Use Your Custom List
Edit or Delete a Custom List
Create Custom Lists in Excel
Quick sort
Multi-Level Sorting
Custom Sort Order
SUBTOTAL Function
Advanced filter
Filter Data From One Worksheet To Another Excel
5. Bill Invoice Creation
Search and Select an Invoice Template
Edit and Customize the Excel Invoice Template
GST Bill Calculation
What is GST?
Page Layout and Printing
6. Lookups & Function
LOOKUP Function
VLOOKUP function
HLOOKUP function
Nested lookups
7. Advanced & Logical Function
Logical Functions
Cell reference
Income tax calculation
8. Forms & Data
Data Validation
Developer tab
Merge Sheets Remove Duplicates
9. Protection Workbook
Protect a workbook
Record and Run Macro
Assignment 1: Basic Spreadsheet Skills
Assignment 2: Arithmetic Formulas
Assignment 3: Basic Formulas and Functions
Assignment 4: Percentage Calculations
Assignment 5: Date Calculations
Assignment 6: Basic Data Sorting
Assignment 7: Data Sorting and Filtering
Assignment 8: Advanced Data Sorting
Assignment 9: Data Filtering
Assignment 10 : Create a Bill Invoice
Assignment 11 : Lookup and Function
Assignment 12: VLOOKUP function
Assignment 13: HLOOKUP Function
Assignment 14: Nested Lookup Function
Assignment 15: Logical Function
Assignment 16: Advanced Logical Function
Assignment 17: Income Tax Calculation
Assignment 18: GST Bill Calculation
Assignment 19: Data Validation
Assignment 20: Protecting a Worksheet
Assignment 21: Analyzing Sales Data and Creating Dynamic Dashboards
Assignment 22: Building a Financial Model for Investment Analysis
Assignment 23: Analyzing Marketing Campaign Performance and Creating Visualizations
Assignment 24: Optimizing Inventory Control and Analysis
Assignment 25: Personal Budgeting and Expense Analysis
