Top 10 Basic Excel
Formulas you should Know
1 Average Fruits Name
2 Sum 13 Apple Juice
3 SumIf 12 Orange
4 COUNTIF 16 Apple
5 Counta Formula 18 lemon
6 Count Function 21 Lemon
7 Concatenate 22 Lemon
8 If Function
9 Vlook Up Melon
10 Drop Down List
3 fruits Lemon 4
Sumif 0
5 count 0 6
7 concatenate Apple Juice
8 If items If function
Pencil TRUE
Eraser FALSE
Pen FALSE
fruits Lemon
countif 3
counta 7
SIGN UP FORM
User ID : 1) Select All Data
Password : 2) Ctrl +1
Name : 3) Type= @* :
Country :
Pin Code :
Email :
Serial No Name of the student Percentage
1) Right Click
2) View code
3) [Link] .autofit
ID Name Gender Department Skills
ID1, John, Female, IT, Machine Learning #NAME? #NAME? #NAME? #NAME? #NAME?
ID2, Ram, male, IT, Machine Learning #NAME? #NAME? #NAME? #NAME? #NAME?
ID3, Shyam, male, IT, Programmer #NAME? #NAME? #NAME? #NAME? #NAME?
Ram kumar sharma #NAME?
DATA ENTRY USING VBA MACRO
Roll No
Name 1) Developer
Mobile No 2) Record Macro
Course 3) Macro Name - Update
Fee 4) ok
5)Row insert
6)Copy Record
7) Cursor Roll No -Right Click-Transpose
Roll No Name Mobile No Course Fee 8)Stop Recording
1001 Ramu 987654321 Programming 5400 9)Insert-Form control Button
1001 Ram 9876543219 Training 4900 10) Assign Macro-Select Update-ok
1001 Ajay 9876543210 CCC 4000 11) edit text-update
12) entry & update
Click-Transpose
Roll No Name Class Address
1 Amit XII Patelnagar
2 Ankit XI Rajndranagar
3 Anmol VIII Karolbagh 1)select data-formula
4 Amrit VI Ambassa 2) CTRL+SHIFT+ENTER
Advance Vlookup
Roll No Name Class Address
4 Amrit VI Ambassa
CASH COLLECTION REPORT 1) Select Heading
NAMe Last Name Cash Collected Date 2) ALT+D+O
lect Heading
