审计Excel培训(ppt 40页)
所属分类：内部审计
文件大小：1214 KB
下载要求：10 学币或VIP
点击下载
资料简介：
..............................
目录
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
..............................
精品资料网 m.cnshu.cn
Copyright © 2004- 粤ICP备10098620号-1
