审计Excel培训(ppt 40页)

目录
Formatting / Layout                p 5
Custom
Conditional formatting
Printing –
Set print area
Header footer
Repeat rows and columns at the top / on the left
Page break preview
Text to columns – see pdf
Remove duplicates
Group / ungroup
Data validation
Go to function – Ctrl g
Freeze panes
Set row height / column width 
Transpose
Protect work sheet / work book                  
Basic formulas              p 22
Mathematical formulas
Sum / max / min
Average
Round
Subtotal
Sumif / sumifs
If / iferror
Vlookup / Hlookup
ABS

 

..............................