UNIT 1 – Introduction to Excel
- Introduction to MS Excel
- Starting Excel and understanding the User Interface
- Copy, Paste, and Paste Special
- Data entry and editing
- Basic cell formatting
- Managing and organizing Excel data
- Using different Excel views
UNIT 2 – Basic to Advanced Functions
- Basic Excel formulas, AutoSum
- Today, Now, Date, Datedif (Date functions)
- Left, Right, Mid, Trim, Substitute (Text functions)
- Convert, Upper, Lower, Proper
- Absolute & Relative Cell Referencing
- Conditional Logic (IF, AND, OR, NOT)
- Multiple Conditional Calculations
- Sumif, Sumifs, Countif, Countifs functions
UNIT 3 – Page Setup & Printing
- Adjusting the page setup
- Setting page orientation
- Adding sheet background
- Page Break Preview
- Print area setup
- Printing with gridlines and headings
UNIT 4 – Worksheet Management
- Adding & deleting rows and columns
- Adding & deleting worksheets
- Renaming and moving sheets
- Protecting sheet, cells, and workbook
- Wrap Text and Merge Cells
UNIT 5 – Charts
- Creating charts
- Different types of charts
- Editing chart design and chart layout
- Axis, legends, and title formatting
- Adding and removing chart data
UNIT 6 – Advanced Editing & Tools
- Using Go To Special
- Merge and Center
- Using comments
- Consolidating data
- Conditional formatting
- Data validation (List, Whole Number, etc.)
- Freeze panes
- Basic use of macros
UNIT 7 – Data Handling & Analysis
- Sorting and filtering data
- Using forms
- Statistical functions
- Data analysis (What-If Analysis)
- Financial functions (PMT, PPMT, IPMT, etc.)
UNIT 8 – Lookup Functions
- VLOOKUP and HLOOKUP
- MATCH and INDEX functions
- VLOOKUP with MATCH
- VLOOKUP with error handling
UNIT 9 – Pivot Table & Pivot Chart
- Introduction to Pivot Table
- Creating a Pivot Table
- Pivot Table fields and formatting
- Updating data into Pivot Table
- Pivot Table layout customization
- Creating a Pivot Chart
