[go: up one dir, main page]
Scribd
Upload
13 views2 pages

Lecture # 2 Excel

Lecture # 2 Excel

Uploaded by

abdulrauftub1991
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
13 views2 pages

Lecture # 2 Excel

Lecture # 2 Excel

Uploaded by

abdulrauftub1991
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
You are on page 1/ 2

Content

1 Locking
2 Subtotals
3 Comments
4 Help
5 Filter
6 Sort
7 Petty Cash Template
8 Format Painter
9 Row Insert Key
10 Col Insert Key
11 ALT + A + T Filter
12 Shortkey All (ALT)
13 Remove Duplicate
14 Highlight Duplicate
15 Conditional formationg
16 Print Titles
17 Online Picture
18 Print Area
19 Table and its benefits
20 V Look up

Part 2 Lecture # 1
1 Locking (Most Repated Sales should be locked)
2 Subtotals
Sales Man Sales % of Sales 1 2
A 100000 12.0%
B 150000 18.0%
C 160000 19.2%
D 196000 23.5%
E 226664 27.2%
Total 832664
3 4 5 6 7

You might also like