A B C D E F G

1 Empcode First Name Last Name Dept Region Branch Hiredate

2 1 Raja Raymondekar Sales North Ferozepur 28-Dec-92
3 2 Suman Shinde Sales East Cuttack 28-Dec-92
4 3 Kuldeep Sharma Admin South Hydrabad 25-Feb-15
5 4 Beena Mavadia Mktg North Delhi 20-Nov-95
6 5 Seema Ranganathan R&D North Kanpur 31-Aug-05
7 6 Julie D'Souza R&D North Mathura 31-Aug-04
8 7 Deepak Jain Personnel West Pune 13-Aug-06
9 8 Neena Mukherjee R&D North Agra 31-Aug-05
10 9 Pankaj Sutradhar Sales North Ambala 8-Dec-15
11 10 Andre Fernendes Mktg East Darjeeling 16-Jul-93
12 11 Sujay Madhrani Finance West Pune 17-Dec-01
13 12 Shilpa Lele Admin North Jammu 25-Feb-99
14 13 Meera Lalwani Finance East Calcutta 7-Dec-00
15 14 Sheetal Desai Director South Cochin 8-Dec-00
16 15 K. Sita Narayanan Personnel North Jammu 9-Dec-00
17 16 Priya Shirodkar Personnel North Jaipur 10-Dec-00
18 17 Aalok Trivedi Admin East Cuttack 25-Feb-99
19 18 Aakash Dixit Admin West Nasik 25-Feb-99
20 19 Parvati Khanna Mktg North Mathura 9-Aug-02
21 20 Farhan Sadiq Mktg North Jaipur 1-Jun-15
22 21 Satinder Kaur Sasan Mktg East Patna 2-Jun-15
23 22 Suchita Panchal Mktg West Nasik 3-Jun-15
24 23 Shazia Sheikh Mktg West Pune 4-Jun-15
25 24 Pooja Nimkar Sales West Nasik 17-May-96
26 25 Jasbinder Khurana R&D South Manglore 20-Apr-15
27 26 Bharat Shetty Sales East Cuttack 27-Sep-98
28 27 Rishi Malik Sales South Banglore 28-Jun-08
29 28 Mala Bhaduri R&D West Mumbai 15-Mar-11
30 29 Hajra Hoonjan Admin North Jaipur 30-Apr-12

Data Pragati Software Pvt. Ltd. Confidential Page 1

 A B C D E F G
31 30 Aalam Qureshi Personnel East Patna 15-Oct-04
32 31 Giriraj Gupta R&D North Agra 27-Sep-98
33 32 Ankur Joshi CCD South Manglore 27-Sep-98
34 33 Tapan Ghoshal CCD North Ambala 3-Jul-13
35 34 Zarina Vora CCD North Lucknow 25-Sep-07
36 35 Arun Joshi Mktg South Manglore 1-May-08
37 36 Pooja Khetan Personnel West Surat 30-Aug-10
38 37 Shilpa Parikh Finance South Mysore 27-Sep-98
39 38 Chitra Pednekar Finance North Aligarh 27-Sep-98
40 39 Sheetal Dodhia Finance North Delhi 27-Sep-98
41 40 Richa Raje Sales South Manglore 25-Sep-07
42 41 Kirtikar Sardesai Admin East Darjeeling 10-Jun-13
43 42 Pooja Gokhale R&D East Calcutta 25-Sep-07
44 43 Piyush Surti Personnel West Mumbai 15-Oct-04
45 44 Shaheen Khan Personnel East Cuttack 13-Nov-06
46 45 Kinnari Mehta R&D North Ferozepur 3-Jul-13
47 46 Jeena Baig Sales North Lucknow 25-Sep-07
48 47 Vicky Joshi Admin North Kanpur 3-Feb-04
49 48 Neha Joshi CCD West Baroda 15-Oct-04
50 49 Rakesh Kumar CCD South Cochin 15-Oct-04
51 50 Ruheal Baig Personnel West Baroda 15-Oct-04
52 51 Mario Fernandes Sales North Jammu 16-Oct-04
53 52 Heena Godbole CCD North Lucknow 17-Oct-04
54 53 Mehul Sheth CCD West Nagpur 27-Nov-11
55 54 Vishal Virsinghani CCD East Gangtok 27-Feb-11
56 55 Lalita Rao CCD East Guwahati 28-Oct-02
57 56 Kajal Joglekar Sales West Nagpur 27-Sep-08
58 57 Katti Surti Sales South Chennai 5-May-09
59 58 Maya Panchal Mktg North Agra 1-Nov-06
60 59 Disha Parmar Admin South Banglore 10-Jan-03

Data Pragati Software Pvt. Ltd. Confidential Page 2

 A B C D E F G
61 60 Geeta Darekar Mktg South Trivanadrum 20-Nov-03
62 61 Anuradha Zha Admin North Agra 21-Nov-03
63 62 Asha Trivedi Sales North Kanpur 22-Nov-03
64 63 Waheda Sheikh R&D North Jammu 20-Oct-04
65 64 Veena Patil Personnel South Hydrabad 21-Oct-04
66 65 Timsi Desai CCD East Calcutta 22-Oct-04
67 66 Parul Shah Personnel North Agra 23-Oct-04
68 67 Uday Naik Personnel North Lucknow 24-Oct-04
69 68 Mandakini Desai Sales North Delhi 27-Nov-11
70 69 Pravin Joshi Personnel North Delhi 27-Feb-11
71 70 Reeta Naik Mktg East Calcutta 28-Feb-11
72 71 Surendra Godse R&D West Panji 1-Mar-11
73 72 Yamini Gupta R&D South Mysore 18-Oct-04
74 73 Laveena Shenoy CCD North Jaipur 19-Oct-04
75 74 Nita Pandhya Sales East Darjeeling 20-Oct-04
76 75 Suraj Saksena Admin East Calcutta 21-Oct-04
77 76 Nayeem Khan CCD West Panji 22-Oct-04
78 77 Drishti Shah R&D North Delhi 23-Oct-04
79 78 Deep Chhaya Sales West Mumbai 24-Oct-04
80 79 Sagar Bidkar Mktg North Delhi 25-Oct-04
81 80 Dayanand Gandhi Mktg North Ferozepur 26-Oct-04
82 81 Tara Phule CCD South Chennai 27-Oct-04
83 82 Kalpana Shirishkar R&D East Cuttack 28-Oct-04
84 83 Kunal Shah CCD North Aligarh 26-Feb-15
85 84 Pinky Robert R&D East Calcutta 27-Feb-15
86 85 Ruby Joseph R&D North Agra 10-Jan-14
87 86 Sonia Sasan CCD North Jammu 11-Jan-14
88 87 Jignesh Tripathi Mktg South Hydrabad 12-Jan-14
89 88 Vinit Shrivastava Mktg West Pune 26-Dec-13
90 89 Tejal Patel Sales North Aligarh 17-Feb-95

Data Pragati Software Pvt. Ltd. Confidential Page 3

 A B C D E F G
91 90 Priyanka Mehta R&D North Jaipur 2-Jan-96
92 91 Niki Digaria Sales East Calcutta 9-Nov-95
93 92 Payal Singhani Mktg East Gangtok 1-Apr-05
94 93 Harsha Trivedi Sales South Banglore 2-Apr-05
95 94 Radhika Kulkarni Mktg West Surat 3-Apr-05
96 95 Kabir Vora Mktg South Banglore 4-Apr-05
97 96 Beena Sharma R&D West Nagpur 5-Apr-05
98 97 Pushpa Raut R&D South Trivanadrum 6-Apr-05
99 98 Chetan Dalvi CCD North Delhi 7-Apr-05
100 99 Indu Shah Finance West Mumbai 26-Dec-13
101 100 Rupesh Sawant Finance South Hydrabad 29-Jan-15

Data Pragati Software Pvt. Ltd. Confidential Page 4

 H
1 Salary
2 21,875
3 17,500
4 7,000
5 12,250
6 21,000
7 12,425
8 13,825
9 12,425
10 14,875
11 15,750
12 14,875
13 21,000
14 19,250
15 49,000
16 14,875
17 14,875
18 15,750
19 15,750
20 10,500
21 5,950
22 7,875
23 7,875
24 7,875
25 14,875
26 7,875
27 19,250
28 13,125
29 10,500
30 9,625

Data Pragati Software Pvt. Ltd. Confidential Page 5

 H
31 14,175
32 15,750
33 15,750
34 7,000
35 8,750
36 9,275
37 11,725
38 24,500
39 24,500
40 24,500
41 10,500
42 7,875
43 13,300
44 15,750
45 13,825
46 11,375
47 15,750
48 15,750
49 15,750
50 15,750
51 15,750
52 15,750
53 19,250
54 15,750
55 15,750
56 15,750
57 14,875
58 14,875
59 17,500
60 19,250

Data Pragati Software Pvt. Ltd. Confidential Page 6

 H
61 19,250
62 19,250
63 19,250
64 17,500
65 17,500
66 17,500
67 17,500
68 20,125
69 14,000
70 14,000
71 14,000
72 14,000
73 17,500
74 17,500
75 17,500
76 17,500
77 17,500
78 17,500
79 17,500
80 17,500
81 17,500
82 17,500
83 17,500
84 7,000
85 7,000
86 7,000
87 17,500
88 17,500
89 7,875
90 22,750

Data Pragati Software Pvt. Ltd. Confidential Page 7

 H
91 22,750
92 22,750
93 17,325
94 17,325
95 17,325
96 17,325
97 17,325
98 17,325
99 17,325
100 10,500
101 7,875

Data Pragati Software Pvt. Ltd. Confidential Page 8

Using VLOOKUP
Employee Code Input
First Name Output
Last Name Output
Dept Output
Hiredate Output
Salary Output

Using LOOKUP
Employee Code Input
First Name Output
Last Name Output
Dept Output
Hiredate Output
Salary Output
Using INDEX - MATCH
Employee Code Input
First Name Output
Last Name Output
Dept Output
Hiredate Output
Salary Output
 A B C D E F G H
1 Empcode First Name Last Name Dept Region Branch Hiredate Salary
2 1 Raja Raymondekar Sales North Ferozepur 28-Dec-92 21,875
3 2 Suman Shinde Sales East Cuttack 28-Dec-92 17,500
4 3 Kuldeep Sharma Admin South Hydrabad 25-Feb-15 7,000
5 4 Beena Mavadia Mktg North Delhi 20-Nov-95 12,250
6 5 Seema Ranganathan R&D North Kanpur 31-Aug-05 21,000
7 6 Julie D'Souza R&D North Mathura 31-Aug-04 12,425
8 7 Deepak Jain Personnel West Pune 13-Aug-06 13,825
9 8 Neena Mukherjee R&D North Agra 31-Aug-05 12,425
10 9 Pankaj Sutradhar Sales North Ambala 8-Dec-15 14,875
11 10 Andre Fernendes Mktg East Darjeeling 16-Jul-93 15,750
12 11 Sujay Madhrani Finance West Pune 17-Dec-01 14,875
13 12 Shilpa Lele Admin North Jammu 25-Feb-99 21,000
14 13 Meera Lalwani Finance East Calcutta 7-Dec-00 19,250
15 14 Sheetal Desai Director South Cochin 8-Dec-00 49,000
16 15 K. Sita Narayanan Personnel North Jammu 9-Dec-00 14,875
17 16 Priya Shirodkar Personnel North Jaipur 10-Dec-00 14,875
18 17 Aalok Trivedi Admin East Cuttack 25-Feb-99 15,750
19 18 Aakash Dixit Admin West Nasik 25-Feb-99 15,750
20 19 Parvati Khanna Mktg North Mathura 9-Aug-02 10,500
21 20 Farhan Sadiq Mktg North Jaipur 1-Jun-15 5,950
22 21 Satinder Kaur Sasan Mktg East Patna 2-Jun-15 7,875
23 22 Suchita Panchal Mktg West Nasik 3-Jun-15 7,875
24 23 Shazia Sheikh Mktg West Pune 4-Jun-15 7,875
25 24 Pooja Nimkar Sales West Nasik 17-May-96 14,875
26 25 Jasbinder Khurana R&D South Manglore 20-Apr-15 7,875
27 26 Bharat Shetty Sales East Cuttack 27-Sep-98 19,250
28 27 Rishi Malik Sales South Banglore 28-Jun-08 13,125
29 28 Mala Bhaduri R&D West Mumbai 15-Mar-11 10,500
30 29 Hajra Hoonjan Admin North Jaipur 30-Apr-12 9,625

Logicals Pragati Software Pvt. Ltd. Confidential Page 11

 A B C D E F G H
31 30 Aalam Qureshi Personnel East Patna 15-Oct-04 14,175
32 31 Giriraj Gupta R&D North Agra 27-Sep-98 15,750
33 32 Ankur Joshi CCD South Manglore 27-Sep-98 15,750
34 33 Tapan Ghoshal CCD North Ambala 3-Jul-13 7,000
35 34 Zarina Vora CCD North Lucknow 25-Sep-07 8,750
36 35 Arun Joshi Mktg South Manglore 1-May-08 9,275
37 36 Pooja Khetan Personnel West Surat 30-Aug-10 11,725
38 37 Shilpa Parikh Finance South Mysore 27-Sep-98 24,500
39 38 Chitra Pednekar Finance North Aligarh 27-Sep-98 24,500
40 39 Sheetal Dodhia Finance North Delhi 27-Sep-98 24,500
41 40 Richa Raje Sales South Manglore 25-Sep-07 10,500
42 41 Kirtikar Sardesai Admin East Darjeeling 10-Jun-13 7,875
43 42 Pooja Gokhale R&D East Calcutta 25-Sep-07 13,300
44 43 Piyush Surti Personnel West Mumbai 15-Oct-04 15,750
45 44 Shaheen Khan Personnel East Cuttack 13-Nov-06 13,825
46 45 Kinnari Mehta R&D North Ferozepur 3-Jul-13 11,375
47 46 Jeena Baig Sales North Lucknow 25-Sep-07 15,750
48 47 Vicky Joshi Admin North Kanpur 3-Feb-04 15,750
49 48 Neha Joshi CCD West Baroda 15-Oct-04 15,750
50 49 Rakesh Kumar CCD South Cochin 15-Oct-04 15,750
51 50 Ruheal Baig Personnel West Baroda 15-Oct-04 15,750
52 51 Mario Fernandes Sales North Jammu 16-Oct-04 15,750
53 52 Heena Godbole CCD North Lucknow 17-Oct-04 19,250
54 53 Mehul Sheth CCD West Nagpur 27-Nov-11 15,750
55 54 Vishal Virsinghani CCD East Gangtok 27-Feb-11 15,750
56 55 Lalita Rao CCD East Guwahati 28-Oct-02 15,750
57 56 Kajal Joglekar Sales West Nagpur 27-Sep-08 14,875
58 57 Katti Surti Sales South Chennai 5-May-09 14,875
59 58 Maya Panchal Mktg North Agra 1-Nov-06 17,500
60 59 Disha Parmar Admin South Banglore 10-Jan-03 19,250

Logicals Pragati Software Pvt. Ltd. Confidential Page 12

 A B C D E F G H
61 60 Geeta Darekar Mktg South Trivanadrum 20-Nov-03 19,250
62 61 Anuradha Zha Admin North Agra 21-Nov-03 19,250
63 62 Asha Trivedi Sales North Kanpur 22-Nov-03 19,250
64 63 Waheda Sheikh R&D North Jammu 20-Oct-04 17,500
65 64 Veena Patil Personnel South Hydrabad 21-Oct-04 17,500
66 65 Timsi Desai CCD East Calcutta 22-Oct-04 17,500
67 66 Parul Shah Personnel North Agra 23-Oct-04 17,500
68 67 Uday Naik Personnel North Lucknow 24-Oct-04 20,125
69 68 Mandakini Desai Sales North Delhi 27-Nov-11 14,000
70 69 Pravin Joshi Personnel North Delhi 27-Feb-11 14,000
71 70 Reeta Naik Mktg East Calcutta 28-Feb-11 14,000
72 71 Surendra Godse R&D West Panji 1-Mar-11 14,000
73 72 Yamini Gupta R&D South Mysore 18-Oct-04 17,500
74 73 Laveena Shenoy CCD North Jaipur 19-Oct-04 17,500
75 74 Nita Pandhya Sales East Darjeeling 20-Oct-04 17,500
76 75 Suraj Saksena Admin East Calcutta 21-Oct-04 17,500
77 76 Nayeem Khan CCD West Panji 22-Oct-04 17,500
78 77 Drishti Shah R&D North Delhi 23-Oct-04 17,500
79 78 Deep Chhaya Sales West Mumbai 24-Oct-04 17,500
80 79 Sagar Bidkar Mktg North Delhi 25-Oct-04 17,500
81 80 Dayanand Gandhi Mktg North Ferozepur 26-Oct-04 17,500
82 81 Tara Phule CCD South Chennai 27-Oct-04 17,500
83 82 Kalpana Shirishkar R&D East Cuttack 28-Oct-04 17,500
84 83 Kunal Shah CCD North Aligarh 26-Feb-15 7,000
85 84 Pinky Robert R&D East Calcutta 27-Feb-15 7,000
86 85 Ruby Joseph R&D North Agra 10-Jan-14 7,000
87 86 Sonia Sasan CCD North Jammu 11-Jan-14 17,500
88 87 Jignesh Tripathi Mktg South Hydrabad 12-Jan-14 17,500
89 88 Vinit Shrivastava Mktg West Pune 26-Dec-13 7,875
90 89 Tejal Patel Sales North Aligarh 17-Feb-95 22,750

Logicals Pragati Software Pvt. Ltd. Confidential Page 13

 A B C D E F G H
91 90 Priyanka Mehta R&D North Jaipur 2-Jan-96 22,750
92 91 Niki Digaria Sales East Calcutta 9-Nov-95 22,750
93 92 Payal Singhani Mktg East Gangtok 1-Apr-05 17,325
94 93 Harsha Trivedi Sales South Banglore 2-Apr-05 17,325
95 94 Radhika Kulkarni Mktg West Surat 3-Apr-05 17,325
96 95 Kabir Vora Mktg South Banglore 4-Apr-05 17,325
97 96 Beena Sharma R&D West Nagpur 5-Apr-05 17,325
98 97 Pushpa Raut R&D South Trivanadrum 6-Apr-05 17,325
99 98 Chetan Dalvi CCD North Delhi 7-Apr-05 17,325
100 99 Indu Shah Finance West Mumbai 26-Dec-13 10,500
101 100 Rupesh Sawant Finance South Hydrabad 29-Jan-15 7,875

Logicals Pragati Software Pvt. Ltd. Confidential Page 14

 I J K L M N O P Q
1 Remark 1 Remark 2 Remark 3 Remark 4
2 Criteria 1:
3 - Dept = Admin
4
5
6 Criteria 2:
7 - Dept = Sales
8 - Region = South
9
10
11 Criteria 3:
12 - Dept = Mktg
13 - Region = North & West
14 - Salary > 7000
15
16
17 Criteria 4:
18 Interchange North and West Sales teams
19
20
21
22
23
24
25
26
27
28
29
30

Logicals Pragati Software Pvt. Ltd. Confidential Page 15

 I J K L M N O P Q
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

Logicals Pragati Software Pvt. Ltd. Confidential Page 16

 I J K L M N O P Q
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

Logicals Pragati Software Pvt. Ltd. Confidential Page 17

 I J K L M N O P Q
91
92
93
94
95
96
97
98
99
100
101

Logicals Pragati Software Pvt. Ltd. Confidential Page 18

 Today Now Day

42784 42784.5928944 42784

18-Feb-17 2:13 PM Saturday
Excel Function Dictionary DATE
1998 - 2000 Peter Noneley Page 20 of 49

A B C D E F G H I J
1 DATE
2
3
4 What Does It Do?
5 This function creates a real date by using three normal numbers typed into separate cells.
6
7
8 Day Month Year Date
9 25 12 2016 12/25/16 =DATE(E4,D4,C4)
10 25 12 2016 25-Dec-16 =DATE(E5,D5,C5)
11 33 12 2016 January 2, 2017 =DATE(E6,D6,C6)
Excel Function Dictionary DATEVALUE
1998 - 2000 Peter Noneley Page 21 of 49

A B C D E F G
1 DATEVALUE
2
3
4 What Does It Do?
5 The function is used to convert a piece of text into a date which can be used in calculations.
6 Dates expressed as text are often created when data is imported from other programs, such as
7 exports from mainframe computers.
8
9
10 Date Date Value
11 25-dec-16 42729 =DATEVALUE(C4)
12 25/12/16 42729 =DATEVALUE(C5)
13 25-dec-16 42729 =DATEVALUE(C6)
14 25/12/16 42729 =DATEVALUE(C7)
15
16
17
18 Property Ref. Expiry Date Days Until Expiry
19 BC100 25-dec-16 -55
20 FG700 10-july/16 Err:502
21 TD200 13-sep-15 -524
22 HJ900 30/5/2017 Err:502
23 =DATEVALUE(E32)-TODAY()
Excel Function Dictionary DATEDIF
1998 - 2000 Peter Noneley Page 22 of 49

A B C D E F G H I J K L
1 DATEDIF
2
3 FirstDate SecondDate Interval Difference
4 1-Jan-60 10-May-70 days 3782 =DATEDIF(C4,D4,"d")
5 1-Jan-60 10-May-70 months 124 =DATEDIF(C5,D5,"m")
6 1-Jan-60 10-May-70 years 10 =DATEDIF(C6,D6,"y")
7 1-Jan-60 10-May-70 yeardays 130 =DATEDIF(C7,D7,"yd")
8 1-Jan-60 10-May-70 yearmonths 4 =DATEDIF(C8,D8,"ym")
9 1-Jan-60 10-May-70 monthdays 9 =DATEDIF(C9,D9,"md")
10
11 What Does It Do?
12 This function calculates the difference between two dates.
13 It can show the result in weeks, months or years.
14
15 Syntax
16 =DATEDIF(FirstDate,SecondDate,"Interval")
17 FirstDate : This is the earliest of the two dates.
18 SecondDate : This is the most recent of the two dates.
19 "Interval" : This indicates what you want to calculate.
20 These are the available intervals.
21 "d" Days between the two dates.
22 "m" Months between the two dates.
23 "y" Years between the two dates.
24 "yd" Days between the dates, as if the dates were in the same year.
25 "ym" Months between the dates, as if the dates were in the same year.
26 "md" Days between the two dates, as if the dates were in the same month and year.
27
28
29 Birth date : 1-Jan-60
30
31 Years lived : 57 =DATEDIF(C8,TODAY(),"y")
32 and the months 1 =DATEDIF(C8,TODAY(),"ym")
33 and the days : 17 =DATEDIF(C8,TODAY(),"md")
34
35 You can put this all together in one calculation, which creates a text version.
36 Age is 57 Years, 1 Months and 17 Days
37 ="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"
Excel Function Dictionary TIME
1998 - 2000 Peter Noneley Page 23 of 49

A B C D E F G H I
1 TIME
2
3 What Does It Do?
4 This function will convert three separate numbers to an actual time.
5
6 Hour Minute Second Time
7 14 30 59 14:30:59 =TIME(C4,D4,E4)
8 14 30 59 2:30:59 PM =TIME(C5,D5,E5)
9 14 30 59 0.60485 =TIME(C6,D6,E6)
Excel Function Dictionary TIMEVALUE
1998 - 2000 Peter Noneley Page 24 of 49

A B C D E F G H
1 TIMEVALUE
2
3 What Does It Do?
4 This function will show an actual time based on a piece of text which looks
5 like a time. It is useful when data is imported from other applications, such as
6 from mainframe computers, which convert all values to text.
7
8 Text Time
9 14:30:59 0.604849537 =TIMEVALUE(C4)
10 14:30:59 14:30:59 =TIMEVALUE(C5)
11 14:30:59 2:30:59 PM =TIMEVALUE(C6)
Excel Function Dictionary ROUND
1998 - 2000 Peter Noneley Page 25 of 49

A B C D E F G
1 ROUND
2
Places To
3 Number ROUND ROUNDDOWN ROUNDUP
Round
4 1.47589 0 1 1 2
5 1.57589 1 1.6 1.5 1.6
6 1.47589 2 1.48 1.47 1.48
7 13643.57589 -1 13640 13640 13650
8 13643.47589 -2 13600 13600 13700
9 13643.57589 -3 14000 13000 14000
10
11
12
13
Places To
14 Number MROUND
Round
15 6.5 5 5
16 27 10 30
17 31 20 40
18 13643 50 13650
19 13643 100 13600
20 13643 500 13500
Empcode First Name Last Name Dept Region Branch
1 Raja Raymondekar Sales North Ferozepur
2 Suman Shinde Sales East Cuttack
3 Kuldeep Sharma Admin South Hydrabad
4 Beena Mavadia Mktg North Delhi
5 Seema Ranganathan R&D North Kanpur
6 Julie D'Souza R&D North Mathura
7 Deepak Jain Personnel West Pune
8 Neena Mukherjee R&D North Agra
9 Pankaj Sutradhar Sales North Ambala
10 Andre Fernendes Mktg East Darjeeling
11 Sujay Madhrani Finance West Pune
12 Shilpa Lele Admin North Jammu
13 Meera Lalwani Finance East Calcutta
14 Sheetal Desai Director South Cochin
15 K. Sita Narayanan Personnel North Jammu
16 Priya Shirodkar Personnel North Jaipur
17 Aalok Trivedi Admin East Cuttack
18 Aakash Dixit Admin West Nasik
19 Parvati Khanna Mktg North Mathura
20 Farhan Sadiq Mktg North Jaipur
21 Satinder Kaur Sasan Mktg East Patna
22 Suchita Panchal Mktg West Nasik
23 Shazia Sheikh Mktg West Pune
24 Pooja Nimkar Sales West Nasik
25 Jasbinder Khurana R&D South Manglore
26 Bharat Shetty Sales East Cuttack
27 Rishi Malik Sales South Banglore
28 Mala Bhaduri R&D West Mumbai
29 Hajra Hoonjan Admin North Jaipur
30 Aalam Qureshi Personnel East Patna
31 Giriraj Gupta R&D North Agra
32 Ankur Joshi CCD South Manglore
33 Tapan Ghoshal CCD North Ambala
34 Zarina Vora CCD North Lucknow
35 Arun Joshi Mktg South Manglore
36 Pooja Khetan Personnel West Surat
37 Shilpa Parikh Finance South Mysore
38 Chitra Pednekar Finance North Aligarh
39 Sheetal Dodhia Finance North Delhi
40 Richa Raje Sales South Manglore
41 Kirtikar Sardesai Admin East Darjeeling
42 Pooja Gokhale R&D East Calcutta
43 Piyush Surti Personnel West Mumbai
44 Shaheen Khan Personnel East Cuttack
45 Kinnari Mehta R&D North Ferozepur
46 Jeena Baig Sales North Lucknow
47 Vicky Joshi Admin North Kanpur
48 Neha Joshi CCD West Baroda
49 Rakesh Kumar CCD South Cochin
50 Ruheal Baig Personnel West Baroda
51 Mario Fernandes Sales North Jammu
52 Heena Godbole CCD North Lucknow
53 Mehul Sheth CCD West Nagpur
54 Vishal Virsinghani CCD East Gangtok
55 Lalita Rao CCD East Guwahati
56 Kajal Joglekar Sales West Nagpur
57 Katti Surti Sales South Chennai
58 Maya Panchal Mktg North Agra
59 Disha Parmar Admin South Banglore
60 Geeta Darekar Mktg South Trivanadrum
61 Anuradha Zha Admin North Agra
62 Asha Trivedi Sales North Kanpur
63 Waheda Sheikh R&D North Jammu
64 Veena Patil Personnel South Hydrabad
65 Timsi Desai CCD East Calcutta
66 Parul Shah Personnel North Agra
67 Uday Naik Personnel North Lucknow
68 Mandakini Desai Sales North Delhi
69 Pravin Joshi Personnel North Delhi
70 Reeta Naik Mktg East Calcutta
71 Surendra Godse R&D West Panji
72 Yamini Gupta R&D South Mysore
73 Laveena Shenoy CCD North Jaipur
74 Nita Pandhya Sales East Darjeeling
75 Suraj Saksena Admin East Calcutta
76 Nayeem Khan CCD West Panji
77 Drishti Shah R&D North Delhi
78 Deep Chhaya Sales West Mumbai
79 Sagar Bidkar Mktg North Delhi
80 Dayanand Gandhi Mktg North Ferozepur
81 Tara Phule CCD South Chennai
82 Kalpana Shirishkar R&D East Cuttack
83 Kunal Shah CCD North Aligarh
84 Pinky Robert R&D East Calcutta
85 Ruby Joseph R&D North Agra
86 Sonia Sasan CCD North Jammu
87 Jignesh Tripathi Mktg South Hydrabad
88 Vinit Shrivastava Mktg West Pune
89 Tejal Patel Sales North Aligarh
 90 Priyanka Mehta R&D North Jaipur
91 Niki Digaria Sales East Calcutta
92 Payal Singhani Mktg East Gangtok
93 Harsha Trivedi Sales South Banglore
94 Radhika Kulkarni Mktg West Surat
95 Kabir Vora Mktg South Banglore
96 Beena Sharma R&D West Nagpur
97 Pushpa Raut R&D South Trivanadrum
98 Chetan Dalvi CCD North Delhi
99 Indu Shah Finance West Mumbai
100 Rupesh Sawant Finance South Hydrabad
Hiredate Salary
28-Dec-92 21,875
28-Dec-92 17,500 Find Value Criteria
25-Feb-15 7,000 Max Salary Overall
20-Nov-95 12,250 Min Salary Overall
31-Aug-05 21,000 Average Salary Overall
31-Aug-04 12,425
13-Aug-06 13,825 Sum Salary Overall
31-Aug-05 12,425 Sum Salary Nasik Branch
8-Dec-15 14,875 Sum Salary West Mktg Team
16-Jul-93 15,750 Average Salary North R&D Team
17-Dec-01 14,875
25-Feb-99 21,000 Count Overall
7-Dec-00 19,250 Count South Region
8-Dec-00 49,000
9-Dec-00 14,875
10-Dec-00 14,875
25-Feb-99 15,750
25-Feb-99 15,750
9-Aug-02 10,500
1-Jun-15 5,950
2-Jun-15 7,875
3-Jun-15 7,875
4-Jun-15 7,875
17-May-96 14,875
20-Apr-15 7,875
27-Sep-98 19,250
28-Jun-08 13,125
15-Mar-11 10,500
30-Apr-12 9,625
15-Oct-04 14,175
27-Sep-98 15,750
27-Sep-98 15,750
3-Jul-13 7,000
25-Sep-07 8,750
1-May-08 9,275
30-Aug-10 11,725
27-Sep-98 24,500
27-Sep-98 24,500
27-Sep-98 24,500
25-Sep-07 10,500
10-Jun-13 7,875
25-Sep-07 13,300
15-Oct-04 15,750
13-Nov-06 13,825
 3-Jul-13 11,375
25-Sep-07 15,750
3-Feb-04 15,750
15-Oct-04 15,750
15-Oct-04 15,750
15-Oct-04 15,750
16-Oct-04 15,750
17-Oct-04 19,250
27-Nov-11 15,750
27-Feb-11 15,750
28-Oct-02 15,750
27-Sep-08 14,875
5-May-09 14,875
1-Nov-06 17,500
10-Jan-03 19,250
20-Nov-03 19,250
21-Nov-03 19,250
22-Nov-03 19,250
20-Oct-04 17,500
21-Oct-04 17,500
22-Oct-04 17,500
23-Oct-04 17,500
24-Oct-04 20,125
27-Nov-11 14,000
27-Feb-11 14,000
28-Feb-11 14,000
1-Mar-11 14,000
18-Oct-04 17,500
19-Oct-04 17,500
20-Oct-04 17,500
21-Oct-04 17,500
22-Oct-04 17,500
23-Oct-04 17,500
24-Oct-04 17,500
25-Oct-04 17,500
26-Oct-04 17,500
27-Oct-04 17,500
28-Oct-04 17,500
26-Feb-15 7,000
27-Feb-15 7,000
10-Jan-14 7,000
11-Jan-14 17,500
12-Jan-14 17,500
26-Dec-13 7,875
17-Feb-95 22,750
 2-Jan-96 22,750
9-Nov-95 22,750
1-Apr-05 17,325
2-Apr-05 17,325
3-Apr-05 17,325
4-Apr-05 17,325
5-Apr-05 17,325
6-Apr-05 17,325
7-Apr-05 17,325
26-Dec-13 10,500
29-Jan-15 7,875
Sample Text VikrAnt Jain

Text Function Description

UPPER Converts a text into uppercase
LOWER Converts a text into lowercase
PROPER Converts a text into First character as capital
TRIM Removes unwanted data
LEFT Extracts characters from left
RIGHT Extracts characters from right
MID Extracts caracters from middle
CONCATENATE Join text
LEN Find the length of string
SEARCH Search for position of text
SUBSTITUTE Replace text
Example
VIKRANT JAIN
vikrant jain
Vikrant Jain
Vikrant Jain
Vikrant
Jain
ant
Hello Vikrant
12
8
Hi Vikrant
 Region Total Salary
North 633,500
East 307,125
West 277,200
South 336,000

Total Salary
700,000

600,000

500,000

400,000

300,000

200,000

100,000

0
North East West South
 Dept Total Salary Average Salary
Sales
Admin
Mktg
R&D
Personnel
Finance
Director
CCD

South
Month Turnover (Cr.) Profit (Lacs)
Apr-15 8.05 76
May-15 7.52 123
Jun-15 9.85 229
Jul-15 7.99 146
Aug-15 7.55 98
Sep-15 10.26 208
Oct-15 12.82 364
Nov-15 18.49 600
Dec-15 14.04 375
Jan-16 12.97 303
Feb-16 10.5 221
Mar-16 18.2 519
Empcode First Name Last Name Dept Region Branch
1 Raja Raymondekar Sales North Ferozepur
2 Suman Shinde Sales East Cuttack
3 Kuldeep Sharma Admin South Hydrabad
4 Beena Mavadia Mktg North Delhi
5 Seema Ranganathan R&D North Kanpur
6 Julie D'Souza R&D North Mathura
7 Deepak Jain Personnel West Pune
8 Neena Mukherjee R&D North Agra
9 Pankaj Sutradhar Sales North Ambala
10 Andre Fernendes Mktg East Darjeeling
11 Sujay Madhrani Finance West Pune
12 Shilpa Lele Admin North Jammu
13 Meera Lalwani Finance East Calcutta
14 Sheetal Desai Director South Cochin
15 K. Sita Narayanan Personnel North Jammu
16 Priya Shirodkar Personnel North Jaipur
17 Aalok Trivedi Admin East Cuttack
18 Aakash Dixit Admin West Nasik
19 Parvati Khanna Mktg North Mathura
20 Farhan Sadiq Mktg North Jaipur
21 Satinder Kaur Sasan Mktg East Patna
22 Suchita Panchal Mktg West Nasik
23 Shazia Sheikh Mktg West Pune
24 Pooja Nimkar Sales West Nasik
25 Jasbinder Khurana R&D South Manglore
26 Bharat Shetty Sales East Cuttack
27 Rishi Malik Sales South Banglore
28 Mala Bhaduri R&D West Mumbai
29 Hajra Hoonjan Admin North Jaipur
30 Aalam Qureshi Personnel East Patna
31 Giriraj Gupta R&D North Agra
32 Ankur Joshi CCD South Manglore
33 Tapan Ghoshal CCD North Ambala
34 Zarina Vora CCD North Lucknow
35 Arun Joshi Mktg South Manglore
36 Pooja Khetan Personnel West Surat
37 Shilpa Parikh Finance South Mysore
38 Chitra Pednekar Finance North Aligarh
39 Sheetal Dodhia Finance North Delhi
40 Richa Raje Sales South Manglore
41 Kirtikar Sardesai Admin East Darjeeling
42 Pooja Gokhale R&D East Calcutta
43 Piyush Surti Personnel West Mumbai
44 Shaheen Khan Personnel East Cuttack
45 Kinnari Mehta R&D North Ferozepur
46 Jeena Baig Sales North Lucknow
47 Vicky Joshi Admin North Kanpur
48 Neha Joshi CCD West Baroda
49 Rakesh Kumar CCD South Cochin
50 Ruheal Baig Personnel West Baroda
51 Mario Fernandes Sales North Jammu
52 Heena Godbole CCD North Lucknow
53 Mehul Sheth CCD West Nagpur
54 Vishal Virsinghani CCD East Gangtok
55 Lalita Rao CCD East Guwahati
56 Kajal Joglekar Sales West Nagpur
57 Katti Surti Sales South Chennai
58 Maya Panchal Mktg North Agra
59 Disha Parmar Admin South Banglore
60 Geeta Darekar Mktg South Trivanadrum
61 Anuradha Zha Admin North Agra
62 Asha Trivedi Sales North Kanpur
63 Waheda Sheikh R&D North Jammu
64 Veena Patil Personnel South Hydrabad
65 Timsi Desai CCD East Calcutta
66 Parul Shah Personnel North Agra
67 Uday Naik Personnel North Lucknow
68 Mandakini Desai Sales North Delhi
69 Pravin Joshi Personnel North Delhi
70 Reeta Naik Mktg East Calcutta
71 Surendra Godse R&D West Panji
72 Yamini Gupta R&D South Mysore
73 Laveena Shenoy CCD North Jaipur
74 Nita Pandhya Sales East Darjeeling
75 Suraj Saksena Admin East Calcutta
76 Nayeem Khan CCD West Panji
77 Drishti Shah R&D North Delhi
78 Deep Chhaya Sales West Mumbai
79 Sagar Bidkar Mktg North Delhi
80 Dayanand Gandhi Mktg North Ferozepur
81 Tara Phule CCD South Chennai
82 Kalpana Shirishkar R&D East Cuttack
83 Kunal Shah CCD North Aligarh
84 Pinky Robert R&D East Calcutta
85 Ruby Joseph R&D North Agra
86 Sonia Sasan CCD North Jammu
87 Jignesh Tripathi Mktg South Hydrabad
88 Vinit Shrivastava Mktg West Pune
89 Tejal Patel Sales North Aligarh
 90 Priyanka Mehta R&D North Jaipur
91 Niki Digaria Sales East Calcutta
92 Payal Singhani Mktg East Gangtok
93 Harsha Trivedi Sales South Banglore
94 Radhika Kulkarni Mktg West Surat
95 Kabir Vora Mktg South Banglore
96 Beena Sharma R&D West Nagpur
97 Pushpa Raut R&D South Trivanadrum
98 Chetan Dalvi CCD North Delhi
99 Indu Shah Finance West Mumbai
100 Rupesh Sawant Finance South Hydrabad
Hiredate Salary
28-Dec-92 21,875
28-Dec-92 17,500
25-Feb-15 7,000
20-Nov-95 12,250
31-Aug-05 21,000
31-Aug-04 12,425
13-Aug-06 13,825
31-Aug-05 12,425
8-Dec-15 14,875
16-Jul-93 15,750
17-Dec-01 14,875
25-Feb-99 21,000
7-Dec-00 19,250
8-Dec-00 49,000
9-Dec-00 14,875
10-Dec-00 14,875
25-Feb-99 15,750
25-Feb-99 15,750
9-Aug-02 10,500
1-Jun-15 5,950
2-Jun-15 7,875
3-Jun-15 7,875
4-Jun-15 7,875
17-May-96 14,875
20-Apr-15 7,875
27-Sep-98 19,250
28-Jun-08 13,125
15-Mar-11 10,500
30-Apr-12 9,625
15-Oct-04 14,175
27-Sep-98 15,750
27-Sep-98 15,750
3-Jul-13 7,000
25-Sep-07 8,750
1-May-08 9,275
30-Aug-10 11,725
27-Sep-98 24,500
27-Sep-98 24,500
27-Sep-98 24,500
25-Sep-07 10,500
10-Jun-13 7,875
25-Sep-07 13,300
15-Oct-04 15,750
13-Nov-06 13,825
 3-Jul-13 11,375
25-Sep-07 15,750
3-Feb-04 15,750
15-Oct-04 15,750
15-Oct-04 15,750
15-Oct-04 15,750
16-Oct-04 15,750
17-Oct-04 19,250
27-Nov-11 15,750
27-Feb-11 15,750
28-Oct-02 15,750
27-Sep-08 14,875
5-May-09 14,875
1-Nov-06 17,500
10-Jan-03 19,250
20-Nov-03 19,250
21-Nov-03 19,250
22-Nov-03 19,250
20-Oct-04 17,500
21-Oct-04 17,500
22-Oct-04 17,500
23-Oct-04 17,500
24-Oct-04 20,125
27-Nov-11 14,000
27-Feb-11 14,000
28-Feb-11 14,000
1-Mar-11 14,000
18-Oct-04 17,500
19-Oct-04 17,500
20-Oct-04 17,500
21-Oct-04 17,500
22-Oct-04 17,500
23-Oct-04 17,500
24-Oct-04 17,500
25-Oct-04 17,500
26-Oct-04 17,500
27-Oct-04 17,500
28-Oct-04 17,500
26-Feb-15 7,000
27-Feb-15 7,000
10-Jan-14 7,000
11-Jan-14 17,500
12-Jan-14 17,500
26-Dec-13 7,875
17-Feb-95 22,750
 2-Jan-96 22,750
9-Nov-95 22,750
1-Apr-05 17,325
2-Apr-05 17,325
3-Apr-05 17,325
4-Apr-05 17,325
5-Apr-05 17,325
6-Apr-05 17,325
7-Apr-05 17,325
26-Dec-13 10,500
29-Jan-15 7,875
Month Turnover (Cr.) Profit (Lacs)
Apr-15 8.05 76
May-15 7.52 123
Jun-15 9.85 229
Jul-15 7.99 146
Aug-15 7.55 98
Sep-15 10.26 208
Oct-15 12.82 364
Nov-15 18.49 600
Dec-15 14.04 375
Jan-16 12.97 303
Feb-16 10.5 221
Mar-16 18.2 519
Empcode First Name Last Name Dept Region Branch
1 Raja Raymondekar Sales North Ferozepur
2 Suman Shinde Sales East Cuttack
3 Kuldeep Sharma Admin South Hydrabad
4 Beena Mavadia Mktg North Delhi
5 Seema Ranganathan R&D North Kanpur
6 Julie D'Souza R&D North Mathura
7 Deepak Jain Personnel West Pune
8 Neena Mukherjee R&D North Agra
9 Pankaj Sutradhar Sales North Ambala
10 Andre Fernendes Mktg East Darjeeling
11 Sujay Madhrani Finance West Pune
12 Shilpa Lele Admin North Jammu
13 Meera Lalwani Finance East Calcutta
14 Sheetal Desai Director South Cochin
15 K. Sita Narayanan Personnel North Jammu
16 Priya Shirodkar Personnel North Jaipur
17 Aalok Trivedi Admin East Cuttack
18 Aakash Dixit Admin West Nasik
19 Parvati Khanna Mktg North Mathura
20 Farhan Sadiq Mktg North Jaipur
21 Satinder Kaur Sasan Mktg East Patna
22 Suchita Panchal Mktg West Nasik
23 Shazia Sheikh Mktg West Pune
24 Pooja Nimkar Sales West Nasik
25 Jasbinder Khurana R&D South Manglore
26 Bharat Shetty Sales East Cuttack
27 Rishi Malik Sales South Banglore
28 Mala Bhaduri R&D West Mumbai
29 Hajra Hoonjan Admin North Jaipur
30 Aalam Qureshi Personnel East Patna
31 Giriraj Gupta R&D North Agra
32 Ankur Joshi CCD South Manglore
33 Tapan Ghoshal CCD North Ambala
34 Zarina Vora CCD North Lucknow
35 Arun Joshi Mktg South Manglore
36 Pooja Khetan Personnel West Surat
37 Shilpa Parikh Finance South Mysore
38 Chitra Pednekar Finance North Aligarh
39 Sheetal Dodhia Finance North Delhi
40 Richa Raje Sales South Manglore
41 Kirtikar Sardesai Admin East Darjeeling
42 Pooja Gokhale R&D East Calcutta
43 Piyush Surti Personnel West Mumbai
44 Shaheen Khan Personnel East Cuttack
45 Kinnari Mehta R&D North Ferozepur
46 Jeena Baig Sales North Lucknow
47 Vicky Joshi Admin North Kanpur
48 Neha Joshi CCD West Baroda
49 Rakesh Kumar CCD South Cochin
50 Ruheal Baig Personnel West Baroda
51 Mario Fernandes Sales North Jammu
52 Heena Godbole CCD North Lucknow
53 Mehul Sheth CCD West Nagpur
54 Vishal Virsinghani CCD East Gangtok
55 Lalita Rao CCD East Guwahati
56 Kajal Joglekar Sales West Nagpur
57 Katti Surti Sales South Chennai
58 Maya Panchal Mktg North Agra
59 Disha Parmar Admin South Banglore
60 Geeta Darekar Mktg South Trivanadrum
61 Anuradha Zha Admin North Agra
62 Asha Trivedi Sales North Kanpur
63 Waheda Sheikh R&D North Jammu
64 Veena Patil Personnel South Hydrabad
65 Timsi Desai CCD East Calcutta
66 Parul Shah Personnel North Agra
67 Uday Naik Personnel North Lucknow
68 Mandakini Desai Sales North Delhi
69 Pravin Joshi Personnel North Delhi
70 Reeta Naik Mktg East Calcutta
71 Surendra Godse R&D West Panji
72 Yamini Gupta R&D South Mysore
73 Laveena Shenoy CCD North Jaipur
74 Nita Pandhya Sales East Darjeeling
75 Suraj Saksena Admin East Calcutta
76 Nayeem Khan CCD West Panji
77 Drishti Shah R&D North Delhi
78 Deep Chhaya Sales West Mumbai
79 Sagar Bidkar Mktg North Delhi
80 Dayanand Gandhi Mktg North Ferozepur
81 Tara Phule CCD South Chennai
82 Kalpana Shirishkar R&D East Cuttack
83 Kunal Shah CCD North Aligarh
84 Pinky Robert R&D East Calcutta
85 Ruby Joseph R&D North Agra
86 Sonia Sasan CCD North Jammu
87 Jignesh Tripathi Mktg South Hydrabad
88 Vinit Shrivastava Mktg West Pune
89 Tejal Patel Sales North Aligarh
 90 Priyanka Mehta R&D North Jaipur
91 Niki Digaria Sales East Calcutta
92 Payal Singhani Mktg East Gangtok
93 Harsha Trivedi Sales South Banglore
94 Radhika Kulkarni Mktg West Surat
95 Kabir Vora Mktg South Banglore
96 Beena Sharma R&D West Nagpur
97 Pushpa Raut R&D South Trivanadrum
98 Chetan Dalvi CCD North Delhi
99 Indu Shah Finance West Mumbai
100 Rupesh Sawant Finance South Hydrabad
June Expense
21,875
17,500
7,000
12,250
21,000
12,425
13,825
12,425
14,875
15,750
14,875
21,000
19,250
49,000
14,875
14,875
15,750
15,750
10,500
5,950
7,875
7,875
7,875
14,875
7,875
19,250
13,125
10,500
9,625
14,175
15,750
15,750
7,000
8,750
9,275
11,725
24,500
24,500
24,500
10,500
7,875
13,300
15,750
13,825
11,375
15,750
15,750
15,750
15,750
15,750
15,750
19,250
15,750
15,750
15,750
14,875
14,875
17,500
19,250
19,250
19,250
19,250
17,500
17,500
17,500
17,500
20,125
14,000
14,000
14,000
14,000
17,500
17,500
17,500
17,500
17,500
17,500
17,500
17,500
17,500
17,500
17,500
7,000
7,000
7,000
17,500
17,500
7,875
22,750
22,750
22,750
17,325
17,325
17,325
17,325
17,325
17,325
17,325
10,500
7,875