Scribd
Upload
29 views3 pages

Excel Tutorial

The document outlines various functions and operations related to spreadsheet management, including cell manipulation, data entry, and formula applications. It also lists employee information such as employee number, last name, first name, location, date of birth, pay grade, and department. The content is organized into sections detailing both spreadsheet functionalities and employee data.

Uploaded by

Sai parkavi Parthasarathy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
29 views3 pages

Excel Tutorial

The document outlines various functions and operations related to spreadsheet management, including cell manipulation, data entry, and formula applications. It also lists employee information such as employee number, last name, first name, location, date of birth, pay grade, and department. The content is organized into sections detailing both spreadsheet functionalities and employee data.

Uploaded by

Sai parkavi Parthasarathy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Part 1 Part 2 Part 3 Part 4

1 Cell 1 Zoom 1 Addition 1


2 Column 2 Changing row hight & width 2 Subtraction 2
3 Row 3 Merging two columns 3 Multiplication 3
4 Range 4 Entering the numbers 4 Division 4
5 Insert range 5 Entering dates 5
6 Delete 6 Adding new sheet
7 Copy 7 Dragging the sheets
8 Paste 8 Rename a sheet
9 Cut 9 Delete the sheet
10 Edit range 10 Hide/Unhide a sheet
11 Edit column 11 Change tab color
12 Insert column
Part 4 Part 5 Part 6 Part 6

Total 1 sum FILLING Formulas


Average 2 sumif 1 Months 1 Mid
Count 3 sumifs 2 Weeks 2 Left
Countblank 3 Dates 3 Right
CountA 4 Numbers 4 Upper
5 Lower
6 Proper
7 Trim
Empl No Last Name First Name Location D/O Pay Grade Department
19 Malton John Ramapuram 7/22/1971 1 Administration
30 Philips Kahn Manapakkam 7/22/1972 2 Distribution
41 Sai Parkavi Porur 7/22/1973 3 Selling
45 Keerthi Aana Avadi 7/22/1974 4 Administration
52 Partha Sarathy Ramapuram 7/22/1975 5 Distribution
56 Kavitha Partha Manapakkam 7/22/1976 6 Selling
63 Menaka Raj Porur 7/22/1977 7 Administration
65 Brindha Raj Avadi 7/22/1978 8 Distribution
69 Prathiba Baktha Ramapuram 7/22/1979 9 Selling
72 James Vasanth Manapakkam 7/22/1980 10 Administration
76 Baktha Vachalam Porur 7/22/1981 11 Distribution
77 Raj Babu Avadi 7/22/1982 12 Selling
81 Sandhiya Thangasami Ramapuram 7/22/1983 13 Administration

You might also like