审计Excel培训(ppt 40页)
- 所属分类:
- 内部审计
- 文件大小:
- 1214 KB
- 下载地址:
- 相关资料:
- excel
审计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
..............................
用户登陆
内部审计热门资料
内部审计相关下载