|
Day
|
Topic
|
Sub-Topic No.
|
Sub-Topic Title
|
Detailed Contents
|
|
Day 1
|
Introduction to Excel
|
1.1
|
What is Microsoft Excel
|
Purpose, applications, real-world use cases
|
|
|
1.2
|
Excel Interface Overview
|
Ribbon, Tabs, Workbook, Worksheet, Formula Bar, Status Bar
|
|
|
1.3
|
Creating and Saving Workbooks
|
New workbook, save options, file formats
|
|
|
1.4
|
Basic Navigation and Shortcuts
|
Cell selection, scrolling, keyboard shortcuts
|
|
Day 2
|
Data Entry and Formatting
|
2.1
|
Entering Data
|
Text, numbers, dates, AutoFill
|
|
|
2.2
|
Formatting Cells
|
Font, alignment, borders, colors, number formats
|
|
|
2.3
|
Managing Rows and Columns
|
Insert, delete, resize, hide/unhide
|
|
Day 3
|
Formulas and Functions
|
3.1
|
Writing Formulas
|
Arithmetic operations, cell references
|
|
|
3.2
|
Common Functions
|
SUM, AVERAGE, MIN, MAX, COUNT
|
|
|
3.3
|
Relative vs Absolute References
|
Use of $ in formulas, practical examples
|
|
Day 4
|
Worksheet and Data Tools
|
4.1
|
Managing Worksheets
|
Rename, move, copy, delete, freeze panes
|
|
|
4.2
|
Sorting and Filtering
|
Sort by value, custom sort, filter by condition
|
|
|
4.3
|
Data Validation
|
Drop-down lists, input restrictions
|
|
Day 5
|
Charts and Visualization
|
5.1
|
Creating Charts
|
Column, Line, Pie charts
|
|
|
5.2
|
Customizing Charts
|
Titles, legends, labels, colors
|
|
|
5.3
|
Conditional Formatting
|
Highlighting rules, data bars, color scales
|
|
Day 6
|
Page Setup and Applications
|
6.1
|
Page Layout and Printing
|
Margins, orientation, scaling, print preview
|
|
|
6.2
|
Exporting and Sharing
|
Save as PDF, sharing options
|
|
|
6.3
|
Practical Use Cases
|
Budget sheet, attendance tracker, grade calculator
|