[go: up one dir, main page]
Scribd
Upload
14 views1 page

Excel Notes 3

Uploaded by

project work
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
14 views1 page

Excel Notes 3

Uploaded by

project work
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

Pivot table:

under insert tab: pivot


values : sum
pivot table analysis:show in tabular form

report layout:
do not show subtotal
click anywhere on data -- shows data in blue

Vlookup: vertical lookup


it is used to find things in a table or a range by row
=vlookup(value you want 2 look up,select all table,rownumber,True/False)
fn+ f4

duplicate values-- conditional formatting

You might also like