Advance Excel Assignment_vinod

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Advance Excel Assignment_vinod as PDF for free.

More details

  • Words: 7,329
  • Pages: 45
1 2 3 4 5 6 7

A

B

Product

East Sales

C

D

E

F

West

North

% Sales

% Sales

G

H South

% Sales

I

J

% Sales

Thums Up

2.66

1.24

1.12

1.69

6.71

Uncle Chipps

13.11

9.74

13.28

19.23

55.36

Maggi

10.4

11.13

12.44

14.92

48.89

Amul Choc.

171.68

115.89

187.29

135.05

609.91

Total

197.85

138

214.13

170.89

720.87

Mixed cell

K

Total %

Pragati Software Pvt. Ltd.

Page 1

Data Validation Emp Code Name Age Salary Joining Date 1

18

2

23

24-Jun-08

3 4 5 6 7 8

Data Validation 1

Emp Code No Duplicate

2

EmpName only Text

3

Age only Numeric Data

4

Salary 5000 to 50000

5

Joining Date should be Less then current Date

Employee Information System Employee Code Name Region Department Salary

1

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

B

C

2005

2006

Sales

50000

54500

Other Income

25000

28000

Gross Income

75000

82500

Tel. Exp

3200

3264

Tra. Exp

3500

3570

Mis. Exp

2500

2537.5

Total Exp

9200

9371.5

Net Income

65800

73128.5

D

E

F

Expense

Scenarios

Current Scenario

Best Scenario

Worst Scenario

Sales

9%

13%

5%

Other Income

12%

18%

8%

Tel. Exp

2%

3%

5%

Tra. Exp

2%

4%

5%

Mis. Exp

1.50%

1.50%

1.50%

Pragati Software Pvt. Ltd.

Page 4

aa

0.13 0.18 0.03 0.04 0.02

Page 5

Financial functions and what-if analysis Months PPMT IPMT PMT 1 Loan Amount

100000

Rate of Interest

10.50%

Payment /month 36

U

si n

g

D

at a

Ta bl

e

PMT [EMI]

100000 150000 200000 12 24 36 48 60

RAjesh

Deshmukh

101

Text Function

Description

Example

Upper

Converts a text into uppercase

RAJESH

Lower

Converts a text into lowercase

rajesh

Proper

Converts a text into First character as capital

Rajesh

Left

Extracts characters from left

RAj

Right

Extracts characters from right

esh

Mid

Extracts caracters from middle

jes

Concatenate

Join text

Hello RAjeshDeshmukh

Len

Find the length of string

6

Exact

Checks for two text are same or not

TRUE

Search

Search for position of text

7

Replace

Changes the text

India was my country

Text

Changes value to text format

$101.00

Maths Functions

Description

Example

Abs

Converts negative number to positive number

25

Int

Discards decimals

1236

Mod

Gives the remainder from division

3

Sqrt

Gives root value

9

Power

Gives the number raised to power of

8

Round

Rounds to nearest number

1236.57

Trunc

Truncates to lower number

1236.56

Statistical Functions

Description

Example

CountA

Counts text and numbers

3

Countblank

Counts blank cells

1

Small

Finds the nth small value

20

Large

Finsd the nth large value

40

Date Functions

Description

Example

Date

Adds day, month, year

1/14/2004

Today

Current date

10/15/2008

Now

Current date and time

10/15/2008 3:19

Day

Extracts day fromCurrent date

15

Month

Extracts month fromCurrent date

10

Year

Extracts year from Curent date

2008

Time

Adds Hr, min, second

12:30 PM

Hour

Extracts Hours from given time

12

Minute

Extracts Minutes from given time

30

FUNCTIONS

Second

Extracts Seconds from given time

45

Weekday

Extracts day from Current date

Wednesday

Information Functions

Description

Example

IsBlank

Returns true if blank cell or false if non blank cell

Blank cell

IsError

Returns error value

#NA

Isnumber

Returns true if data is number

450.75

Istext

Returns true if data is text

apple

12

10

Good

20

Bad

30 40 50

apple medicine #ref1 #NA 450.75

Empcode First Name

Last Name

Dept

Region Branch

Hiredate

Salary

17

Aalok

Trivedi

Admin

east

Calcutta

1-Mar-83

15750

41

Kirtikar

Sardesai

Admin

east

Darjeeling

14-Jun-97

7875

75

Suraj

Saksena

Admin

east

Calcutta

25-Oct-88

17500

12

Shilpa

Lele

Admin

north

Jammu

1-Mar-83

29

Hajra

Hoonjan

Admin

north

Jaipur

4-May-96

9625

47

Vicky

Joshi

Admin

north

Kanpur

7-Feb-88

15750

61

Anuradha

Zha

Admin

north

Agra

25-Nov-87

19250

east Total

41125

north Total

65625

3

Kuldeep

Sharma

Admin

south

Hydrabad

1-Mar-99

59

Disha

Parmar

Admin

south

Banglore

14-Jan-87

18

Aakash

Dixit

Admin

south Total west

Nasik

21000

7000 19250 26250

1-Mar-83

west Total

15750 15750

Admin Total

148750

54

Vishal

Virsinghani

CCD

east

Gangtok

3-Mar-95

15750

55

Lalita

Rao

CCD

east

Guwahati

1-Nov-86

15750

65

Timsi

Desai

CCD

east

Calcutta

26-Oct-88

17500

east Total

49000

33

Tapan

Ghoshal

CCD

north

Ambala

7-Jul-97

7000

34

Zarina

Vora

CCD

north

Lucknow

29-Sep-91

8750

52

Heena

Godbole

CCD

north

Lucknow

21-Oct-88

19250

73

Laveena

Shenoy

CCD

north

Jaipur

23-Oct-88

17500

83

Kunal

Shah

CCD

north

Aligarh

2-Mar-99

86

Sonia

Sasan

CCD

north

Jammu

15-Jan-98

17500

98

Chetan

Dalvi

CCD

north

Delhi

11-Apr-89

17325

32

Ankur

Joshi

CCD

south

Manglore

1-Oct-82

15750

49

Rakesh

Kumar

CCD

south

cochin

19-Oct-88

15750

81

Tara

Phule

CCD

south

chennai

31-Oct-88

17500

48

Neha

Joshi

CCD

west

Baroda

19-Oct-88

15750

53

Mehul

Sheth

CCD

west

Nagpur

1-Dec-95

15750

76

Nayeem

Khan

CCD

west

Panji

26-Oct-88

17500

north Total

94325

south Total

49000

west Total

49000

CCD Total 13

Meera

Lalwani

Finance

7000

241325 east

Calcutta

11-Dec-84

east Total

19250 19250

38

Chitra

Pednekar

Finance

north

Aligarh

1-Oct-82

24500

39

Sheetal

Dodhia

Finance

north

delhi

1-Oct-82

24500

14

Sheetal

Desai

Finance

south

cochin

12-Dec-84

30000

37

Shilpa

Parikh

Finance

south

Mysore

1-Oct-82

24500

100

Rupesh

Sawant

Finance

south

Hydrabad

2-Feb-99

7875

north Total

south Total

49000

62375

11

Sujay

Madhrani

Finance

west

Pune

21-Dec-85

14875

99

Indu

Shah

Finance

west

Mumbai

30-Dec-97

10500

west Total

25375

Finance Total

156000

10

Andre

Fernendes

Mktg

east

Darjeeling

20-Jul-77

15750

21

Satinder Kaur

Sasan

Mktg

east

Patna

6-Jun-99

7875

70

Reeta

Naik

Mktg

east

Calcutta

4-Mar-95

14000

92

Payal

Singhani

Mktg

east

Gangtok

5-Apr-89

17325

4

Beena

Mavadia

Mktg

north

Delhi

24-Nov-79

12250

19

Parvati

Khanna

Mktg

north

Mathura

13-Aug-86

10500

20

Farhan

Sadiq

Mktg

north

Jaipur

5-Jun-99

5950

58

Maya

Panchal

Mktg

north

Agra

5-Nov-90

17500

79

Sagar

Bidkar

Mktg

north

Delhi

29-Oct-88

17500

80

Dayanand

Gandhi

Mktg

north

Ferozepur

30-Oct-88

17500

east Total

54950

north Total

81200

35

Arun

Joshi

Mktg

south

Manglore

60

Geeta

Darekar

Mktg

south

Trivanadrum 24-Nov-87

5-May-92

19250

87

Jignesh

Tripathi

Mktg

south

Hydrabad

16-Jan-98

17500

95

Kabir

Vora

Mktg

south

Banglore

8-Apr-89

17325

22

Suchita

Panchal

Mktg

west

Nasik

7-Jun-99

7875

23

Shazia

Sheikh

Mktg

west

Pune

8-Jun-99

7875

88

Vinit

Shrivastava

Mktg

west

Pune

30-Dec-97

7875

94

Radhika

Kulkarni

Mktg

west

Surat

7-Apr-89

south Total

9275

63350

west Total

17325 40950

Mktg Total

240450

30

Aalam

Qureshi

Personnel

east

Patna

19-Oct-88

14175

44

Shaheen

Khan

Personnel

east

Cuttack

17-Nov-90

13825

15

K. Sita

Narayanan

Personnel

north

Jammu

13-Dec-84

14875

16

Priya

Shirodkar

Personnel

north

Jaipur

14-Dec-84

14875

66

Parul

Shah

Personnel

north

Agra

27-Oct-88

17500

67

Uday

Naik

Personnel

north

Lucknow

28-Oct-88

20125

69

Pravin

Joshi

Personnel

north

delhi

3-Mar-95

14000

64

Veena

Patil

Personnel

7

Deepak

Jain

Personnel

west

Pune

17-Aug-90

13825

36

Pooja

Khetan

Personnel

west

Surat

3-Sep-94

11725

43

Piyush

Surti

Personnel

west

Mumbai

19-Oct-88

15750

50

Ruheal

Baig

Personnel

west

Baroda

19-Oct-88

15750

east Total

28000

north Total south

Hydrabad

81375 25-Oct-88

south Total

17500 17500

west Total

57050

Personnel Total

183925

42

Pooja

Gokhale

R&D

east

Calcutta

29-Sep-91

13300

82

Kalpana

Shirishkar

R&D

east

Cuttack

1-Nov-88

17500

84

Pinky

Robert

R&D

east

Calcutta

3-Mar-99

east Total

7000 37800

5

Seema

Ranganathan

R&D

north

Kanpur

4-Sep-89

21000

6

Julie

D'Souza

R&D

north

Mathura

4-Sep-88

12425

8

Neena

Mukherjee

R&D

north

Agra

4-Sep-89

12425

31

Giriraj

Gupta

R&D

north

Agra

1-Oct-82

15750

45

Kinnari

Mehta

R&D

north

Ferozepur

7-Jul-97

11375

63

Waheda

Sheikh

R&D

north

Jammu

24-Oct-88

17500

77

Drishti

Shah

R&D

north

Delhi

27-Oct-88

17500

85

Ruby

Joseph

R&D

north

Agra

14-Jan-98

7000

90

Priyanka

Mehta

R&D

north

Jaipur

6-Jan-80

north Total

22750 137725

25

Jasbinder

Khurana

R&D

south

Manglore

24-Apr-99

7875

72

Yamini

Gupta

R&D

south

Mysore

22-Oct-88

17500

97

Pushpa

Raut

R&D

south

Trivanadrum 10-Apr-89

17325

south Total

42700

28

Mala

Bhaduri

R&D

west

Mumbai

19-Mar-95

10500

71

Surendra

Godse

R&D

west

Panji

5-Mar-95

14000

96

Beena

Sharma

R&D

west

Nagpur

9-Apr-89

17325

west Total

41825

R&D Total

260050

2

Suman

Shinde

Sales

east

Cuttack

1-Jan-77

17500

26

Bharat

Shetty

Sales

east

Cuttack

1-Oct-82

19250

74

Nita

Pandhya

Sales

east

Darjeeling

24-Oct-88

17500

91

Niki

Digaria

Sales

east

Calcutta

13-Nov-79

22750

east Total

77000

1

Raja

Raymondekar

Sales

north

Ferozepur

1-Jan-77

24000

9

Pankaj

Sutradhar

Sales

north

Ambala

12-Dec-99

14875

46

Jeena

Baig

Sales

north

Lucknow

29-Sep-91

15750

51

Mario

Fernandes

Sales

north

Jammu

20-Oct-88

15750

62

Asha

Trivedi

Sales

north

Kanpur

26-Nov-87

19250

68

Mandakini

Desai

Sales

north

delhi

1-Dec-95

14000

89

Tejal

Patel

Sales

north

Aligarh

21-Feb-79

22750

27

Rishi

Malik

Sales

south

Banglore

2-Jul-92

13125

40

Richa

Raje

Sales

south

Manglore

29-Sep-91

10500

57

Katti

Surti

Sales

south

chennai

9-May-93

14875

93

Harsha

Trivedi

Sales

south

Banglore

6-Apr-89

17325

north Total

126375

south Total

55825

24

Pooja

Nimkar

Sales

west

Nasik

21-May-80

14875

56

Kajal

Joglekar

Sales

west

Nagpur

1-Oct-92

14875

78

Deep

Chhaya

Sales

west

Mumbai

28-Oct-88

17500

west Total Sales Total Grand Total

47250 306450 1536950

Chart4

32000.00 4800.00

32000.00

5000.00 4750.00

30000.00

4500.00

28000.00

4250.00

26000.00

4000.00

24000.00

3750.00 23000.00 3450.00 3500.00

22000.00

21000.00 3150.00

20000.00 18000.00 16000.00

3250.00 19250.00 2887.50

17500.00 2625.00

19250.00 2887.50

2750.00

15750.00 2362.50

2500.00 2250.00

14000.00

2000.00

12000.00

1750.00 9625.00 1443.75

10000.00 8000.00

1500.00

7875.00 1181.25

1250.00

7000.00 1050.00

1000.00

6000.00

750.00

4000.00

500.00

2000.00 0.00 Aalok

3000.00

250.00 Kirtikar

Suraj

Shilpa

Hajra

Vicky

Page 14

Anuradh a

Kuldeep

Disha

0.00 Aakash

Salary DA

Chart4

Salary DA

Page 15

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

Pivot

B

C

D

E

F

G

H Salary

I

Empcode First Name

Last Name

Dept

Region Branch

Hiredate

17

Aalok

Trivedi

Admin

East

Calcutta

1-Mar-83

15750.00

2362.50

41

Kirtikar

Sardesai

Admin

East

Darjeeling

14-Jun-97

7875.00

1181.25

75

Suraj

Saksena

Admin

East

Calcutta

25-Oct-88

17500.00

2625.00

12

Shilpa

Lele

Admin

North

Jammu

1-Mar-83

21000.00

3150.00

29

Hajra

Hoonjan

Admin

North

Jaipur

4-May-96

9625.00

1443.75

47

Vicky

Joshi

Admin

North

Kanpur

7-Feb-88

32000.00

4800.00

61

Anuradha

Zha

Admin

North

Agra

25-Nov-87

19250.00

2887.50

3

Kuldeep

Sharma

Admin

South

Hydrabad

1-Mar-99

7000.00

1050.00

59

Disha

Parmar

Admin

South

Banglore

14-Jan-87

19250.00

2887.50

18

Aakash

Dixit

Admin

West

Nasik

1-Mar-83

23000.00

3450.00

54

Vishal

Virsinghani

CCD

East

Gangtok

3-Mar-95

15750.00

2362.50

55

Lalita

Rao

CCD

East

Guwahati

1-Nov-86

15750.00

2362.50

65

Timsi

Desai

CCD

East

Calcutta

26-Oct-88

17500.00

2625.00

33

Tapan

Ghoshal

CCD

North

Ambala

7-Jul-97

7000.00

1050.00

34

Zarina

Vora

CCD

North

Lucknow

29-Sep-91

8750.00

1312.50

52

Heena

Godbole

CCD

North

Lucknow

21-Oct-88

19250.00

2887.50

73

Laveena

Shenoy

CCD

North

Jaipur

23-Oct-88

17500.00

2625.00

83

Kunal

Shah

CCD

North

Aligarh

2-Mar-99

7000.00

1050.00

86

Sonia

Sasan

CCD

North

Jammu

15-Jan-98

17500.00

2625.00

98

Chetan

Dalvi

CCD

North

Delhi

11-Apr-89

17325.00

2598.75

32

Ankur

Joshi

CCD

South

Manglore

1-Oct-82

15750.00

2362.50

49

Rakesh

Kumar

CCD

South

cochin

19-Oct-88

15750.00

2362.50

81

Tara

Phule

CCD

South

chennai

31-Oct-88

17500.00

2625.00

48

Neha

Joshi

CCD

West

Baroda

19-Oct-88

15750.00

2362.50

53

Mehul

Sheth

CCD

West

Nagpur

1-Dec-95

15750.00

2362.50

76

Nayeem

Khan

CCD

West

Panji

26-Oct-88

17500.00

2625.00

13

Meera

Lalwani

Finance

East

Calcutta

11-Dec-84

19250.00

2887.50

38

Chitra

Pednekar

Finance

North

Aligarh

1-Oct-82

24500.00

3675.00

39

Sheetal

Dodhia

Finance

North

delhi

1-Oct-82

24500.00

3675.00

14

Sheetal

Desai

Finance

South

cochin

12-Dec-84

30000.00

4500.00

37

Shilpa

Parikh

Finance

South

Mysore

1-Oct-82

24500.00

3675.00

100

Rupesh

Sawant

Finance

South

Hydrabad

2-Feb-99

7875.00

1181.25

11

Sujay

Madhrani

Finance

West

Pune

21-Dec-85

14875.00

2231.25

99

Indu

Shah

Finance

West

Mumbai

30-Dec-97

10500.00

1575.00

10

Andre

Fernendes

Mktg

East

Darjeeling

20-Jul-77

15750.00

2362.50

Pragati Software Pvt. Ltd. Confidential

DA

Page 16

A 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

Pivot

B

C

D

E

F

G

H

I

21

Satinder Kaur

Sasan

Mktg

East

Patna

6-Jun-99

7875.00

1181.25

70

Reeta

Naik

Mktg

East

Calcutta

4-Mar-95

14000.00

2100.00

92

Payal

Singhani

Mktg

East

Gangtok

5-Apr-89

17325.00

2598.75

4

Beena

Mavadia

Mktg

North

Delhi

24-Nov-79

12250.00

1837.50

19

Parvati

Khanna

Mktg

North

Mathura

13-Aug-86

10500.00

1575.00

20

Farhan

Sadiq

Mktg

North

Jaipur

5-Jun-99

5950.00

892.50

58

Maya

Panchal

Mktg

North

Agra

5-Nov-90

17500.00

2625.00

79

Sagar

Bidkar

Mktg

North

Delhi

29-Oct-88

17500.00

2625.00

80

Dayanand

Gandhi

Mktg

North

Ferozepur

30-Oct-88

17500.00

2625.00

35

Arun

Joshi

Mktg

South

Manglore

5-May-92

9275.00

1391.25

60

Geeta

Darekar

Mktg

South

Trivanadrum 24-Nov-87

19250.00

2887.50

87

Jignesh

Tripathi

Mktg

South

Hydrabad

16-Jan-98

17500.00

2625.00

95

Kabir

Vora

Mktg

South

Banglore

8-Apr-89

17325.00

2598.75

22

Suchita

Panchal

Mktg

West

Nasik

7-Jun-99

7875.00

1181.25

23

Shazia

Sheikh

Mktg

West

Pune

8-Jun-99

7875.00

1181.25

88

Vinit

Shrivastava

Mktg

West

Pune

30-Dec-97

7875.00

1181.25

94

Radhika

Kulkarni

Mktg

West

Surat

7-Apr-89

17325.00

2598.75

30

Aalam

Qureshi

Personnel

East

Patna

19-Oct-88

14175.00

2126.25

44

Shaheen

Khan

Personnel

East

Cuttack

17-Nov-90

13825.00

2073.75

15

K. Sita

Narayanan

Personnel

North

Jammu

13-Dec-84

14875.00

2231.25

16

Priya

Shirodkar

Personnel

North

Jaipur

14-Dec-84

14875.00

2231.25

66

Parul

Shah

Personnel

North

Agra

27-Oct-88

17500.00

2625.00

67

Uday

Naik

Personnel

North

Lucknow

28-Oct-88

20125.00

3018.75

69

Pravin

Joshi

Personnel

North

delhi

3-Mar-95

14000.00

2100.00

64

Veena

Patil

Personnel

South

Hydrabad

25-Oct-88

17500.00

2625.00

7

Deepak

Jain

Personnel

West

Pune

17-Aug-90

13825.00

2073.75

36

Pooja

Khetan

Personnel

West

Surat

3-Sep-94

11725.00

1758.75

43

Piyush

Surti

Personnel

West

Mumbai

19-Oct-88

15750.00

2362.50

50

Ruheal

Baig

Personnel

West

Baroda

19-Oct-88

15750.00

2362.50

42

Pooja

Gokhale

R&D

East

Calcutta

29-Sep-91

13300.00

1995.00

82

Kalpana

Shirishkar

R&D

East

Cuttack

1-Nov-88

17500.00

2625.00

84

Pinky

Robert

R&D

East

Calcutta

3-Mar-99

7000.00

1050.00

5

Seema

Ranganathan

R&D

North

Kanpur

4-Sep-89

21000.00

3150.00

6

Julie

D'Souza

R&D

North

Mathura

4-Sep-88

12425.00

1863.75

8

Neena

Mukherjee

R&D

North

Agra

4-Sep-89

12425.00

1863.75

31

Giriraj

Gupta

R&D

North

Agra

1-Oct-82

15750.00

2362.50

Pragati Software Pvt. Ltd. Confidential

Page 17

A 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 101 102

Pivot

H

I

45

Kinnari

B Mehta

C R&D

D

North

E

Ferozepur

F

7-Jul-97

G

11375.00

1706.25

63

Waheda

Sheikh

R&D

North

Jammu

24-Oct-88

17500.00

2625.00

77

Drishti

Shah

R&D

North

Delhi

27-Oct-88

17500.00

2625.00

85

Ruby

Joseph

R&D

North

Agra

14-Jan-98

7000.00

1050.00

90

Priyanka

Mehta

R&D

North

Jaipur

6-Jan-80

22750.00

3412.50

25

Jasbinder

Khurana

R&D

South

Manglore

24-Apr-99

7875.00

1181.25

72

Yamini

Gupta

R&D

South

Mysore

22-Oct-88

17500.00

2625.00

97

Pushpa

Raut

R&D

South

Trivanadrum 10-Apr-89

17325.00

2598.75

28

Mala

Bhaduri

R&D

West

Mumbai

19-Mar-95

10500.00

1575.00

71

Surendra

Godse

R&D

West

Panji

5-Mar-95

14000.00

2100.00

96

Beena

Sharma

R&D

West

Nagpur

9-Apr-89

17325.00

2598.75

2

Suman

Shinde

Sales

East

Cuttack

1-Jan-77

17500.00

2625.00

26

Bharat

Shetty

Sales

East

Cuttack

1-Oct-82

19250.00

2887.50

74

Nita

Pandhya

Sales

East

Darjeeling

24-Oct-88

17500.00

2625.00

91

Niki

Digaria

Sales

East

Calcutta

13-Nov-79

22750.00

3412.50

1

Raja

Raymondekar

Sales

North

Ferozepur

1-Jan-77

24000.00

3600.00

9

Pankaj

Sutradhar

Sales

North

Ambala

12-Dec-99

14875.00

2231.25

46

Jeena

Baig

Sales

North

Lucknow

29-Sep-91

15750.00

2362.50

51

Mario

Fernandes

Sales

North

Jammu

20-Oct-88

15750.00

2362.50

62

Asha

Trivedi

Sales

North

Kanpur

26-Nov-87

19250.00

2887.50

68

Mandakini

Desai

Sales

North

delhi

1-Dec-95

14000.00

2100.00

89

Tejal

Patel

Sales

North

Aligarh

21-Feb-79

22750.00

3412.50

27

Rishi

Malik

Sales

South

Banglore

2-Jul-92

13125.00

1968.75

40

Richa

Raje

Sales

South

Manglore

29-Sep-91

10500.00

1575.00

57

Katti

Surti

Sales

South

chennai

9-May-93

14875.00

2231.25

93

Harsha

Trivedi

Sales

South

Banglore

6-Apr-89

17325.00

2598.75

24

Pooja

Nimkar

Sales

West

Nasik

21-May-80

14875.00

2231.25

56

Kajal

Joglekar

Sales

West

Nagpur

1-Oct-92

14875.00

2231.25

78

Deep

Chhaya

Sales

West

Mumbai

28-Oct-88

17500.00

2625.00

101

Vinod

M

Admin

West

Mumbai

28-Oct-88

50000.00

7500.00

Pragati Software Pvt. Ltd. Confidential

Page 18

Salary

Deutsche Bank

Column A

4 Row 1 Dept

Column A

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

Dates

B

C

D

E

F

G

H

I

First Name

Last Name

Dept

Region Branch

Hiredate

17

Aalok

Trivedi

Admin

East

Calcutta

1-Mar-83

15750.00

2362.50 #NAME?

41

Kirtikar

Sardesai

Admin

East

Darjeeling

14-Jun-97

7875.00

1181.25 #NAME?

75

Suraj

Saksena

Admin

East

Calcutta

25-Oct-88

17500.00

2625.00 #NAME?

12

Shilpa

Lele

Admin

North

Jammu

1-Mar-83

21000.00

3150.00 #NAME?

29

Hajra

Hoonjan

Admin

North

Jaipur

4-May-96

9625.00

1443.75 #NAME?

47

Vicky

Joshi

Admin

North

Kanpur

7-Feb-88

32000.00

4800.00 #NAME?

61

Anuradha

Zha

Admin

North

Agra

25-Nov-87

19250.00

2887.50 #NAME?

3

Kuldeep

Sharma

Admin

South

Hydrabad

1-Mar-99

7000.00

1050.00 #NAME?

59

Disha

Parmar

Admin

South

Banglore

14-Jan-87

19250.00

2887.50 #NAME?

18

Aakash

Dixit

Admin

West

Nasik

1-Mar-83

23000.00

3450.00 #NAME?

54

Vishal

Virsinghani

CCD

East

Gangtok

3-Mar-95

15750.00

2362.50 #NAME?

55

Lalita

Rao

CCD

East

Guwahati

1-Nov-86

15750.00

2362.50 #NAME?

65

Timsi

Desai

CCD

East

Calcutta

26-Oct-88

17500.00

2625.00 #NAME?

33

Tapan

Ghoshal

CCD

North

Ambala

7-Jul-97

7000.00

1050.00 #NAME?

34

Zarina

Vora

CCD

North

Lucknow

29-Sep-91

8750.00

1312.50 #NAME?

52

Heena

Godbole

CCD

North

Lucknow

21-Oct-88

19250.00

2887.50 #NAME?

73

Laveena

Shenoy

CCD

North

Jaipur

23-Oct-88

17500.00

2625.00 #NAME?

83

Kunal

Shah

CCD

North

Aligarh

2-Mar-99

7000.00

1050.00 #NAME?

86

Sonia

Sasan

CCD

North

Jammu

15-Jan-98

17500.00

2625.00 #NAME?

98

Chetan

Dalvi

CCD

North

Delhi

11-Apr-89

17325.00

2598.75 #NAME?

32

Ankur

Joshi

CCD

South

Manglore

1-Oct-82

15750.00

2362.50 #NAME?

49

Rakesh

Kumar

CCD

South

cochin

19-Oct-88

15750.00

2362.50 #NAME?

81

Tara

Phule

CCD

South

chennai

31-Oct-88

17500.00

2625.00 #NAME?

48

Neha

Joshi

CCD

West

Baroda

19-Oct-88

15750.00

2362.50 #NAME?

53

Mehul

Sheth

CCD

West

Nagpur

1-Dec-95

15750.00

2362.50 #NAME?

76

Nayeem

Khan

CCD

West

Panji

26-Oct-88

17500.00

2625.00 #NAME?

13

Meera

Lalwani

Finance

East

Calcutta

11-Dec-84

19250.00

2887.50 #NAME?

38

Chitra

Pednekar

Finance

North

Aligarh

1-Oct-82

24500.00

3675.00 #NAME?

39

Sheetal

Dodhia

Finance

North

delhi

1-Oct-82

24500.00

3675.00 #NAME?

14

Sheetal

Desai

Finance

South

cochin

12-Dec-84

30000.00

4500.00 #NAME?

37

Shilpa

Parikh

Finance

South

Mysore

1-Oct-82

24500.00

3675.00 #NAME?

100

Rupesh

Sawant

Finance

South

Hydrabad

2-Feb-99

7875.00

1181.25 #NAME?

11

Sujay

Madhrani

Finance

West

Pune

21-Dec-85

14875.00

2231.25 #NAME?

99

Indu

Shah

Finance

West

Mumbai

30-Dec-97

10500.00

1575.00 #NAME?

10

Andre

Fernendes

Mktg

East

Darjeeling

20-Jul-77

15750.00

2362.50 #NAME?

Pragati Software Pvt. Ltd. Confidential

Salary

J

Empcode

DA

Years

Page 21

A 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

Dates

B

C

D

E

F

G

H

I

J

21

Satinder Kaur

Sasan

Mktg

East

Patna

6-Jun-99

7875.00

1181.25 #NAME?

70

Reeta

Naik

Mktg

East

Calcutta

4-Mar-95

14000.00

2100.00 #NAME?

92

Payal

Singhani

Mktg

East

Gangtok

5-Apr-89

17325.00

2598.75 #NAME?

4

Beena

Mavadia

Mktg

North

Delhi

24-Nov-79

12250.00

1837.50 #NAME?

19

Parvati

Khanna

Mktg

North

Mathura

13-Aug-86

10500.00

1575.00 #NAME?

20

Farhan

Sadiq

Mktg

North

Jaipur

5-Jun-99

5950.00

892.50 #NAME?

58

Maya

Panchal

Mktg

North

Agra

5-Nov-90

17500.00

2625.00 #NAME?

79

Sagar

Bidkar

Mktg

North

Delhi

29-Oct-88

17500.00

2625.00 #NAME?

80

Dayanand

Gandhi

Mktg

North

Ferozepur

30-Oct-88

17500.00

2625.00 #NAME?

35

Arun

Joshi

Mktg

South

Manglore

5-May-92

9275.00

1391.25 #NAME?

60

Geeta

Darekar

Mktg

South

Trivanadrum

24-Nov-87

19250.00

2887.50 #NAME?

87

Jignesh

Tripathi

Mktg

South

Hydrabad

16-Jan-98

17500.00

2625.00 #NAME?

95

Kabir

Vora

Mktg

South

Banglore

8-Apr-89

17325.00

2598.75 #NAME?

22

Suchita

Panchal

Mktg

West

Nasik

7-Jun-99

7875.00

1181.25 #NAME?

23

Shazia

Sheikh

Mktg

West

Pune

8-Jun-99

7875.00

1181.25 #NAME?

88

Vinit

Shrivastava

Mktg

West

Pune

30-Dec-97

7875.00

1181.25 #NAME?

94

Radhika

Kulkarni

Mktg

West

Surat

7-Apr-89

17325.00

2598.75 #NAME?

30

Aalam

Qureshi

Personnel

East

Patna

19-Oct-88

14175.00

2126.25 #NAME?

44

Shaheen

Khan

Personnel

East

Cuttack

17-Nov-90

13825.00

2073.75 #NAME?

15

K. Sita

Narayanan

Personnel

North

Jammu

13-Dec-84

14875.00

2231.25 #NAME?

16

Priya

Shirodkar

Personnel

North

Jaipur

14-Dec-84

14875.00

2231.25 #NAME?

66

Parul

Shah

Personnel

North

Agra

27-Oct-88

17500.00

2625.00 #NAME?

67

Uday

Naik

Personnel

North

Lucknow

28-Oct-88

20125.00

3018.75 #NAME?

69

Pravin

Joshi

Personnel

North

delhi

3-Mar-95

14000.00

2100.00 #NAME?

64

Veena

Patil

Personnel

South

Hydrabad

25-Oct-88

17500.00

2625.00 #NAME?

7

Deepak

Jain

Personnel

West

Pune

17-Aug-90

13825.00

2073.75 #NAME?

36

Pooja

Khetan

Personnel

West

Surat

3-Sep-94

11725.00

1758.75 #NAME?

43

Piyush

Surti

Personnel

West

Mumbai

19-Oct-88

15750.00

2362.50 #NAME?

50

Ruheal

Baig

Personnel

West

Baroda

19-Oct-88

15750.00

2362.50 #NAME?

42

Pooja

Gokhale

R&D

East

Calcutta

29-Sep-91

13300.00

1995.00 #NAME?

82

Kalpana

Shirishkar

R&D

East

Cuttack

1-Nov-88

17500.00

2625.00 #NAME?

84

Pinky

Robert

R&D

East

Calcutta

3-Mar-99

7000.00

1050.00 #NAME?

5

Seema

Ranganathan

R&D

North

Kanpur

4-Sep-89

21000.00

3150.00 #NAME?

6

Julie

D'Souza

R&D

North

Mathura

4-Sep-88

12425.00

1863.75 #NAME?

8

Neena

Mukherjee

R&D

North

Agra

4-Sep-89

12425.00

1863.75 #NAME?

31

Giriraj

Gupta

R&D

North

Agra

1-Oct-82

15750.00

2362.50 #NAME?

Pragati Software Pvt. Ltd. Confidential

Page 22

A 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 101 102

Dates

B

C

D

E

F

G

H

I

J

45

Kinnari

Mehta

R&D

North

Ferozepur

7-Jul-97

11375.00

1706.25 #NAME?

63

Waheda

Sheikh

R&D

North

Jammu

24-Oct-88

17500.00

2625.00 #NAME?

77

Drishti

Shah

R&D

North

Delhi

27-Oct-88

17500.00

2625.00 #NAME?

85

Ruby

Joseph

R&D

North

Agra

14-Jan-98

7000.00

1050.00 #NAME?

90

Priyanka

Mehta

R&D

North

Jaipur

6-Jan-80

22750.00

3412.50 #NAME?

25

Jasbinder

Khurana

R&D

South

Manglore

24-Apr-99

7875.00

1181.25 #NAME?

72

Yamini

Gupta

R&D

South

Mysore

22-Oct-88

17500.00

2625.00 #NAME?

97

Pushpa

Raut

R&D

South

Trivanadrum

10-Apr-89

17325.00

2598.75 #NAME?

28

Mala

Bhaduri

R&D

West

Mumbai

19-Mar-95

10500.00

1575.00 #NAME?

71

Surendra

Godse

R&D

West

Panji

5-Mar-95

14000.00

2100.00 #NAME?

96

Beena

Sharma

R&D

West

Nagpur

9-Apr-89

17325.00

2598.75 #NAME?

2

Suman

Shinde

Sales

East

Cuttack

1-Jan-77

17500.00

2625.00 #NAME?

26

Bharat

Shetty

Sales

East

Cuttack

1-Oct-82

19250.00

2887.50 #NAME?

74

Nita

Pandhya

Sales

East

Darjeeling

24-Oct-88

17500.00

2625.00 #NAME?

91

Niki

Digaria

Sales

East

Calcutta

13-Nov-79

22750.00

3412.50 #NAME?

1

Raja

Raymondekar

Sales

North

Ferozepur

1-Jan-77

24000.00

3600.00 #NAME?

9

Pankaj

Sutradhar

Sales

North

Ambala

12-Dec-99

14875.00

2231.25 #NAME?

46

Jeena

Baig

Sales

North

Lucknow

29-Sep-91

15750.00

2362.50 #NAME?

51

Mario

Fernandes

Sales

North

Jammu

20-Oct-88

15750.00

2362.50 #NAME?

62

Asha

Trivedi

Sales

North

Kanpur

26-Nov-87

19250.00

2887.50 #NAME?

68

Mandakini

Desai

Sales

North

delhi

1-Dec-95

14000.00

2100.00 #NAME?

89

Tejal

Patel

Sales

North

Aligarh

21-Feb-79

22750.00

3412.50 #NAME?

27

Rishi

Malik

Sales

South

Banglore

2-Jul-92

13125.00

1968.75 #NAME?

40

Richa

Raje

Sales

South

Manglore

29-Sep-91

10500.00

1575.00 #NAME?

57

Katti

Surti

Sales

South

chennai

9-May-93

14875.00

2231.25 #NAME?

93

Harsha

Trivedi

Sales

South

Banglore

6-Apr-89

17325.00

2598.75 #NAME?

24

Pooja

Nimkar

Sales

West

Nasik

21-May-80

14875.00

2231.25 #NAME?

56

Kajal

Joglekar

Sales

West

Nagpur

1-Oct-92

14875.00

2231.25 #NAME?

78

Deep

Chhaya

Sales

West

Mumbai

28-Oct-88

17500.00

2625.00 #NAME?

101

Vinod

M

Admin

West

Mumbai

28-Oct-89

50000.00

7500.00 #NAME?

Pragati Software Pvt. Ltd. Confidential

Page 23

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

Dates

K L M Months Days Total Experience #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME?

Pragati Software Pvt. Ltd. Confidential

Page 24

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

Dates

K L #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME?

M

Pragati Software Pvt. Ltd. Confidential

Page 25

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 101 102

Dates

K L #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME? #NAME?#NAME? #NAME?

M

Pragati Software Pvt. Ltd. Confidential

Page 26

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

B

C

D

E

F

G

H

J

K

First Name

Last Name

Dept

Region Branch

Hiredate

17

Aalok

Trivedi

Admin

east

Calcutta

1-Mar-83

15750

Calcutta

127050

75

Suraj

Saksena

Admin

east

Calcutta

25-Oct-88

17500

Darjeeling

41125

41

Kirtikar

Sardesai

Admin

east

Darjeeling

14-Jun-97

7875

Gangtok

33075

65

Timsi

Desai

CCD

east

Calcutta

26-Oct-88

17500

Guwahati

15750

54

Vishal

Virsinghani

CCD

east

Gangtok

3-Mar-95

15750

Patna

22050

55

Lalita

Rao

CCD

east

Guwahati

1-Nov-86

15750

Cuttack

68075

13

Meera

Lalwani

Finance

east

Calcutta

11-Dec-84

19250

Agra

89425

70

Reeta

Naik

Mktg

east

Calcutta

4-Mar-95

14000

Jaipur

70700

10

Andre

Fernendes

Mktg

east

Darjeeling

20-Jul-77

15750

Jammu

86625

92

Payal

Singhani

Mktg

east

Gangtok

5-Apr-89

17325

Kanpur

56000

21

Satinder Kaur

Sasan

Mktg

east

Patna

6-Jun-99

7875

Aligarh

54250

44

Shaheen

Khan

Personnel

east

Cuttack

17-Nov-90

13825

Ambala

21875

30

Aalam

Qureshi

Personnel

east

Patna

19-Oct-88

14175

Delhi

117075

42

Pooja

Gokhale

R&D

east

Calcutta

29-Sep-91

13300

Lucknow

63875

84

Pinky

Robert

R&D

east

Calcutta

3-Mar-99

7000

Ferozepur

52875

82

Kalpana

Shirishkar

R&D

east

Cuttack

1-Nov-88

17500

Mathura

22925

91

Niki

Digaria

Sales

east

Calcutta

13-Nov-79

22750

Banglore

67025

2

Suman

Shinde

Sales

east

Cuttack

1-Jan-77

17500

Hydrabad

61875

26

Bharat

Shetty

Sales

east

Cuttack

1-Oct-82

19250

chennai

32375

74

Nita

Pandhya

Sales

east

Darjeeling

24-Oct-88

17500

cochin

45750

61

Anuradha

Zha

Admin

north

Agra

25-Nov-87

19250

Manglore

43400

29

Hajra

Hoonjan

Admin

north

Jaipur

4-May-96

9625

Mysore

42000

12

Shilpa

Lele

Admin

north

Jammu

1-Mar-83

21000

Trivanadrum

36575

47

Vicky

Joshi

Admin

north

Kanpur

7-Feb-88

15750

Nasik

38500

83

Kunal

Shah

CCD

north

Aligarh

2-Mar-99

7000

Baroda

31500

33

Tapan

Ghoshal

CCD

north

Ambala

7-Jul-97

7000

Nagpur

47950

98

Chetan

Dalvi

CCD

north

Delhi

11-Apr-89

17325

Panji

31500

73

Laveena

Shenoy

CCD

north

Jaipur

23-Oct-88

17500

Mumbai

54250

86

Sonia

Sasan

CCD

north

Jammu

15-Jan-98

17500

Pune

44450

34

Zarina

Vora

CCD

north

Lucknow

29-Sep-91

8750

Surat

29050

52

Heena

Godbole

CCD

north

Lucknow

21-Oct-88

19250

38

Chitra

Pednekar

Finance

north

Aligarh

1-Oct-82

24500

39

Sheetal

Dodhia

Finance

north

delhi

1-Oct-82

24500

58

Maya

Panchal

Mktg

north

Agra

5-Nov-90

17500

4

Beena

Mavadia

Mktg

north

Delhi

24-Nov-79

12250

Conditional Format

Pragati Software Pvt. Ltd. Confidential

Salary

I

Empcode

Branch

1548950

Page 27

A 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

B

C

D

E

F

G

H

79

Sagar

Bidkar

Mktg

north

Delhi

29-Oct-88

17500

80

Dayanand

Gandhi

Mktg

north

Ferozepur

30-Oct-88

17500

20

Farhan

Sadiq

Mktg

north

Jaipur

5-Jun-99

19

Parvati

Khanna

Mktg

north

Mathura

13-Aug-86

10500

66

Parul

Shah

Personnel

north

Agra

27-Oct-88

17500

69

Pravin

Joshi

Personnel

north

delhi

3-Mar-95

14000

16

Priya

Shirodkar

Personnel

north

Jaipur

14-Dec-84

14875

15

K. Sita

Narayanan

Personnel

north

Jammu

13-Dec-84

14875

67

Uday

Naik

Personnel

north

Lucknow

28-Oct-88

20125

8

Neena

Mukherjee

R&D

north

Agra

4-Sep-89

12425

31

Giriraj

Gupta

R&D

north

Agra

1-Oct-82

15750

85

Ruby

Joseph

R&D

north

Agra

14-Jan-98

7000

77

Drishti

Shah

R&D

north

Delhi

27-Oct-88

17500

45

Kinnari

Mehta

R&D

north

Ferozepur

7-Jul-97

11375

90

Priyanka

Mehta

R&D

north

Jaipur

6-Jan-80

22750

63

Waheda

Sheikh

R&D

north

Jammu

24-Oct-88

17500

5

Seema

Ranganathan

R&D

north

Kanpur

4-Sep-89

21000

6

Julie

D'Souza

R&D

north

Mathura

4-Sep-88

12425

89

Tejal

Patel

Sales

north

Aligarh

21-Feb-79

22750

9

Pankaj

Sutradhar

Sales

north

Ambala

12-Dec-99

14875

68

Mandakini

Desai

Sales

north

delhi

1-Dec-95

14000

1

Raja

Raymondekar

Sales

north

Ferozepur

1-Jan-77

24000

51

Mario

Fernandes

Sales

north

Jammu

20-Oct-88

15750

62

Asha

Trivedi

Sales

north

Kanpur

26-Nov-87

19250

46

Jeena

Baig

Sales

north

Lucknow

29-Sep-91

15750

59

Disha

Parmar

Admin

south

Banglore

14-Jan-87

19250

3

Kuldeep

Sharma

Admin

south

Hydrabad

1-Mar-99

19000

81

Tara

Phule

CCD

south

chennai

31-Oct-88

17500

49

Rakesh

Kumar

CCD

south

cochin

19-Oct-88

15750

32

Ankur

Joshi

CCD

south

Manglore

1-Oct-82

15750

14

Sheetal

Desai

Finance

south

cochin

12-Dec-84

30000

100

Rupesh

Sawant

Finance

south

Hydrabad

2-Feb-99

7875

37

Shilpa

Parikh

Finance

south

Mysore

1-Oct-82

24500

95

Kabir

Vora

Mktg

south

Banglore

8-Apr-89

17325

87

Jignesh

Tripathi

Mktg

south

Hydrabad

16-Jan-98

17500

35

Arun

Joshi

Mktg

south

Manglore

5-May-92

9275

Conditional Format

Pragati Software Pvt. Ltd. Confidential

I

J

K

5950

Page 28

A 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 101

B

C

D

E

F

G

H

60

Geeta

Darekar

Mktg

south

Trivanadrum

24-Nov-87

19250

64

Veena

Patil

Personnel

south

Hydrabad

25-Oct-88

17500

25

Jasbinder

Khurana

R&D

south

Manglore

24-Apr-99

7875

72

Yamini

Gupta

R&D

south

Mysore

22-Oct-88

17500

97

Pushpa

Raut

R&D

south

Trivanadrum

10-Apr-89

17325

27

Rishi

Malik

Sales

south

Banglore

2-Jul-92

13125

93

Harsha

Trivedi

Sales

south

Banglore

6-Apr-89

17325

57

Katti

Surti

Sales

south

chennai

9-May-93

14875

40

Richa

Raje

Sales

south

Manglore

29-Sep-91

10500

18

Aakash

Dixit

Admin

west

Nasik

1-Mar-83

15750

48

Neha

Joshi

CCD

west

Baroda

19-Oct-88

15750

53

Mehul

Sheth

CCD

west

Nagpur

1-Dec-95

15750

76

Nayeem

Khan

CCD

west

Panji

26-Oct-88

17500

99

Indu

Shah

Finance

west

Mumbai

30-Dec-97

10500

11

Sujay

Madhrani

Finance

west

Pune

21-Dec-85

14875

22

Suchita

Panchal

Mktg

west

Nasik

7-Jun-99

7875

23

Shazia

Sheikh

Mktg

west

Pune

8-Jun-99

7875

88

Vinit

Shrivastava

Mktg

west

Pune

30-Dec-97

94

Radhika

Kulkarni

Mktg

west

Surat

7-Apr-89

17325

50

Ruheal

Baig

Personnel

west

Baroda

19-Oct-88

15750

43

Piyush

Surti

Personnel

west

Mumbai

19-Oct-88

15750

7

Deepak

Jain

Personnel

west

Pune

17-Aug-90

13825

36

Pooja

Khetan

Personnel

west

Surat

3-Sep-94

11725

28

Mala

Bhaduri

R&D

west

Mumbai

19-Mar-95

10500

96

Beena

Sharma

R&D

west

Nagpur

9-Apr-89

17325

71

Surendra

Godse

R&D

west

Panji

5-Mar-95

14000

78

Deep

Chhaya

Sales

west

Mumbai

28-Oct-88

17500

56

Kajal

Joglekar

Sales

west

Nagpur

1-Oct-92

14875

24

Pooja

Nimkar

Sales

west

Nasik

21-May-80

14875

Conditional Format

Pragati Software Pvt. Ltd. Confidential

I

J

K

7875

Page 29

Count of Emp Sum Of Salary Avg Salary 101 1610450 15945.05

Max Salary Min Salary 50000 5950

Empcode

First Name

Last Name

Dept

Region

Branch

Hiredate

17

Aalok

Trivedi

Admin

East

Calcutta

1-Mar-83

75

Suraj

Saksena

Admin

East

Calcutta

25-Oct-88

41

Kirtikar

Sardesai

Admin

East

Darjeeling

14-Jun-97

61

Anuradha

Zha

Admin

North

Agra

25-Nov-87

29

Hajra

Hoonjan

Admin

North

Jaipur

4-May-96

12

Shilpa

Lele

Admin

North

Jammu

1-Mar-83

47

Vicky

Joshi

Admin

North

Kanpur

7-Feb-88

59

Disha

Parmar

Admin

South

Banglore

14-Jan-87

3

Kuldeep

Sharma

Admin

South

Hydrabad

1-Mar-99

101

Vinod

M

Admin

West

Mumbai

28-Oct-89

18

Aakash

Dixit

Admin

West

Nasik

1-Mar-83

65

Timsi

Desai

CCD

East

Calcutta

26-Oct-88

54

Vishal

Virsinghani

CCD

East

Gangtok

3-Mar-95

55

Lalita

Rao

CCD

East

Guwahati

1-Nov-86

83

Kunal

Shah

CCD

North

Aligarh

2-Mar-99

33

Tapan

Ghoshal

CCD

North

Ambala

7-Jul-97

98

Chetan

Dalvi

CCD

North

Delhi

11-Apr-89

73

Laveena

Shenoy

CCD

North

Jaipur

23-Oct-88

86

Sonia

Sasan

CCD

North

Jammu

15-Jan-98

34

Zarina

Vora

CCD

North

Lucknow

29-Sep-91

52

Heena

Godbole

CCD

North

Lucknow

21-Oct-88

81

Tara

Phule

CCD

South

chennai

31-Oct-88

49

Rakesh

Kumar

CCD

South

cochin

19-Oct-88

32

Ankur

Joshi

CCD

South

Manglore

1-Oct-82

48

Neha

Joshi

CCD

West

Baroda

19-Oct-88

53

Mehul

Sheth

CCD

West

Nagpur

1-Dec-95

76

Nayeem

Khan

CCD

West

Panji

26-Oct-88

13

Meera

Lalwani

Finance

East

Calcutta

11-Dec-84

38

Chitra

Pednekar

Finance

North

Aligarh

1-Oct-82

39

Sheetal

Dodhia

Finance

North

delhi

1-Oct-82

14

Sheetal

Desai

Finance

South

cochin

12-Dec-84

100

Rupesh

Sawant

Finance

South

Hydrabad

2-Feb-99

37

Shilpa

Parikh

Finance

South

Mysore

1-Oct-82

99

Indu

Shah

Finance

West

Mumbai

30-Dec-97

11

Sujay

Madhrani

Finance

West

Pune

21-Dec-85

70

Reeta

Naik

Mktg

East

Calcutta

4-Mar-95

10

Andre

Fernendes

Mktg

East

Darjeeling

20-Jul-77

92

Payal

Singhani

Mktg

East

Gangtok

5-Apr-89

21

Satinder Kaur

Sasan

Mktg

East

Patna

6-Jun-99

58

Maya

Panchal

Mktg

North

Agra

5-Nov-90

4

Beena

Mavadia

Mktg

North

Delhi

24-Nov-79

79

Sagar

Bidkar

Mktg

North

Delhi

29-Oct-88

80

Dayanand

Gandhi

Mktg

North

Ferozepur

30-Oct-88

20

Farhan

Sadiq

Mktg

North

Jaipur

5-Jun-99

19

Parvati

Khanna

Mktg

North

Mathura

13-Aug-86

95

Kabir

Vora

Mktg

South

Banglore

8-Apr-89

87

Jignesh

Tripathi

Mktg

South

Hydrabad

16-Jan-98

35

Arun

Joshi

Mktg

South

Manglore

5-May-92

60

Geeta

Darekar

Mktg

South

Trivanadrum

24-Nov-87

22

Suchita

Panchal

Mktg

West

Nasik

7-Jun-99

23

Shazia

Sheikh

Mktg

West

Pune

8-Jun-99

88

Vinit

Shrivastava

Mktg

West

Pune

30-Dec-97

94

Radhika

Kulkarni

Mktg

West

Surat

7-Apr-89

44

Shaheen

Khan

Personnel

East

Cuttack

17-Nov-90

30

Aalam

Qureshi

Personnel

East

Patna

19-Oct-88

66

Parul

Shah

Personnel

North

Agra

27-Oct-88

69

Pravin

Joshi

Personnel

North

delhi

3-Mar-95

16

Priya

Shirodkar

Personnel

North

Jaipur

14-Dec-84

15

K. Sita

Narayanan

Personnel

North

Jammu

13-Dec-84

67

Uday

Naik

Personnel

North

Lucknow

28-Oct-88

64

Veena

Patil

Personnel

South

Hydrabad

25-Oct-88

50

Ruheal

Baig

Personnel

West

Baroda

19-Oct-88

43

Piyush

Surti

Personnel

West

Mumbai

19-Oct-88

7

Deepak

Jain

Personnel

West

Pune

17-Aug-90

36

Pooja

Khetan

Personnel

West

Surat

3-Sep-94

42

Pooja

Gokhale

R&D

East

Calcutta

29-Sep-91

84

Pinky

Robert

R&D

East

Calcutta

3-Mar-99

82

Kalpana

Shirishkar

R&D

East

Cuttack

1-Nov-88

8

Neena

Mukherjee

R&D

North

Agra

4-Sep-89

31

Giriraj

Gupta

R&D

North

Agra

1-Oct-82

85

Ruby

Joseph

R&D

North

Agra

14-Jan-98

77

Drishti

Shah

R&D

North

Delhi

27-Oct-88

45

Kinnari

Mehta

R&D

North

Ferozepur

7-Jul-97

90

Priyanka

Mehta

R&D

North

Jaipur

6-Jan-80

63

Waheda

Sheikh

R&D

North

Jammu

24-Oct-88

5

Seema

Ranganathan

R&D

North

Kanpur

4-Sep-89

6

Julie

D'Souza

R&D

North

Mathura

4-Sep-88

25

Jasbinder

Khurana

R&D

South

Manglore

24-Apr-99

72

Yamini

Gupta

R&D

South

Mysore

22-Oct-88

97

Pushpa

Raut

R&D

South

Trivanadrum

10-Apr-89

28

Mala

Bhaduri

R&D

West

Mumbai

19-Mar-95

96

Beena

Sharma

R&D

West

Nagpur

9-Apr-89

71

Surendra

Godse

R&D

West

Panji

5-Mar-95

91

Niki

Digaria

Sales

East

Calcutta

13-Nov-79

2

Suman

Shinde

Sales

East

Cuttack

1-Jan-77

26

Bharat

Shetty

Sales

East

Cuttack

1-Oct-82

74

Nita

Pandhya

Sales

East

Darjeeling

24-Oct-88

89

Tejal

Patel

Sales

North

Aligarh

21-Feb-79

9

Pankaj

Sutradhar

Sales

North

Ambala

12-Dec-99

68

Mandakini

Desai

Sales

North

delhi

1-Dec-95

1

Raja

Raymondekar

Sales

North

Ferozepur

1-Jan-77

51

Mario

Fernandes

Sales

North

Jammu

20-Oct-88

62

Asha

Trivedi

Sales

North

Kanpur

26-Nov-87

46

Jeena

Baig

Sales

North

Lucknow

29-Sep-91

27

Rishi

Malik

Sales

South

Banglore

2-Jul-92

93

Harsha

Trivedi

Sales

South

Banglore

6-Apr-89

57

Katti

Surti

Sales

South

chennai

9-May-93

40

Richa

Raje

Sales

South

Manglore

29-Sep-91

78

Deep

Chhaya

Sales

West

Mumbai

28-Oct-88

56

Kajal

Joglekar

Sales

West

Nagpur

1-Oct-92

24

Pooja

Nimkar

Sales

West

Nasik

21-May-80

Salary

Dept

15750.00

Admin

17500.00

CCD

7875.00

Finance

19250.00

Mktg

9625.00

Personnel

21000.00

R&D

32000.00

Sales

19250.00 7000.00 50000.00 23000.00 17500.00 15750.00 15750.00 7000.00 7000.00 17325.00 17500.00 17500.00 8750.00 19250.00 17500.00 15750.00 15750.00 15750.00 15750.00 17500.00 19250.00 24500.00 24500.00 30000.00 7875.00 24500.00 10500.00 14875.00 14000.00 15750.00 17325.00 7875.00 17500.00

Count of EMP 11 16 8 18 12 18 18

Sum of Salary 222250 241325 156000 240450 183925 260050 306450

12250.00 17500.00 17500.00 5950.00 10500.00 17325.00 17500.00 9275.00 19250.00 7875.00 7875.00 7875.00 17325.00 13825.00 14175.00 17500.00 14000.00 14875.00 14875.00 20125.00 17500.00 15750.00 15750.00 13825.00 11725.00 13300.00 7000.00 17500.00 12425.00 15750.00 7000.00 17500.00 11375.00 22750.00 17500.00 21000.00 12425.00 7875.00 17500.00 17325.00 10500.00 17325.00 14000.00 22750.00 17500.00 19250.00

17500.00 22750.00 14875.00 14000.00 24000.00 15750.00 19250.00 15750.00 13125.00 17325.00 14875.00 10500.00 17500.00 14875.00 14875.00

The SLOW brown elephant The quick brown Tiger The quick brown fox

jumps over the lazy dog. The quick brown fox jumps over the jumps over the lazy dog. The quick brown fox jumps over the jumps over the lazy dog. The quick brown fox jumps over the

lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the

lazy dog. The quick brown fox jumps over the lazy dog. lazy dog. The quick brown fox jumps over the lazy dog. lazy dog. The quick brown fox jumps over the lazy dog.

xl shortcut keys useful tips

Salary 2000 15750 4000 21000 19250 15750 9625 19250 19000 15750 17500 15750 15750 19250 17500 17500 17325 8750 7000 7000 17500 15750 15750 17500 15750 15750 19250 24500 24500 30000 24500 7875 14875 10500 17325 15750 14000 7875 17500 17500 17500 12250 10500 5950 19250 17500 17325 9275 17325 7875 7875

7875 14175 13825 20125 17500 14875 14875 14000 17500 15750 15750 13825 11725 17500 13300 7000 22750 21000 17500 17500 15750 12425 12425 11375 7000 17500 17325 7875 17325 14000 10500 22750 19250 17500 17500 24000 22750 19250 15750 15750 14875 14000 17325 14875 13125 10500 17500 14875 14875

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

Empcode

B First Name

C Last Name

D

E

F

Dept

Region Branch

finance

north

G

H

Hiredate

Salary

Salary

Jammu

admin sales

west

Empcode

First Name

Last Name

Dept

Region Branch

Hiredate

75

suraj

Saksena

admin

east

Calcutta

25-Oct-88

17

aalok

Trivedi

admin

east

Calcutta

1-Mar-83

41

kirtikar

Sardesai

admin

east

Darjeeling

14-Jun-97

12

shilpa

Lele

admin

north

Jammu

1-Mar-83

21000

61

anuradha

Zha

admin

north

Agra

25-Nov-87

19250

47

vicky

Joshi

admin

north

Kanpur

7-Feb-88

15750

29

hajra

Hoonjan

admin

north

Jaipur

4-May-96

9625

59

disha

Parmar

admin

south

Banglore

14-Jan-87

19250

3

kuldeep

Sharma

admin

south

Hydrabad

1-Mar-99

19000

18

aakash

Dixit

admin

west

Nasik

1-Mar-83

15750

65

timsi

Desai

ccd

east

Calcutta

26-Oct-88

17500

54

vishal

Virsinghani

ccd

east

Gangtok

3-Mar-95

15750

55

lalita

Rao

ccd

east

Guwahati

1-Nov-86

15750

52

heena

Godbole

ccd

north

Lucknow

21-Oct-88

19250

73

laveena

Shenoy

ccd

north

Jaipur

23-Oct-88

17500

86

sonia

Sasan

ccd

north

Jammu

15-Jan-98

17500

98

chetan

Dalvi

ccd

north

Delhi

11-Apr-89

17325

34

zarina

Vora

ccd

north

Lucknow

29-Sep-91

8750

33

tapan

Ghoshal

ccd

north

Ambala

7-Jul-97

7000

83

kunal

Shah

ccd

north

Aligarh

2-Mar-99

81

tara

Phule

ccd

south

Chennai

31-Oct-88

17500

32

ankur

Joshi

ccd

south

Manglore

1-Oct-82

15750

49

rakesh

Kumar

ccd

south

Cochin

19-Oct-88

15750

76

nayeem

Khan

ccd

west

Panji

26-Oct-88

17500

48

neha

Joshi

ccd

west

Baroda

19-Oct-88

15750

53

mehul

Sheth

ccd

west

Nagpur

1-Dec-95

15750

Macros

Pragati Software Pvt. Ltd. Confidential

2000 15750 4000

7000

Page 42

A 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

B

C

D

E

F

G

H

13

meera

Lalwani

finance

east

Calcutta

11-Dec-84

19250

38

chitra

Pednekar

finance

north

Aligarh

1-Oct-82

24500

39

sheetal

Dodhia

finance

north

Delhi

1-Oct-82

24500

14

sheetal

Desai

finance

south

Cochin

12-Dec-84

30000

37

shilpa

Parikh

finance

south

Mysore

1-Oct-82

24500

100

rupesh

Sawant

finance

south

Hydrabad

2-Feb-99

11

sujay

Madhrani

finance

west

Pune

21-Dec-85

14875

99

indu

Shah

finance

west

Mumbai

30-Dec-97

10500

92

payal

Singhani

mktg

east

Gangtok

5-Apr-89

17325

10

andre

Fernendes

mktg

east

Darjeeling

20-Jul-77

15750

70

reeta

Naik

mktg

east

Calcutta

4-Mar-95

14000

21

satinder kaur

Sasan

mktg

east

Patna

6-Jun-99

7875

58

maya

Panchal

mktg

north

Agra

5-Nov-90

17500

79

sagar

Bidkar

mktg

north

Delhi

29-Oct-88

17500

80

dayanand

Gandhi

mktg

north

Ferozepur

30-Oct-88

17500

4

beena

Mavadia

mktg

north

Delhi

24-Nov-79

12250

19

parvati

Khanna

mktg

north

Mathura

13-Aug-86

10500

20

farhan

Sadiq

mktg

north

Jaipur

5-Jun-99

60

geeta

Darekar

mktg

south

Trivanadrum

24-Nov-87

19250

87

jignesh

Tripathi

mktg

south

Hydrabad

16-Jan-98

17500

95

kabir

Vora

mktg

south

Banglore

8-Apr-89

17325

35

arun

Joshi

mktg

south

Manglore

5-May-92

94

radhika

Kulkarni

mktg

west

Surat

7-Apr-89

17325

22

suchita

Panchal

mktg

west

Nasik

7-Jun-99

7875

23

shazia

Sheikh

mktg

west

Pune

8-Jun-99

7875

88

vinit

Shrivastava

mktg

west

Pune

30-Dec-97

7875

30

aalam

Qureshi

personnel

east

Patna

19-Oct-88

14175

44

shaheen

Khan

personnel

east

Cuttack

17-Nov-90

13825

67

uday

Naik

personnel

north

Lucknow

28-Oct-88

20125

66

parul

Shah

personnel

north

Agra

27-Oct-88

17500

15

k. sita

Narayanan

personnel

north

Jammu

13-Dec-84

14875

16

priya

Shirodkar

personnel

north

Jaipur

14-Dec-84

14875

69

pravin

Joshi

personnel

north

Delhi

3-Mar-95

14000

64

veena

Patil

personnel

south

Hydrabad

25-Oct-88

17500

43

piyush

Surti

personnel

west

Mumbai

19-Oct-88

15750

50

ruheal

Baig

personnel

west

Baroda

19-Oct-88

15750

Macros

Pragati Software Pvt. Ltd. Confidential

7875

5950

9275

Page 43

A 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 101 102 103 104 105 106 107 108

B

C

D

E

F

G

H

7

deepak

Jain

personnel

west

Pune

17-Aug-90

13825

36

pooja

Khetan

personnel

west

Surat

3-Sep-94

11725

82

kalpana

Shirishkar

r&d

east

Cuttack

1-Nov-88

17500

42

pooja

Gokhale

r&d

east

Calcutta

29-Sep-91

13300

84

pinky

Robert

r&d

east

Calcutta

3-Mar-99

7000

90

priyanka

Mehta

r&d

north

Jaipur

6-Jan-80

22750

5

seema

Ranganathan

r&d

north

Kanpur

4-Sep-89

21000

63

waheda

Sheikh

r&d

north

Jammu

24-Oct-88

17500

77

drishti

Shah

r&d

north

Delhi

27-Oct-88

17500

31

giriraj

Gupta

r&d

north

Agra

1-Oct-82

15750

6

julie

D'Souza

r&d

north

Mathura

4-Sep-88

12425

8

neena

Mukherjee

r&d

north

Agra

4-Sep-89

12425

45

kinnari

Mehta

r&d

north

Ferozepur

7-Jul-97

11375

85

ruby

Joseph

r&d

north

Agra

14-Jan-98

7000

72

yamini

Gupta

r&d

south

Mysore

22-Oct-88

17500

97

pushpa

Raut

r&d

south

Trivanadrum

10-Apr-89

17325

25

jasbinder

Khurana

r&d

south

Manglore

24-Apr-99

96

beena

Sharma

r&d

west

Nagpur

9-Apr-89

17325

71

surendra

Godse

r&d

west

Panji

5-Mar-95

14000

28

mala

Bhaduri

r&d

west

Mumbai

19-Mar-95

10500

91

niki

Digaria

sales

east

Calcutta

13-Nov-79

22750

26

bharat

Shetty

sales

east

Cuttack

1-Oct-82

19250

2

suman

Shinde

sales

east

Cuttack

1-Jan-77

17500

74

nita

Pandhya

sales

east

Darjeeling

24-Oct-88

17500

1

raja

Raymondekar

sales

north

Ferozepur

1-Jan-77

24000

89

tejal

Patel

sales

north

Aligarh

21-Feb-79

22750

62

asha

Trivedi

sales

north

Kanpur

26-Nov-87

19250

46

jeena

Baig

sales

north

Lucknow

29-Sep-91

15750

51

mario

Fernandes

sales

north

Jammu

20-Oct-88

15750

9

pankaj

Sutradhar

sales

north

Ambala

12-Dec-99

14875

68

mandakini

Desai

sales

north

Delhi

1-Dec-95

14000

93

harsha

Trivedi

sales

south

Banglore

6-Apr-89

17325

57

katti

Surti

sales

south

Chennai

9-May-93

14875

27

rishi

Malik

sales

south

Banglore

2-Jul-92

13125

40

richa

Raje

sales

south

Manglore

29-Sep-91

10500

78

deep

Chhaya

sales

west

Mumbai

28-Oct-88

17500

Macros

Pragati Software Pvt. Ltd. Confidential

7875

Page 44

A 109 24 110 56

Macros

B

C

D

E

F

G

H

pooja

Nimkar

sales

west

Nasik

21-May-80

14875

kajal

Joglekar

sales

west

Nagpur

1-Oct-92

14875

Pragati Software Pvt. Ltd. Confidential

Page 45

Related Documents

Nota Excel 2003 Advance
November 2019 12
Excel In Advance
June 2020 6
Corporate Advance
November 2019 14
Advance Search
November 2019 22