Advance Excel Course Topics

1 Advance Formulas
2 EMI Calculation
3 Age Calculator App
4 Pivot Table
5 Pivot Chart
6 GST Invoice Billing
7 Stock Management
What Is Excel
Excel is A semi accounting package software
Extension Name Of Excel (2007) .Xls
Extension Name Of Excel (2010) .slsx

Three methods for Open the MS Excel

1. Start → Microsoft Office → Microsoft Office 2007
2. Window button+R RUN Dialog box Open annd type EXCEL
3. GO TO Search And type Excel

Total No. of Rows in Ms Excel 1048576 (Vertical Cells)

Total No. Of Column in Ms Excel 16384 (Horizontal Cells)

How Many sheets Provided by default

Ans:- Three Sheets
Sheet 1
Sheet 2
Sheet 3
 Addition Of Numbers
Roll No. Name Hindi English Total
100 Ashish 90 99 189
101 Bhaskar 80 56 136
102 Champak 89 87 176
103 Deepak 80 76 156
104 Frank 67 65 132
105 Gulshan 56 4 60
106 Heena 33 53 86
107 Istikaar 45 54 99
108 Jannat 65 56 121
109 Karan 67 56 123
110 Lovepreet 90 56 146

Formula
=Sum(D3,C3)

Substraction Of Numbers
Roll No. Name Hindi English Result
100 Ashish 90 99 9
101 Bhaskar 80 56 -24
102 Champak 89 87 -2
103 Deepak 80 76 -4
104 Frank 67 65 -2
105 Gulshan 56 4 -52
106 Heena 33 53 20
107 Istikaar 45 54 9
108 Jannat 65 56 -9
109 Karan 67 56 -11
110 Lovepreet 90 56 -34

Formula
=D21-C21

Multiplication Of Numbers
Roll No. Name Hindi English Result
100 Ashish 90 99 8910
101 Bhaskar 80 56 4480
102 Champak 89 87 7743
103 Deepak 80 76 6080
104 Frank 67 65 4355
105 Gulshan 56 4 224
106 Heena 33 53 1749
107 Istikaar 45 54 2430
108 Jannat 65 56 3640
109 Karan 67 56 3752
110 Lovepreet 90 56 5040
Formula
8910
oty cost oty cost
1 4 1 4 8
1 5 1 8 13

1
01
02
03
04
05 0
06
07
08
09
10
11
12
13
7656753-48568365-348566
23
0
0
 Lookup
Roll no name hindi Eng math Science Roll no 7
1 Rahul 98 54 98 54 name Narinder
2 Pankaj 76 67 76 67 hindi 76
3 Deepak 54 98 54 98 Eng 67
4 Amit 43 90 43 90 math 76
5 Dipesh 29 90 29 90 Science 67
6 Ankit 98 56 98 56
7 Narinder 76 67 76 67
8 Aarti 76 65 76 65 Vlookup
9 Kajal 54 76 54 76 Roll no 7
name Narinder
hindi 76
Eng 67
math 76
Science 67
Roll no name hindi Eng math Science
1 Rahul 98 54 98 54
2 Pankaj 76 67 76 67
3 Deepak 54 98 54 98
4 Amit 43 90 43 90
5 Dipesh 29 90 29 90
6 Ankit 98 56 98 56
7 Narinder 76 67 76 67
8 Aarti 76 65 76 65 Vlookup
9 Kajal 54 76 54 76 Roll no 8
name Aarti
hindi 76
Eng 65
math 76
Science 65
Roll no 1 2 3 4 5 6 7 8 9
name Rahul Pankaj Deepak Amit Dipesh Ankit Narinder Aarti Kajal
hindi 98 76 54 43 29 98 76 76 54
Eng 54 67 98 90 90 56 67 65 76
math 98 76 54 43 29 98 76 76 54
Science 54 67 98 90 90 56 67 65 76

Hlookup
Roll no 6
name Ankit
hindi 98
Eng 56
math 98
 Sr. No Item/Particular Price Price Qty Amount

Total
Discount
taxable Value
CGST
IGST
GST
Grand Total