PIIT Excel GS Topics 1

	A	B	C	D	E
1
2	ser	sheet	description	excelFunctions	DateCov

3	1	S1	Sample Data1	Student Data 1
4	2	S2	Sample Data2	Student Data 2
5	3	S3	Sample Data3	Student Data 3
6	4	M1	GS Menu	Menu Structure of Google Sheets
7	5	F1	Functions
8	6	F2	Functions 2
9	7	ST1	Statistical Functions
10	8	PT1	Pivot Table 1
11	9	IF1	IF Functions
12	10	TR	Transpose
13	11	VL	V Lookup
14	12	HL	H Lookup
15	13	XL	X Lookup
16	14	FT	Freq Table
17	15	SR1	Sorting Data
18	16	RK	Ranking Data
19	17	JN	Join Data
20	18	FL	Filter Data
21	19	IN	Indirect Functions
22	20	IM1	Import Sheet
23	21	SC	Scenario
24	22	SN	Senstivity
25	23	TL	Tool pack
26	24	DC1	Data Cleaning1
27	25	DC2	Data Cleaning2
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
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