Become a Master in Excel
-
1
Opening Excel Various Methods,Number of Columns & Rows, Cells -
2
Toolbar, Ribbon, Tabs, Groups, Features
-
3
Various Methods of Sheet navigation
-
4
Basic and frequently used shortcuts
-
5
Freezing Panes
-
6
Referencing Techniques: Relative & Absolute Referencing
-
7
Referencing Techniques: Partial Referencing
-
8
Basic Arithmatic Functions: COUNT v/s COUNTA & COUNTBLANK
-
9
Basic Text Functions: Basic Arithmatic Functions: SUM, AVERAGE, MIN, MAX
-
10
Basic Text Functions: CONCATENATE & operator, LEN , EXACT, LEFT, RIGHT, MID
-
11
Basic Text Functions: UPPER, LOWER, PROPER
-
12
-
13
-
14
-
15
-
16
-
17
-
18
-
19
-
20
-
21
-
22
-
23
-
24
-
25
-
26
-
27
-
28
-
29
-
30
-
31
-
32
-
33
-
34
-
35
-
36
-
37
-
38
-
39
-
40
-
41
-
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
