Sr.

No Formulas Name Home

1 Sum & Auto Sum Formula END
2 Sumif Formula MAIN DATA
3 Unique Formula DASHBOARD
4 Sumifs Formula EMP INFO
5 Product Formula (*)
6 Sumproduct Formula
7 Running Total
8 Formulatext Formula
9 Dynamic Formulas
10 Average Formula
11 Averageif Formula
12 Iferror Formula
13 Averageifs Formula
14 LEN Magical Formula
15 Max Formula
16 Large Formula
17 Min Formula
18 Small Formula
19 Rank Formula
20 Count Formula
21 Counta Formula
22 Countblank Formula
23 Countif Formula
24 Countifs Formula
25 Subtotal Formula
26 Percentage Calculation
27 Percentof Formula
28 Rand Formula
29 Randbetween Formula
30 Abs Formula
31 Convert Formula to Value
32 Text Formula
33 Upper Formula
34 Lower Formula
35 Proper Formula
36 Concatenate Formula + Change Case
37 & Formula
38 Textjoin Formula
39 Left Formula
40 Right Formula
41 Mid Formula
42 Flash Fill Magic
43 Textbefore Formula
44 Textafter Formula
45 Trim Formula
46 Transpose Formula
47 Textsplit Formula
48 Now & Today
49 Date Formula
50 Day, Month & Year Formula
51 Days Formula
52 Edate Formula
53 Eomonth Formula
54 Datedif Formula
55 Workday Formula
56 Workday.intl Formula
57 Networkdays Formula
58 Networkdays.intl Formula
59 IF Formula
60 IF + And Formula
61 IF + OR Formula
62 IFS Formula
63 Vlookup Formula
64 Hlookup Formula
65 Match Formula
66 Index Formula
67 Index + Match Formula
68 Xlookup Formula
69 DSUM
70 Filter Formula
71 VLOOKUP FORMULA 1
72 Color Sorting
73 Customized Sorting
74 Important Statistical& Mathematical Function
75 PIVOT
#VALUE! MS Excel Formulas
Deven U Pandey
Founder and CEO
#VALUE!

"अंदर-बाहर ईमानदार, आपका भरोसा हमारी ताकत"

mulas #VALUE!
Raj Singh
Microsoft Certified Trainer

सा हमारी ताकत"
 1 Sum & Auto Sum Formula
Home
Product Name Region Jan Feb Mar
Tablet East 15000 22000 18000
Speaker West 27000 10500 8500
Webcam North 9200 8800 32000
Tablet East 33000 29000 21000
Speaker West 17500 14200 11200
Webcam North 18500 19000 24500
Tablet East 11000 17000 14000
Speaker West 8700 9500 7600
139900 130000 136800

Product Name Region Amount

Keyboard East 12000
Keyboard West 34000
Keyboard East 76000
Total 122000
Mouse West 45000
Mouse North 44000
Mouse East 2500
Total 91500
Printer West 6500
Printer West 6501
Total 13001
Total
55000
46000
50000
83000
42900
62000
42000
25800
406700
 2 Sumif Formula
Home
Product Name Region Amount
Tablet East 18000
Speaker West 7400
Webcam North 32000
Tablet East 26000
Speaker West 9200
Webcam North 6200
Tablet East 29000
Speaker West 6100
Webcam North 6100
Tablet East 27000

Product Name Region Amount

Keyboard East 34000
Usb Mouse West 5000
Monitor 15 inch North 76000
Rgb Keyboard East 45000
Wireless Mouse West 8700
Monitor 24 inch North 5600
Rgb Keyboard East 45000
Mouse West 5600
Monitor North 5600
Keyboard East 45000
Product Name Amount
webcam 44300

Product Name Amount

0
 3 Unique Formula
Home
Product Name Region Amount
Tablet East 19500
Speaker West 6400
Webcam North 28500
Tablet East 31000
Speaker West 7900
Webcam North 7200
Tablet East 27000
Speaker West 6100
Router North 6000
Tablet East 25000

Product Name Region Amount

Keyboard East 34000
Usb Mouse West 5000
Monitor 14 inch North 76000
Rgb Keyboard East 45000
Wireless Mouse West 8700
Monitor 14 inch North 5600
Rgb Keyboard East 45000
Mouse West 5600
Monitor North 5600
Keyboard East 45000
Product Name Amount
Router 6000 #NAME?
#NAME?
#NAME?
#NAME?

Product Name Amount

 4 Sumifs Formula
Home
Product Name Region Amount
Shirt East 18500
Trousers North 7200
Blazer North 30500
Shirt East 26000
Trousers West 8900
Blazer North 6800
Shirt South 24500
Trousers North 6400
Jacket North 6000
Shirt South 27500

Product Name Region Amount

Tablet 10 inch East 21000
Bluetooth Speaker West 6200
Webcam Pro HD North 31500
Tablet 10 inch East 29000
Smart Speaker West 9400
Webcam Pro HD North 7200
Tablet 10 inch East 27500
Smart Speaker West 6800
Webcam Mini North 6100
Tablet 10 inch East 25500
Product Name Region Amount
trousers west 8900

Product Name Region Amount

Smart Speaker North
 5 Product Formula (*)
Home
Product Name Region Qty Price
Kurta East 15 ₹ 450
Jeans North 35 ₹ 249
Sweater North 45 ₹ 4,400
Kurta East 250 ₹ 700
Jeans West 8 ₹ 260
Sweater North 38 ₹ 5,450
Kurta South 90 ₹ 5,600
Jeans North 60 ₹ 205
Coat North 12 ₹ 3,900
Kurta South 10 ₹ 280

Numbers
2
4
5
7
5
4
5
7
196000
Amount
₹ 6,750
₹ 8,715
₹ 198,000
₹ 175,000
₹ 2,080
₹ 207,100
₹ 504,000
 6 Sumproduct Formula
Home
Product Name Region Qty Price
Chips East 12 ₹ 300
Cookies North 30 ₹ 249
Popcorn North 450 ₹ 4,400
Chips East 18 ₹ 300
Cookies West 6 ₹ 260
Popcorn North 42 ₹ 5,400
Chips South 95 ₹ 5,600
Cookies North 55 ₹ 200
Namkeen North 15 ₹ 3,700

Total Amount
Amount
₹ 3,600
₹ 7,470
₹ 1,980,000
₹ 5,400
₹ 1,560
₹ 226,800
₹ 532,000
₹ 11,000
₹ 55,500

₹ 2,823,330
 7 Running Total
Home
Date Product Name Amount Running Total
1/1/2024 Samosa 180 180
1/2/2024 Chips 220 400
1/3/2024 Popcorn 170 570
1/4/2024 Nachos 250 820
1/5/2024 Chips 130 950
1/6/2024 Popcorn 370 1320
1/7/2024 Nachos 280 1600
1/8/2024 Chips 360 1960
1/9/2024 Popcorn 420 2380
 8 Formulatext Formula
Home
Date Product Amount Running Total
1/1/2024 Samosa 180 180
1/2/2024 Chips 220 400
1/3/2024 Popcorn 170 570
1/4/2024 Nachos 250 820
1/5/2024 Chips 130 950
1/6/2024 Popcorn 370 1320
1/7/2024 Nachos 280 1600
1/8/2024 Chips 360 1960
1/9/2024 Popcorn 420 2380
g Total
=SUM($D$4:D4)
=SUM($D$4:D5)
=SUM($D$4:D6)
=SUM($D$4:D7)
=SUM($D$4:D8)
=SUM($D$4:D9)
=SUM($D$4:D10)
=SUM($D$4:D11)
=SUM($D$4:D12)
 9 Dynamic Formulas
Home
Date Product Name Amount
1/1/2024 Webcam 180
1/2/2024 Headphones 220
1/3/2024 Projector 170
1/4/2024 Tripod 250
1/5/2024 Headphones 130
1/6/2024 Projector 370
1/7/2024 Tripod 280
1/8/2024 Headphones 360
1/9/2024 Projector 420
1/9/2024 Projector 34343
Amount
36723
 10 Average Formula
Home
Product Name Region Jan Feb Mar
Biscuit East 15000 28000 22000
Namkeen West 22000 9500 7300
Chocolate North 8200 11000 31000
Biscuit East 32000 26000 28000
Namkeen West 19000 8500 9100
Chocolate North 27000 15000 9200
Biscuit East 6300 18000 17000
Namkeen West 7200 26000 8300

Product Name Region Amount

Tablet East 21000 29200
Speaker West 8900
Webcam North 32500
Tablet East 27500
Speaker West 9200
Webcam North 9100
Tablet East 29000
Speaker West 96400
Average
21666.667
12933.333
16733.333
28666.667
12200
17066.667
13766.667
13833.333
 11 Averageif Formula
Home
Product Name Region Amount
Notebook East 19500
Pencil Box West 6200
School Bag North 31500
Notebook East 28500
Pencil Box West 9400
School Bag North 7200
Notebook East 27000
Pencil Box West 6800
Product Name Avg. Sale
Pencil Box 7466.667
 12 Iferror Formula
Home
Product Name Region Amount
Necklace East 22500
Earrings West 5800
Bracelet North 29800
Necklace East 31000
Earrings West 9100
Bracelet North 6900
Necklace East 28000
Earrings West 6600
Product Name Avg. Sale
Earrings 7166.6666667

#N/A
#VALUE!
#DIV/0!
 13 Averageifs Formula
Home
Product Name Region Amount
Necklace East 13500
Earrings North 28500
Bracelet North 7200
Necklace East 33000
Earrings North 32000
Bracelet North 25000
Necklace South 4600
Earrings West 7300
Product Name Region Amount
Necklace East 23250
 14 LEN Magical Formula
Home
Product Name Description (15 - 50 character )
Tablet 10-inch Android tablet, black
Speaker
Webcam HD 1080p webcam with mic
Speaker
Speaker
Phone No
 15 Max Formula
Home
Product Name Region Jan Feb
Birthday Cap East 15000 32000
Candle Set West 28000 9100
Balloon Pack North 8200 9200
Birthday Cap East 8100 26500
Candle Set West 19000 8700
Balloon Pack North 27000 15000
Birthday Cap East 6300 18000
Candle Set West 7200 26000
Mar Max Sale 32000
22000
7300
31000
29000
9100
9200
17000
8300
 16 Large Formula
Home
Product Name Region Jan Feb
Burger East 15500 29500
Fries West 28500 9400
Pizza North 8200 99600
Burger East 34000 28000
Fries West 26500 8700
Pizza North 27000 14000
Burger East 6300 17500
Fries West 7900 21000
Mar 1st Largest Sale 99600
22000 2nd largest Sale 34000
7200 3rd largest sale
30500
31000
9100
9800
16500
8600
 17 Min Formula
Home
Product Name Region Jan Feb
Samosa East 15500 29500
Pakoda West 28500 9400
Vada Pav North 8200 99600
Samosa East 34000 28000
Pakoda West 26500 8700
Vada Pav North 27000 14000
Samosa East 6300 17500
Pakoda West 7900 21000
Mar Min Sale 6300
22000
7200
30500
31000
9100
9800
16500
8600
 18 Small Formula
Home
Product Name Region Jan Feb
Apple East 15500 29500
Banana West 28500 9400
Mango North 8200 99600
Apple East 34000 28000
Banana West 26500 8700
Mango North 27000 14000
Apple East 6300 17500
Banana West 7900 21000
Mar 1st Smallest Sale 6300
22000 2nd Smallest Sale 7200
7200 3rd Smallest sale
30500
31000
9100
9800
16500
8600
 19 Rank Formula
Home
Stu_Name Phy Che Mat Total Marks
Aryan 58 49 47 154
Nisha 42 60 72 174
Rohan 67 59 35 161
Payal 54 53 70 177
Mital 81 61 42 184
Isha 51 92 66 209
Karan 78 87 60 225
Tanya 89 71 85 245
Rank
1
3
2
4
5
6
7
8
 20 Count Formula
Home
Stu_Name Total Marks
Aryan 154 6
Nisha 174
Rohan A
Payal 177
Mital A
Isha 209
Karan 225
Tanya 245
 21 Counta Formula
Home
Values
154 6
174
xyz
177
#N/A

225
 22 Countblank Formula
Home
Stu_Name Total Marks Countblank
Aryan 154 2
Nisha 174
Rohan
Payal 177
Mital
Isha 209
Karan 225
Tanya 245
untblank

154
174
161
177
184
209
225
245
 23 Countif Formula
Home
Product Name Region Amount
Cricket Bat East 19500
Yoga Mat West 6200
Gym Gloves North 31500
Table Mat East 28500
Tennis Racket West 9400
Skipping Rope North 7200
Punch Bag East 27500
Hockey Stick West 6400
Goal Post North 5900
Table Mat East 25500

Home

Product Name Region Amount

Air Cooler East 34000
Hand Blender West 5000
LED TV North 76000
Rice Cooker East 45000
Electric Fan West 8700
LED TV North 5600
Induction Stove East 45000
Mixer Grinder West 5600
LED TV North 5600
Steam Iron East 45000
Product Name Total Records
Table mat 2

Region Total Records

east 4

Product Name Total Records

Air Cooler
 24 Countifs Formula
Home
Product Name Region Amount
Pen East 19500
Eraser West 6200
Scale North 31500
Pen East 28500
Eraser West 9400
Scale North 7200
Pen East 27500
Eraser West 6400
Sharpener North 5900
Pen East 25500

Product Name Region Amount

Pencil East 34000
Eraser West 5000
Notebook North 76000
Pencil Box East 45000
Sharpener West 8700
Notebook North 5600
Pencil Box East 45000
Ruler West 5600
Drawing Book North 5600
Pencil East 45000
Product Name Region Total Records
pen east 4

Product Name Region Total Records

Pencil Box
 25 Subtotal Formula
Home
Total Qty 10 Total Amt.

Product Name Region Qty Price

Webcam North 5 280
Webcam North 5 150
 Total Rec. 2

Amount
1400
750
 26 Percentage Calculation
Home
Stu_Name Phy Che
Tanya 76 95
Payal 86 64
Karan 65 63
Aryan 30 52
Rohan 62 42
Mital 89 99
Isha 86 50
Nisha 91 75

Max. Marks Marks Obt. %

200 140 70%

Emp_Name Salary Donate 5%

Aditya 14500 725
Bhavna 11500 575
Chirag 15800 790
Deepika 23000 1150
Eshan 13500 675
Farah 12000 600
Gaurav 98000 4900
Ravi 21000 1050
Mat Total Marks %
61 232 77%
38 188 63%
29 157 52%
68 150 50%
44 148 49%
66 254 85%
76 212 71%
90 256 85%

10% Increment
15950
12650
17380
25300
14850
13200
107800
23100
 27 Percentof Formula
Home
Product Name Qty
Notebooks 125 13%
Pencils 200 #NAME?
Geometry Boxes 60 #NAME?
Whiteboard Markers 40 #NAME?
Chalk Boxes 25 #NAME?
School Bags 35 #NAME?
Water Bottles 350 #NAME?
Drawing Sheets Pack 70 #NAME?
ID Card Holders 90 #NAME?
100%
 28 Rand Formula
Home
Product Name Values
Football 0.6138059
Cricket Bat 0.059082
Badminton Racket 0.03343
Basketball 0.1471177
Tennis Ball 0.722474
Table Tennis 0.9172734
Skipping Rope 0.2916492
Hockey Stick 0.0473618
Volleyball 0.3475259
 29 Randbetween Formula
Home
Stu_Name Phy Che Mat
Tanya 15 5 89
Payal 16 36 13
Karan 50 53 76
Aryan 20 54 19
Rohan 19 54 67
Mital 81 20 28
Isha 86 74 9
Nisha 40 10 66
Total Marks %
 30 Abs Formula
Home
Debit and credit Amount
-2000 2000
5000 5000
10000 10000
-5000 5000
-12000 12000
-2500 2500
1500 1500
-1350 1350
39350
 31 Convert Formula to Value
Home
Stu_Name Phy Che Mat Total Marks
Tanya 46 95 61 202
Payal 86 64 38 188
Karan 65 63 23 151
Aryan 30 52 68 150
Rohan 62 42 44 148
Mital 82 90 66 238
Isha 56 50 76 182
Nisha 91 75 90 256
%
67%
63%
50%
50%
49%
79%
61%
85%
 32 Text Formula
Home
Credit Card No.
1231231231231230 1231 2312 3123 1230
1231231231231230 1231 2312 3123 1230
1231231231231230 1231 2312 3123 1230
1231231231231230 1231 2312 3123 1230

Amount
500 price is $500
200 price is $200
800 price is $800
40 price is $40
Dates
3/1/2024 Fri, Mar 2024 Friday
4/1/2024 Mon, Apr 2024 Monday
6/1/2024 Sat, Jun 2024 Saturday
3/1/2024 Fri, Mar 2024 Friday

Dates
3/1/2024 March - 2024
4/1/2024 April - 2024
6/1/2024 June - 2024
3/1/2024 March - 2024
 33 Upper Formula
Home
Product Name Product Name
Bread BREAD
Chips CHIPS
Juice JUICE
APPLE APPLE
Cake CAKE
Rice RICE
JAM JAM
Nuts NUTS
Milk MILK
 34 Lower Formula
Home
Product Name Product Name
MILK milk
Butter butter
Cheese cheese
CURD curd
Ghee ghee
Cream cream
Paneer paneer
LASSI lassi
Buttermilk buttermilk
 35 Proper Formula
Home
Product Name Product Name
Wallet Wallet
Sunglasses Sunglasses
Watch Watch
Belt Belt
SHOES Shoes
TIE Tie
Backpack Backpack
CAP Cap
Perfume Perfume
 36 Concatenate Formula + Change Case
Home
First Name Middle Name Last Name
raj kumar singh
Monu Sharma
JK rakesh kumar
Raju Singh Tewatia
amit jain
+ Change Case
Full Name
raj_kumar_singh
Monu Sharma
JK rakesh kumar
Raju Singh Tewatia
amit jain
 37 & Formula
Home
First Name Middle Name Last Name
raj kumar singh
Monu Sharma
JK rakesh kumar
Raju Singh Tewatia
amit jain

Amount
550 Price is = 550
345 Price is = 345
33 Price is = 33
Full Name
raj kumar singh
Monu Sharma
JK rakesh kumar
Raju Singh Tewatia
amit jain
 38 Textjoin Formula
Home
First Name Middle Name Last Name
raj kumar singh
Monu Sharma
JK rakesh kumar
Raju Singh Tewatia
amit jain
Full Name
raj_kumar_singh
Monu_Sharma
JK_rakesh_kumar
Raju_Singh_Tewatia
amit_jain
 39 Left Formula
Home
Add. Pincode
110062,delhi,9999999999 110062
121102,palwal,4444444444 121102
140003,punjab,3333333333 140003
121102,palwal,4456555555 121102

delhi,110062,4444444444 5
faridabad,130001,3333333333 10
palwal,121102,2222222222 7
delhi
faridabad
palwal
 40 Right Formula
Home
Add. Phone
110062,delhi,9999999999 9999999999
121102,palwal,4444444444 4444444444
140003,punjab,3333333333 3333333333
121102,palwal,4456555555 4456555555

Phone
91224567890 9122****890
91224567891 9122****891
91224567892 9122****892
91224567893 9122****893
 41 Mid Formula
Home
IFSC Code
IBXYZC2343454A 2343454
IBXYZC2343455A 2343455
IBXYZC2343456A 2343456
IBXYZC2343457A 2343457
 42 Flash Fill Magic AI
Home
IFSC Code
IBXYZC2343454A 2343454
IBXYZC2343455A 2343455
IBXYZC2343456A 2343456
IBXYZC2343457A 2343457

Add. City
110062,delhi,9999999999
121102,palwal,4444444444
140003,punjab,3333333333
121102,palwal,4456555555

First Name Middle Name

raj kumar
Sonu
DK rakesh
Ram Singh
amit

Product Name Product Name

KEYBOARD
Wireless Mouse
Monitor
SCANNER
 data 2

Phone

Last Name Full Name

singh
Sharma
kumar
Tewatia
jain
Empcode First Name Last Name Dept Region
2 Suman Shinde Sales east
10 Andre Fernendes Mktg east
13 Meera Lalwani Finance east
17 aalok Trivedi Admin east
21 Satinder Kaur Sasan Mktg east
26 Bharat Shetty Sales east
30 Aalam Qureshi Personnel east
41 Kirtikar Sardesai Admin east
42 Pooja Gokhale R&D east
44 Shaheen Khan Personnel east
54 Vishal Virsinghani CCD east
55 Lalita Rao CCD east
65 Timsi Desai CCD east
70 Reeta Naik Mktg east
74 Nita Pandhya Sales east
75 Suraj Saksena Admin east
82 Kalpana Shirishkar R&D east
84 Pinky Robert R&D east
91 Niki Digaria Sales east
92 Payal Singhani Mktg east
1 Raja Raymondekar Sales north
4 Beena Mavadia Mktg north
5 Seema Ranganathan R&D north
6 Julie D'Souza R&D north
8 Neena Mukherjee R&D north
9 Pankaj Sutradhar Sales north
12 Shilpa Lele Admin north
15 K. Sita Narayanan Personnel north
16 Priya Shirodkar Personnel north
19 Parvati Khanna Mktg north
20 Farhan Sadiq Mktg north
29 Hajra Hoonjan Admin north
31 Giriraj Gupta R&D north
33 Tapan Ghoshal CCD north
34 Zarina Vora CCD north
38 Chitra Pednekar Finance north
39 Sheetal Dodhia Finance north
45 Kinnari Mehta R&D north
46 Jeena Baig Sales north
47 Vicky Joshi Admin north
51 Mario Fernandes Sales north
52 Heena Godbole CCD north
58 Maya Panchal Mktg north
61 Anuradha Zha Admin north
62 Asha Trivedi Sales north
63 Waheda Sheikh R&D north
66 Parul Shah Personnel north
67 Uday Naik Personnel north
68 Mandakini Desai Sales north
69 Pravin Joshi Personnel north
73 Laveena Shenoy CCD north
77 Drishti Shah R&D north
79 Sagar Bidkar Mktg north
80 Dayanand Gandhi Mktg north
83 Kunal Shah CCD north
85 Ruby Joseph R&D north
86 Sonia Sasan CCD north
89 Tejal Patel Sales north
90 Priyanka Mehta R&D north
98 Chetan Dalvi CCD north
3 Kuldeep Sharma Admin south
14 Sheetal Desai Director south
25 Jasbinder Khurana R&D south
27 Rishi Malik Sales south
32 Ankur Joshi CCD south
35 Arun Joshi Mktg south
37 Shilpa Parikh Finance south
40 Richa Raje Sales south
49 Rakesh Kumar CCD south
 57 Katti Surti Sales south
59 Disha Parmar Admin south
60 Geeta Darekar Mktg south
64 Veena Patil Personnel south
72 Yamini Gupta R&D south
81 Tara Phule CCD south
87 Jignesh Tripathi Mktg south
93 Harsha Trivedi Sales south
95 Kabir Vora Mktg south
97 Pushpa Raut R&D south
100 Rupesh Sawant Finance south
7 Deepak Jain Personnel west
11 Sujay Madhrani Finance west
18 Aakash Dixit Admin west
22 Suchita Panchal Mktg west
23 Shazia Sheikh Mktg west
24 Pooja Nimkar Sales west
28 Mala Bhaduri R&D west
36 Pooja Khetan Personnel west
43 Piyush Surti Personnel west
48 Neha Joshi CCD west
50 Ruheal Baig Personnel west
53 Mehul Sheth CCD west
56 Kajal Joglekar Sales west
71 Surendra Godse R&D west
76 Nayeem Khan CCD west
78 Deep Chhaya Sales west
88 Vinit Shrivastava Mktg west
94 Radhika Kulkarni Mktg west
96 Beena Sharma R&D west
99 Indu Shah Finance west
Branch Hiredate Salary
Cuttack 1-Jan-77 17500
Darjeeling 20-Jul-77 15750
Calcutta 11-Dec-84 19250
Cuttack 1-Mar-83 15750
Patna 6-Jun-99 7875
Cuttack 1-Oct-82 19250
Patna 19-Oct-88 14175
Darjeeling 14-Jun-97 7875
Calcutta 29-Sep-91 13300
Cuttack 17-Nov-90 13825
Gangtok 3-Mar-95 15750
Guwahati 1-Nov-86 15750
Calcutta 26-Oct-88 17500
Calcutta 4-Mar-95 14000
Darjeeling 24-Oct-88 17500
Calcutta 25-Oct-88 17500
Cuttack 1-Nov-88 17500
Calcutta 3-Mar-99 7000
Calcutta 13-Nov-79 22750
Gangtok 5-Apr-89 17325
Ferozepur 1-Jan-77 21875
Delhi 24-Nov-79 12250
Kanpur 4-Sep-89 21000
Mathura 4-Sep-88 12425
Agra 4-Sep-89 12425
Ambala 12-Dec-99 14875
Jammu 1-Mar-83 21000
Jammu 13-Dec-84 14875
Jaipur 14-Dec-84 14875
Mathura 13-Aug-86 10500
Jaipur 5-Jun-99 5950
Jaipur 4-May-96 9625
Agra 1-Oct-82 15750
Ambala 7-Jul-97 7000
Lucknow 29-Sep-91 8750
Aligarh 1-Oct-82 24500
delhi 1-Oct-82 24500
Ferozepur 7-Jul-97 11375
Lucknow 29-Sep-91 15750
Kanpur 7-Feb-88 15750
Jammu 20-Oct-88 15750
Lucknow 21-Oct-88 19250
Agra 5-Nov-90 17500
Agra 25-Nov-87 19250
Kanpur 26-Nov-87 19251
Jammu 24-Oct-88 17500
Agra 27-Oct-88 17500
Lucknow 28-Oct-88 20125
delhi 1-Dec-95 14000
delhi 3-Mar-95 14000
Jaipur 23-Oct-88 17500
Delhi 27-Oct-88 17500
Delhi 29-Oct-88 17500
Ferozepur 30-Oct-88 17500
Aligarh 2-Mar-99 7000
Agra 14-Jan-98 7000
Jammu 15-Jan-98 17500
Aligarh 21-Feb-79 22750
Jaipur 6-Jan-80 22750
Delhi 11-Apr-89 17325
Hydrabad 1-Mar-99 7000
cochin 12-Dec-84 49000
Manglore 24-Apr-99 7875
Banglore 2-Jul-92 13125
Manglore 1-Oct-82 15750
Manglore 5-May-92 9275
Mysore 1-Oct-82 24500
Manglore 29-Sep-91 10500
cochin 19-Oct-88 15750
chennai 9-May-93 14875
Banglore 14-Jan-87 19250
Trivanadrum 24-Nov-87 19250
Hydrabad 25-Oct-88 17500
Mysore 22-Oct-88 17500
chennai 31-Oct-88 17500
Hydrabad 16-Jan-98 17500
Banglore 6-Apr-89 17325
Banglore 8-Apr-89 17325
Trivanadrum 10-Apr-89 17325
Hydrabad 2-Feb-99 7875
Pune 17-Aug-90 12425
Pune 21-Dec-85 14875
Nasik 1-Mar-83 15750
Nasik 7-Jun-99 7875
Pune 8-Jun-99 7875
Nasik 21-May-80 14875
Mumbai 19-Mar-95 10500
Surat 3-Sep-94 11725
Mumbai 19-Oct-88 15750
Baroda 19-Oct-88 15750
Baroda 19-Oct-88 15750
Nagpur 1-Dec-95 15750
Nagpur 1-Oct-92 14875
Panji 5-Mar-95 14000
Panji 26-Oct-88 17500
Mumbai 28-Oct-88 17500
Pune 30-Dec-97 7875
Surat 7-Apr-89 17325
Nagpur 9-Apr-89 17325
Mumbai 30-Dec-97 10500
 43 Textbefore Formula
Home
Add. Phone
110062,delhi,9999999999 110062,delhi
121102,palwal,4444444444 121102,palwal
140003,punjab,3333333333 140003,punjab
121102,palwal,4456555555 121102,palwal
 44 Textafter Formula
Home
Add. Phone
110062,delhi,9999999999 9999999999
121102,palwal,4444444444 4444444444
140003,punjab,3333333333 3333333333
121102,palwal,4456555555 4456555555
 45 Trim Formula
Home
Full Name
raj kumar singh
Sonu Sharma
DK rakesh kumar
Ram Singh Tewatia
raj rathore
Monu Sharma
rakesh kumar
Ram Singh Tewatia
 46 Transpose Formula
Home
region Jan Feb Mar
East 15800 42000 26700
West 19300 9800 7400
North 8700 10200 28300
East 31400 24800 21500
West 22600 7700 9900

region East West North East

Jan 15800 19300 8700 31400
Feb 42000 9800 10200 24800
Mar 26700 7400 28300 21500
West
22600
7700
9900
 47 Textsplit Formula
Home
Add.
110062 delhi
121102 palwal

Add. Pincode
110062,delhi,9999999999 #NAME?
121102,palwal,4444444444 #NAME?

Add. Name
Raj kumar/140003/punjab/3333333333 #NAME?
Sonu/121102/palwal/4456555555 #NAME?
 9999999999
4444444444

City Phone
#NAME? #NAME?
#NAME? #NAME?

Pincode City Phone

#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
 48 Now & Today
Home
Now Today
5/12/2025 4:50 5/12/2025

Patient Name Phone Entry Time

a xyz 14:52
Entry Date & Time
10/19/2024
 49 Date Formula
Home
Date
1/20/2024
1/20/2024

Day Month Year

2 1 2024
12 5 2023
22 9 2022
3 11 2021
4 11 2020
Date
1/2/2024
5/12/2023
9/22/2022
11/3/2021
11/4/2020
 50 Day, Month & Year Formula
Home
Date Day Month
2/1/2024 1 2
3/3/2024 3 3
4/3/2024 3 4
5/4/2024 4 5
6/4/2024 4 6
rmula
Year
2024
2024
2024
2024
2024
 51 Days Formula
Home
Task Start Date Task End Date Total Days
2/1/2024 2/12/2024 11
3/3/2024 3/20/2024 17
4/3/2024 6/5/2024 63
5/4/2024 6/23/2024 50
6/4/2024 6/20/2024 16
 52 Edate Formula
Home
Policy Issue Date
2/1/2024
3/3/2024
4/3/2024
5/4/2024
6/4/2024

This Formula is missed by mistake in video recording…!

Very Sorry for that my dear friends !
Formula
Same date for previous or next n months
11/1/2023
6/3/2024
7/3/2024
8/4/2024
9/4/2024

is missed by mistake in video recording…!

r that my dear friends !
 53 Eomonth Formula
Home
Policy Issue Date Month Last Date
2/1/2024 1/31/2024
3/3/2024 2/29/2024
4/3/2024 3/31/2024
5/4/2024 4/30/2024
6/4/2024 5/31/2024
 54 Datedif Formula
Home
D.O.B Today Date year
2/1/2000 5/12/2025 25
3/3/2020 5/12/2025 5
4/3/2002 5/12/2025 23
5/8/2007 5/12/2025 18
6/4/2004 5/12/2025 20
month day
303 9232
62 1896
277 8440
216 6579
251 7647
 55 Workday Formula
Home
Task Start Date Working Day Task End Date
1/2/2024 25 2/7/2024
3/3/2024 5 3/8/2024
4/3/2024 3 4/8/2024
5/4/2024 2 5/7/2024
6/4/2024 10 6/18/2024
Holidays list 2024
1/26/2024
8/15/2024
10/2/2025
 56 Workday.intl Formula
Home
Task Start Date workday Task End Date
2/1/2024 10 2/13/2024
3/3/2024 5 3/8/2024
4/3/2024 3 4/6/2024
5/4/2024 2 5/7/2024
6/4/2024 10 6/15/2024
Holidays list 2024
1/26/2024
8/15/2024
10/2/2025
 57 Networkdays Formula
Home
Task Start Date End Date Tast End Date
1/1/2024 1/28/2024 19
3/3/2024 4/15/2024 31
4/3/2024 4/12/2024 8
2/3/2024 2/15/2024 9
3/3/2024 3/17/2024 10
Holidays list 2024
1/26/2024
8/15/2024
10/2/2025
 58 Networkdays.intl Formula
Home
Task Start Date End Date Task End Date
1/1/2024 1/28/2024 23
3/3/2024 2/15/2024
4/3/2024 4/12/2024
3/3/2024 2/15/2024
3/3/2024 2/17/2024
Holidays list 2024
1/26/2024
8/15/2024
10/2/2025
 59 IF Formula
Home
Student Name Test Marks Result
Arjun Verma 34 Fail
Ritesh S. 54 Pass
Naveen Yadav 33 Fail
Tarun Joshi 55 Pass
Kunal Mehta 13 Fail

Student Name Test Marks Failed Stu.

Arjun Verma 56
Ritesh S. 12 Ritesh S.
Naveen Yadav 13 Naveen Yadav
Tarun Joshi 44
Home
Student Name Gender Add Mr / Mis in Names
Raj Kumar Male Mr. Raj Kumar
Tejal Female Mis Tejal
Anil Kumar Male Mr. Anil Kumar
Reena Female Mis Reena
Deepak Male Mr. Deepak
 Student Name Test MarksAdd. 5 Grace Marks if Stu Fail
Arjun Verma 34 39
Ritesh S. 54 54
Naveen Yadav 87 87
Tarun Joshi 55 55
Kunal Mehta 13 18

Student Name Test MarksResult ( Using Emoji )

Arjun Verma 34 ❌
Ritesh S. 54 ✔️
Naveen Yadav 87 ✔️
Tarun Joshi 55 ✔️

Mr / Mis in Names
Mr. Raj Kumar
Mis Tejal
Mr. Anil Kumar
Mis Reena
Mr. Deepak
 60 IF + And Formula
Home
Student Name Phy Che Mat
Yash Sharma 66 55 44
Aman Gupta 54 33 44
Vivek Chauhan 87 76 56
Nikhil Salvi 55 56 34
Harsh Tiwari 13 65 27

Agar phy,che and math me marks 40 ya 40 se jyada hain to result PA

Home

Salesman Name DepartmentRegion Sale

Raj Kumar IT East 10000
Mohit Markeeting West 15000
Anil Kumar IT East 22000
Sonu IT North 5000
Deepak HR South 11000
Sonu HR North 7000
Deepak IT North 25000
Sonu IT East 16000

IT Department se jis salesman ne 20000 se jyada sale ki hai usko 100

 Result
pass TRUE
fail
pass
fail
fail

da hain to result PASS dikhao nhi to fir FAIL dikhao…

Bonus

1000

1000

sale ki hai usko 1000 bonus dena hai…

 61 IF + OR Formula
Home
Student Name Progress
Karan Malhotra delivered
Abhishek Rawat cancelled
Saurabh Patel in Transit
Tushar Bansal delivered
Laxman Sinha cancelled

Agar Progress Delivered ya cancelled hai to status CLOSED dikhao nh

Home

Student Name Marks

Arjun Mehta 45%
Rohan Desai 76%
Manish Kapoor 56%
Tarun Yadav A
Kunal Saxena 77%
Tarun Yadav A
Varun Batra 98%
Tarun Yadav 33%

Jin Students ke marks 40% se kam hai ya wo absent the to FAIL dikha
 Status
closed TRUE
closed TRUE
open FALSE
closed TRUE
closed TRUE

ya cancelled hai to status CLOSED dikhao nhi to fir OPEN dikhao…

Result
pass
pass
pass
fail
pass
fail
pass
fail

% se kam hai ya wo absent the to FAIL dikhao nhi to PASS

 62 IFS Formula
Home
Student Name Phy Che Mat Total
Arvind Patel 66 55 66 187
Sagar Malhotra 54 67 44 165
Neeraj Sharma 87 76 56 219
Jatin Bansal 55 56 34 145
Rohit Sharma 13 65 27 105

Grade Scale :
Equal to or grater than 90% = A 3
Equal to or grater than 70% = B
Equal to or grater than 50% = C
Less than 50% = D
Home
Driver Name Speed Status
Amit Chauhan 120 fast
Suresh Yadav 85 fast
Vinod Mehra 66 normal
Rakesh Verma 95 fast
Lalit Sharma 35 slow

speed >=80 = fast

speed >=50 = normal
speed <50 slow
% Grade
56% c
76% b
33% d
98% a
67% c

three
 63 Vlookup Formula
Home
Emp ID Name Salary Department
100 Raj Kumar 45000 HR
101 Mohit 50000 IT
102 Anil Kumar 17000 Markeeting
103 Sonu 25000 HR
102 Deepak 40000 Finance
105 Amit jain 23000 Finance

Emp ID Name Salary Department

102 Anil Kumar 17000 Markeeting

ProductID Name HSN Code Qty Sold

100 Bedsheet P001 3
101 Pillow P004 5
102 Blanket P002 6
103 Alarm Clock P003 7
104 Mattress P005 4
105 Table Lamp P006 5
Joining Date Emp ID Joining Date
1/1/2023 1222 not found
6/4/2024
8/20/2022 Emp ID Salary
2/15/2018 104 #N/A
2/7/2022
2/8/2022

Joining Date Emp ID Salary Joining Date

8/20/2022 101 50000 6/4/2024

Price HSN Code Price

1200 P003 6500
5000
230 HSN Code Name
6500 P003
45000
3000
 64 Hlookup Formula
Home
ProductID 100 101 102
Name Sofa Dining Table Refrigerator
HSN Code P001 P004 P002
Qty Sold 3 5 6
Price 1200 5000 230

ProductID 104 ProductID

Price 45000 Name
HSN Code
ProductID 104 Qty Sold
HSN Code P005 Price
103 104 105
Washing Machine Microwave Oven Ceiling Fan
P003 P005 P006
7 4 5
6500 45000 3000

102 HSN Code

Refrigerator Price
P002
6
230
P004
5000
 65 Match Formula
Home
Emp ID Name Salary Department
100 Arjun Sinha 45000 HR
101 Nitin Verma 50000 IT
102 Saurabh Tyagi 17000 Markeeting
103 Tarun Bhatia 25000 HR
104 Kunal Joshi 40000 Finance
105 Vivek Mali 23000 Finance

name 2
Joining Date Emp ID Position / Index
1/1/2023 104 5
6/4/2024
8/20/2022
2/15/2018
2/7/2022
2/8/2022
 66 Index Formula
Home
Emp ID Name Salary Department
100 Arjun Sinha 45000 HR
101 Nitin Verma 50000 IT
102 Saurabh Tyagi 17000 Markeeting
103 Tarun Bhatia 25000 HR
104 Kunal Joshi 40000 Finance
105 Vivek Mali 23000 Finance
Joining Date Emp ID Position / Index
1/1/2023
6/4/2024
8/20/2022
2/15/2018
2/7/2022
2/8/2022
 67 Index + Match Formula
Home
ProductID Name HSN Code Qty Sold
100 CPU P001 3
101 RAM P004 5
102 SSD Drive P002 6
103 Graphics Card P003 7
104 Motherboard P005 4
105 Power Supply P006 5
ProductID
103
Emp ID Name Salary Department
103 Graphics Card P003 7
Price ProductID Price
1200 103 6500
5000
230 HSN Code ProductID
6500 P002 102
45000
3000

Joining Date
6500
 68 Xlookup Formula
Home
ProductID Name HSN Code Qty Sold
100 CPU P001 3
101 RAM Stick P004 5
102 SSD Drive P002 6
103 Graphics Card P003 7
102 Motherboard P005 4
105 Power Supply P006 5

ProductID Price
102 45000

ProductID Name HSN Code Qty Sold

100 Ring Light P001 3
101 Scanner P004 5
102 Mouse P002 6
103 Priner P003 7
104 Laptop P005 4
105 Desktop P006 5

ProductID Name HSN Code Qty Sold

104 Laptop P005 4

ProductID 100 101 102

Name Ring Light Scanner Mouse
HSN Code P001 P004 P002
Qty Sold 3 5 6
Price 1200 5000 230

ProductID 101 ProductID

HSN Code P004 Name
HSN Code
Qty Sold
Price
Price HSN CodeProductID
1200 P002 102
5000
230
6500
45000
3000

Price
1200
5000
230
6500
45000
3000

Price
#NAME?

103 104 105

Priner Laptop Desktop
P003 P005 P006
7 4 5
6500 45000 3000

103
Priner
P003
#NAME?
#NAME?
 69 DSUM
Home

Product Wattage Life Hours Brand Unit Cost

Bulb 200 3000 Horizon £4.50
Neon 100 2000 Horizon £2.00
Spot 60
Other 10 8000 Sunbeam £0.80
Bulb 80 1000 Horizon £0.20
Spot 100 unknown Horizon £1.25
Spot 200 3000 Horizon £2.50
Other 25 unknown Sunbeam £0.50
Bulb 200 3000 Sunbeam £5.00
Neon 100 2000 Sunbeam £1.80
Bulb 100 unknown Sunbeam £0.25
Bulb 10 800 Horizon £0.20
Bulb 60 1000 Sunbeam £0.15
Bulb 80 1000 Sunbeam £0.20
Bulb 100 2000 Horizon £0.80
Bulb 40 1000 Horizon £0.10
Box Quantity Boxes In Stock Value Of Stock Count the number of products of a partic
4 3 £54.00
15 2 £60.00
£0.00 Type the brand name :
25 6 £120.00
40 3 £24.00 The SUM value of Horizon is :
10 4 £50.00
15 1 £37.50
10 3 £15.00
3 2 £30.00
20 5 £180.00
10 5 £12.50
25 2 £10.00 LIST
25 1 £3.75 Horizon Bulb
30 2 £12.00 Sunbeam Neon
10 5 £40.00 Spot
20 5 £10.00 Other
mber of products of a particular Brand which have a Life Hours rating.

Brand These two cells are the Criteria range.

e brand name : Horizon

e of Horizon is :
 70 Filter Formula
Home
Product Id Product Name Region Amount
P001 T-Shirt East 18500
P002 Jeans West 6200
P003 Jacket North 32500
P004 T-Shirt East 29500
P005 Jeans West 9400
P006 Jacket North 7800
P007 T-Shirt East 27500
P008 Jeans West 6600
P009 Hoodie East 6100
P010 Kurta East 28000

Order Date Product Id Product Name Region

1/1/2024 P001 T-Shirt East
1/5/2024 P002 Jeans West
1/7/2024 P003 Jacket North
1/15/2024 P004 T-Shirt East
1/16/2024 P005 Jeans West
1/17/2024 P006 Jacket North
2/12/2024 P007 T-Shirt East
1/5/2024 P008 Jeans West
1/7/2024 P009 Hoodie East
1/15/2024 P010 Kurta East
Product NameRegion
jeans west

Product Id Product NameRegion Amount

#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?

Start Date 1/1/2024

End Date 1/10/2024

Order Date Product Id Product NameRegion

#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
 71 VLOOKUP FORMULA 1
Home

ID Last First
880-10035 Leff Julianne
880-10034 Piano Milagros
880-10033 Coller Kathrine
880-10032 Stackpole Lonnie
880-10031 Lintz Kurt
880-10030 Dudgeon Penelope
880-10029 Hughs Pearlie

ID Last First
880-10035
E-mail Phone
[email protected]
PianoM@PBY 253-553-4381
CollerK@PB 206-762-2195
StackpoleL 253-764-6538
LintzK@PBY206-736-4510
DudgeonP@253-452-9723
HughsP@PB253-719-7600

E-mail Phone
 72 Color Sorting
Home

NAME Sales Country Quarter

Smith $16,753.00 UK Qtr 3
Johnson $14,808.00 USA Qtr 4
Williams $10,644.00 UK Qtr 2
Jones $1,390.00 USA Qtr 3
Brown $4,865.00 USA Qtr 4
Williams $12,438.00 UK Qtr 1
Johnson $9,339.00 UK Qtr 2
Smith $18,919.00 USA Qtr 3
Jones $9,213.00 USA Qtr 4
Jones $7,433.00 UK Qtr 1
Brown $3,255.00 USA Qtr 2
Williams $14,867.00 USA Qtr 3
Williams $19,302.00 UK Qtr 4
Smith $9,698.00 USA Qtr 1
 73 Customized Sorting
Home

Customized Sorting
Last Name Sales Country Quarter
Smith $16,753.00 UK Qtr 3
Johnson $14,808.00 USA Qtr 4
Williams $10,644.00 UK Qtr 2
Jones $1,390.00 USA Qtr 3
Brown $4,865.00 USA Qtr 4
Williams $12,438.00 UK Qtr 1
Johnson $9,339.00 UK Qtr 2
Smith $18,919.00 USA Qtr 3
Jones $9,213.00 USA Qtr 4
Jones $7,433.00 UK Qtr 1
Brown $3,255.00 USA Qtr 2
Williams $14,867.00 USA Qtr 3
Williams $19,302.00 UK Qtr 4
Smith $9,698.00 USA Qtr 1
Priority
Low
High
Low
Normal
High
Normal
High
High
Low
Normal
Normal
Low
High
Normal
 74 Important Statistical& Mathematical Fu
Home

Date SalesRep Sales

10/23/2017 Chin 100
10/23/2017 Gigi 200
10/24/2017 Dawn 100
10/24/2017 Chin 300
10/24/2017 Chin 700
10/23/2017 Dawn 100
10/24/2017 Gigi 200
10/24/2017 Gigi 500
10/23/2017 Gigi 200
matical Function

COUNT Function
COUNTA Function
COUNTBLANK Function
SUMIFS Function
COUNTIFS Function
SUMIF Function
IF Function
 75 PIVOT
Home

Home

Last Name First Name Department

Abrams Andrea Marketing
Dugan Aparna IT
Minzner Brian Sales
Marone Brooke Sales
McIntyre Carl Graphics
McIntyre Carl Graphics
Buckleitner Carly HR
More Carol Executive
Birman Carol Finance
Fitts Christine IT
Jorgensen Daniel Sales
Jorgensen Daniel Sales
Coules Duke Sales
Stryker Fred Sales
Sipes James Graphics
Picker James IT
Meacham Jeremy Executive
Petsch Joseph Graphics
Rampulla Judith IT
Rampulla Judith IT
Rampulla Judith IT
Novick Kenneth Graphics
Leung Kerry Marketing
Marciano Kim Marketing
Deshpande Krishna Executive
Philips Laura HR
Lowenfeld Leanne Marketing
Lowenfeld Leanne Marketing
Colvin Lois Finance
Fitzpatrick Louan Sales
Rehal Marc HR
Kreanow Marianne HR
Boyle Meg Finance
Boyle Meg Finance
McGowan Paul Marketing
Wilson Paul Sales
Wilson Paul Sales
Liebowitz Rebecca Executive
Cohen Rosanne Finance
Zarish Shelli Sales
Richardson Warren Sales
DeTorres Wendy Finance
 State Hours Rate Wage Location
NY 80.10 44.62 3,574.06 Mobile
PA 82.40 24.54 2,022.10 Mobile
NY 39.90 41.66 1,662.23 Office
VT 32.40 14.37 465.59 Mobile
NJ 84.60 29.76 2,517.70 Mobile
NJ 84.60 29.76 2,517.70 Mobile
PA 16.20 33.04 535.25 Mobile
NJ 40.00 17.88 715.20 Office
NY 33.20 24.05 798.46 Mobile
VT 87.60 23.00 2,014.80 Office
NJ 95.00 48.63 4,619.85 Mobile
NJ 95.00 48.63 4,619.85 Mobile
CA 78.40 44.98 3,526.43 Office
CT 10.20 23.74 242.15 Mobile
NJ 13.20 12.06 159.19 Mobile
NY 70.60 20.84 1,471.30 Mobile
PA 26.60 15.99 425.33 Office
CT 80.40 16.53 1,329.01 Office
CA 46.40 40.80 1,893.12 Office
CA 46.40 39.80 1,846.72 Office
CA 46.40 38.80 1,800.32 Office
NJ 78.50 28.73 2,255.31 Mobile
CA 59.10 34.83 2,058.45 Office
CT 22.50 11.51 258.98 Mobile
VT 15.10 45.09 680.86 Mobile
IL 52.36 64.37 3,370.41 Mobile
VT 97.20 30.30 2,945.16 Mobile
VT 97.20 30.30 2,945.16 Mobile
NJ 59.60 39.97 2,382.21 Mobile
IL 64.29 75.12 4,829.46 Mobile
NJ 87.30 19.68 1,718.06 Office
CA 11.90 32.14 382.47 Mobile
PA 96.30 35.92 3,459.10 Office
PA 96.30 35.92 3,459.10 Office
NY 13.60 20.14 273.90 Mobile
CT 68.60 23.74 1,628.56 Office
CT 68.60 23.74 1,628.56 Office
CA 29.30 13.09 383.54 Mobile
NY 26.42 83.65 2,210.03 Mobile
NJ 23.20 45.11 1,046.55 Office
CA 62.90 47.90 3,012.91 Mobile
CA 85.30 24.14 2,059.14 Mobile
 Trained? Seat Pref.
No Aisle
No Aisle
Yes Aisle
Yes Window
Yes Window
Yes Window
No Window
Yes Aisle
No Aisle
No Aisle
No Window
No Window
No Window
Yes Aisle
Yes Window
Yes Aisle
Yes Window
No Aisle
Yes Window
Yes Window
Yes Window
Yes Aisle
No Window
Yes Window
No Window
Yes Aisle
No Window
No Window
Yes Aisle
No Aisle
No Window
Yes Window
No Aisle
No Aisle
Yes Window
No Aisle
No Aisle
No Window
Yes Window
Yes Aisle
Yes Window
Yes Aisle
Empcode First Name Last Name Dept Region Branch Hiredate
1 Raja Raymondekar Sales north Ferozepur 1-Jan-77
3 Kuldeep Sharma Admin south Hydrabad 1-Mar-99
4 Beena Mavadia Mktg north Delhi 24-Nov-79
5 Seema Ranganathan R&D north Kanpur 4-Sep-89
6 Julie D'Souza R&D north Mathura 4-Sep-88
7 Deepak Jain Personnel west Pune 17-Aug-90
8 Neena Mukherjee R&D north Agra 4-Sep-89
9 Pankaj Sutradhar Sales north Ambala 12-Dec-99
10 Andre Fernendes Mktg East Darjeeling 20-Jul-77
11 Sujay Madhrani Finance west Pune 21-Dec-85
12 Shilpa Lele Admin north Jammu 1-Mar-83
13 Meera Lalwani Finance East Calcutta 11-Dec-84
14 Sheetal Desai Director south cochin 12-Dec-84
15 K. Sita Narayanan Personnel north Jammu 13-Dec-84
16 Priya Shirodkar Personnel north Jaipur 14-Dec-84
17 aalok Trivedi Admin East Cuttack 1-Mar-83
18 Aakash Dixit Admin west Nasik 1-Mar-83
19 Parvati Khanna Mktg north Mathura 13-Aug-86
20 Farhan Sadiq Mktg north Jaipur 5-Jun-99
21 Satinder Kaur Sasan Mktg East Patna 6-Jun-99
22 Suchita Panchal Mktg west Nasik 7-Jun-99
23 Shazia Sheikh Mktg west Pune 8-Jun-99
24 Pooja Nimkar Sales west Nasik 21-May-80
25 Jasbinder Khurana R&D south Manglore 24-Apr-99
26 Bharat Shetty Sales East Cuttack 1-Oct-82
27 Rishi Malik Sales south Banglore 2-Jul-92
28 Mala Bhaduri R&D west Mumbai 19-Mar-95
29 Hajra Hoonjan Admin north Jaipur 4-May-96
30 Aalam Qureshi Personnel East Patna 19-Oct-88
31 Giriraj Gupta R&D north Agra 1-Oct-82
32 Ankur Joshi CCD south Manglore 1-Oct-82
33 Tapan Ghoshal CCD north Ambala 7-Jul-97
34 Zarina Vora CCD north Lucknow 29-Sep-91
35 Arun Joshi Mktg south Manglore 5-May-92
36 Pooja Khetan Personnel west Surat 3-Sep-94
37 Shilpa Parikh Finance south Mysore 1-Oct-82
38 Chitra Pednekar Finance north Aligarh 1-Oct-82
39 Sheetal Dodhia Finance north delhi 1-Oct-82
40 Richa Raje Sales south Manglore 29-Sep-91
41 Kirtikar Sardesai Admin East Darjeeling 14-Jun-97
42 Pooja Gokhale R&D East Calcutta 29-Sep-91
43 Piyush Surti Personnel west Mumbai 19-Oct-88
44 Shaheen Khan Personnel East Cuttack 17-Nov-90
45 Kinnari Mehta R&D north Ferozepur 7-Jul-97
46 Jeena Baig Sales north Lucknow 29-Sep-91
47 Vicky Joshi Admin north Kanpur 7-Feb-88
48 Neha Joshi CCD west Baroda 19-Oct-88
49 Rakesh Kumar CCD south cochin 19-Oct-88
50 Ruheal Baig Personnel west Baroda 19-Oct-88
51 Mario Fernandes Sales north Jammu 20-Oct-88
52 Heena Godbole CCD north Lucknow 21-Oct-88
53 Mehul Sheth CCD west Nagpur 1-Dec-95
54 Vishal Virsinghani CCD East Gangtok 3-Mar-95
55 Lalita Rao CCD East Guwahati 1-Nov-86
56 Kajal Joglekar Sales west Nagpur 1-Oct-92
57 Katti Surti Sales south chennai 9-May-93
58 Maya Panchal Mktg north Agra 5-Nov-90
59 Disha Parmar Admin south Banglore 14-Jan-87
60 Geeta Darekar Mktg south Trivanadrum 24-Nov-87
61 Anuradha Zha Admin north Agra 25-Nov-87
62 Asha Trivedi Sales north Kanpur 26-Nov-87
63 Waheda Sheikh R&D north Jammu 24-Oct-88
64 Veena Patil Personnel south Hydrabad 25-Oct-88
65 Timsi Desai CCD East Calcutta 26-Oct-88
66 Parul Shah Personnel north Agra 27-Oct-88
67 Uday Naik Personnel north Lucknow 28-Oct-88
68 Mandakini Desai Sales north delhi 1-Dec-95
69 Pravin Joshi Personnel north delhi 3-Mar-95
70 Reeta Naik Mktg East Calcutta 4-Mar-95
71 Surendra Godse R&D west Panji 5-Mar-95
72 Yamini Gupta R&D south Mysore 22-Oct-88
 73 Laveena Shenoy CCD north Jaipur 23-Oct-88
74 Nita Pandhya Sales East Darjeeling 24-Oct-88
75 Suraj Saksena Admin East Calcutta 25-Oct-88
76 Nayeem Khan CCD west Panji 26-Oct-88
77 Drishti Shah R&D north Delhi 27-Oct-88
78 Deep Chhaya Sales west Mumbai 28-Oct-88
79 Sagar Bidkar Mktg north Delhi 29-Oct-88
80 Dayanand Gandhi Mktg north Ferozepur 30-Oct-88
81 Tara Phule CCD south chennai 31-Oct-88
82 Kalpana Shirishkar R&D East Cuttack 1-Nov-88
83 Kunal Shah CCD north Aligarh 2-Mar-99
84 Pinky Robert R&D East Calcutta 3-Mar-99
85 Ruby Joseph R&D north Agra 14-Jan-98
86 Sonia Sasan CCD north Jammu 15-Jan-98
87 Jignesh Tripathi Mktg south Hydrabad 16-Jan-98
88 Vinit Shrivastava Mktg west Pune 30-Dec-97
89 Tejal Patel Sales north Aligarh 21-Feb-79
90 Priyanka Mehta R&D north Jaipur 6-Jan-80
91 Niki Digaria Sales East Calcutta 13-Nov-79
92 Payal Singhani Mktg East Gangtok 5-Apr-89
93 Harsha Trivedi Sales south Banglore 6-Apr-89
94 Radhika Kulkarni Mktg west Surat 7-Apr-89
95 Kabir Vora Mktg south Banglore 8-Apr-89
96 Beena Sharma R&D west Nagpur 9-Apr-89
97 Pushpa Raut R&D south Trivanadrum 10-Apr-89
98 Chetan Dalvi CCD north Delhi 11-Apr-89
99 Indu Shah Finance west Mumbai 30-Dec-97
100 Rupesh Sawant Finance south Hydrabad 2-Feb-99
101 ravi sharma mkt East Cuttack 1-Jan-77
Salary Home Page
21875
7000
12250
21000
12425
12425
12425
14875
15750
14875
21000
19250
49000
14875
14875
15750
15750
10500
5950
7875
7875
7875
14875
7875
19250
13125
10500
9625
14175
15750
15750
7000
8750
9275
11725
24500
24500
24500
10500
7875
13300
15750
13825
11375
15750
15750
15750
15750
15750
15750
19250
15750
15750
15750
14875
14875
17500
19250
19250
19250
19251
17500
17500
17500
17500
20125
14000
14000
14000
14000
17500
17500
17500
17500
17500
17500
17500
17500
17500
17500
17500
7000
7000
7000
17500
17500
7875
22750
22750
22750
17325
17325
17325
17325
17325
17325
17325
10500
7875
17500
EMP INFO
Home Page
Employee Information System

Employee Code

Name

Region

Department

Salary
 Raj Singh Emp. D
Home Page
Emp. Dashboard
 5

Empcode First Name Last Name Dept Region Branch

2 Suman Shinde Sales east Cuttack
10 Andre Fernendes Mktg east Darjeeling
13 Meera Lalwani Finance east Calcutta
17 aalok Trivedi Admin east Cuttack
21 Satinder Kaur Sasan Mktg east Patna
26 Bharat Shetty Sales east Cuttack
30 Aalam Qureshi Personnel east Patna
41 Kirtikar Sardesai Admin east Darjeeling
42 Pooja Gokhale R&D east Calcutta
44 Shaheen Khan Personnel east Cuttack
54 Vishal Virsinghani CCD east Gangtok
55 Lalita Rao CCD east Guwahati
65 Timsi Desai CCD east Calcutta
70 Reeta Naik Mktg east Calcutta
74 Nita Pandhya Sales east Darjeeling
75 Suraj Saksena Admin east Calcutta
82 Kalpana Shirishkar R&D east Cuttack
84 Pinky Robert R&D east Calcutta
91 Niki Digaria Sales east Calcutta
92 Payal Singhani Mktg east Gangtok
1 Raja Raymondekar Sales north Ferozepur
4 Beena Mavadia Mktg north Delhi
5 Seema Ranganathan R&D north Kanpur
6 Julie D'Souza R&D north Mathura
8 Neena Mukherjee R&D north Agra
9 Pankaj Sutradhar Sales north Ambala
12 Shilpa Lele Admin north Jammu
15 K. Sita Narayanan Personnel north Jammu
16 Priya Shirodkar Personnel north Jaipur
19 Parvati Khanna Mktg north Mathura
20 Farhan Sadiq Mktg north Jaipur
29 Hajra Hoonjan Admin north Jaipur
31 Giriraj Gupta R&D north Agra
33 Tapan Ghoshal CCD north Ambala
34 Zarina Vora CCD north Lucknow
38 Chitra Pednekar Finance north Aligarh
39 Sheetal Dodhia Finance north Delhi
45 Kinnari Mehta R&D north Ferozepur
46 Jeena Baig Sales north Lucknow
47 Vicky Joshi Admin north Kanpur
51 Mario Fernandes Sales north Jammu
52 Heena Godbole CCD north Lucknow
58 Maya Panchal Mktg north Agra
61 Anuradha Zha Admin north Agra
62 Asha Trivedi Sales north Kanpur
63 Waheda Sheikh R&D north Jammu
66 Parul Shah Personnel north Agra
67 Uday Naik Personnel north Lucknow
68 Mandakini Desai Sales north Delhi
69 Pravin Joshi Personnel north Delhi
73 Laveena Shenoy CCD north Jaipur
77 Drishti Shah R&D north Delhi
79 Sagar Bidkar Mktg north Delhi
80 Dayanand Gandhi Mktg north Ferozepur
83 Kunal Shah CCD north Aligarh
85 Ruby Joseph R&D north Agra
86 Sonia Sasan CCD north Jammu
89 Tejal Patel Sales north Aligarh
90 Priyanka Mehta R&D north Jaipur
98 Chetan Dalvi CCD north Delhi
3 Kuldeep Sharma Admin south Hydrabad
14 Sheetal Desai Director south cochin
25 Jasbinder Khurana R&D south Manglore
27 Rishi Malik Sales south Banglore
32 Ankur Joshi CCD south Manglore
35 Arun Joshi Mktg south Manglore
37 Shilpa Parikh Finance south Mysore
40 Richa Raje Sales south Manglore
49 Rakesh Kumar CCD south cochin
 57 Katti Surti Sales south chennai
59 Disha Parmar Admin south Banglore
60 Geeta Darekar Mktg south Trivanadrum
64 Veena Patil Personnel south Hydrabad
72 Yamini Gupta R&D south Mysore
81 Tara Phule CCD south chennai
87 Jignesh Tripathi Mktg south Hydrabad
93 Harsha Trivedi Sales south Banglore
95 Kabir Vora Mktg south Banglore
97 Pushpa Raut R&D south Trivanadrum
100 Rupesh Sawant Finance south Hydrabad
7 Deepak Jain Personnel west Pune
11 Sujay Madhrani Finance west Pune
18 Aakash Dixit Admin west Nasik
22 Suchita Panchal Mktg west Nasik
23 Shazia Sheikh Mktg west Pune
24 Pooja Nimkar Sales west Nasik
28 Mala Bhaduri R&D west Mumbai
36 Pooja Khetan Personnel west Surat
43 Piyush Surti Personnel west Mumbai
48 Neha Joshi CCD west Baroda
50 Ruheal Baig Personnel west Baroda
53 Mehul Sheth CCD west Nagpur
56 Kajal Joglekar Sales west Nagpur
71 Surendra Godse R&D west Panji
76 Nayeem Khan CCD west Panji
78 Deep Chhaya Sales west Mumbai
88 Vinit Shrivastava Mktg west Pune
94 Radhika Kulkarni Mktg west Surat
96 Beena Sharma R&D west Nagpur
99 Indu Shah Finance west Mumbai
Hiredate Salary name eco
1-Jan-77 17500 ram 99
20-Jul-77 15750 raj 66
11-Dec-84 19250 kk 41
1-Mar-83 15750 pk 23
6-Jun-99 7875
1-Oct-82 19250
19-Oct-88 14175
14-Jun-97 7875
29-Sep-91 13300
17-Nov-90 13825
3-Mar-95 15750
1-Nov-86 15750
26-Oct-88 17500
4-Mar-95 14000
24-Oct-88 17500
25-Oct-88 17500
1-Nov-88 17500
3-Mar-99 7000
13-Nov-79 22750
5-Apr-89 17325
1-Jan-77 21875
24-Nov-79 12250
4-Sep-89 21000
4-Sep-88 12425
4-Sep-89 12425
12-Dec-99 14875
1-Mar-83 21000
13-Dec-84 14875
14-Dec-84 14875
13-Aug-86 10500
5-Jun-99 5950
4-May-96 9625
1-Oct-82 15750
 7-Jul-97 7000
29-Sep-91 8750
1-Oct-82 24500
1-Oct-82 24500
7-Jul-97 11375
29-Sep-91 15750
7-Feb-88 15750
20-Oct-88 15750
21-Oct-88 19250
5-Nov-90 17500
25-Nov-87 19250
26-Nov-87 19251
24-Oct-88 17500
27-Oct-88 17500
28-Oct-88 20125
1-Dec-95 14000
3-Mar-95 14000
23-Oct-88 17500
27-Oct-88 17500
29-Oct-88 17500
30-Oct-88 17500
2-Mar-99 7000
14-Jan-98 7000
15-Jan-98 17500
21-Feb-79 22750
6-Jan-80 22750
11-Apr-89 17325
1-Mar-99 7000
12-Dec-84 49000
24-Apr-99 7875
2-Jul-92 13125
1-Oct-82 15750
5-May-92 9275
1-Oct-82 24500
29-Sep-91 10500
19-Oct-88 15750
 9-May-93 14875
14-Jan-87 19250
24-Nov-87 19250
25-Oct-88 17500
22-Oct-88 17500
31-Oct-88 17500
16-Jan-98 17500
6-Apr-89 17325
8-Apr-89 17325
10-Apr-89 17325
2-Feb-99 7875
17-Aug-90 12425
21-Dec-85 14875
1-Mar-83 15750
7-Jun-99 7875
8-Jun-99 7875
21-May-80 14875
19-Mar-95 10500
3-Sep-94 11725
19-Oct-88 15750
19-Oct-88 15750
19-Oct-88 15750
1-Dec-95 15750
1-Oct-92 14875
5-Mar-95 14000
26-Oct-88 17500
28-Oct-88 17500
30-Dec-97 7875
7-Apr-89 17325
9-Apr-89 17325
30-Dec-97 10500
eng bk it name eco
75 69 75 ram 99
96 52 88 raj 66
75 41 52 kk 41
52 11 42 pk 23
eng bk it
75 69 75
96 52 88
75 41 52
52 11 42
Abcd Dashboard
ard
Home Page
xyz Dashboard
Home Page
 0
Home
 0
Home
 0
Home
 0
Home