審計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

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