ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DaysTopics CoveredSession Duration
2
Day 1Introduction of Excel , What is Excel ,Opening of Spread Sheet ,Save and Save As, Open, Print Preview, Intro of Excel Function2hr
3
Day 2Home Tab, Cut copy Paste cell2hr
4
Font style change ,Alignment,
5
Merge Cell, Wrap Text, Number style With Sheets project
6
7
Day 3Home tab, Number ,Styles Cells, conditional Formatting2hr
8
Editing, Insert cell, Delete cell, Format cell, Find, Replace, Short filter With Sheets Project
9
Day 4Insert Tab – Tables, Illustrations, Table Format, Picture Insert, Shapes, Online Picture, Smart art, My add – ins, Store, transform Data,2hr
10
11
Day 5Insert Tab- Charts, Recommended Charts, Pivot chart, 3d Map, Hyperlink, slicer, Text style, Symbol2hr
12
Day 6Page Layout- Themes, Page Setup, Sheet margin, Print area Scale to fit ,Sheet Options, Arrange ,Background Change 2hr
13
Selection Pane, Align, Group, Rotate, Size , Sheet Orientation
14
Day 7Review Tab- Spelling Check2hr
15
Research, Thesaurus
16
Translate, AddComment
17
Changes, Sheet Protect, Protect workbook
18
19
Day 8View Tab - Workbook View2hr
20
Show and Hide, Normal View, New window, Arrange all Freeze Pane, Spilt, Zoom
21
Window, Macros
22
23
Day 9Class Test2hr
24
Advance Excel Class Schedule
25
DaysTopics CoveredSession Duration
26
Day 10Formula Bar- Insert Function ,Auto Sum , Recently Used, Financial ,logical, Text,2hr
27
Logical, lookup Value
28
Day 11Formula Bar- Defined Name ,Function Library track precedent, Trace dependents2hr
29
Remove arrow, Formula auditing
30
31
Day 12Data Tab – Get External Data, Show Queries, Form Table, Connections, Filter, Advanced filter, Sort data with sheets projects2hr
32
33
Day 13Data Tab – Group and Ungroup, Flash fill Text to columns Data Validation Consolidate, Ouutline, Group Ungroup, Subtotal, Text to columns2hr
34
35
Day 14Sheets Projects2hr
36
V- lookup, H-lookup, Pivot table, Recommended Pivot table, Flash Fill, Marksheet, Attendance sheet
37
Day 15Sheets Projects2hr
38
Payroll Slip, Chart design, Pmt sheet, Ipmt Sheet, Salary Sheet, Bank Chart
39
40
Day 16Class Test2hr
41
Day 17Final Exam3hr
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100