Automation (自动化操作): automate data analysis in excel
Columns: ranges from A B C D ... to AA AB AC...
Dashboard : did you know you can create interactive, complex dashboard in excel. There youtube tutorials how to do this, and do statistical analysis on your data.
Data Analysis (数据分析):
Data Format:
Dialog box : additional small controls, menu, modals popped up after selecting a menu item.
Ribbon : the control menu where all the copy paste, formatting buttons are.
Advanced functions in Excel:
Financial functions, solver, historic trend line, trend line fitting, correlated movements.
Pro tips:
It's possible to select data cells and name those cells. See an example here :
This is called named range.
No comments:
Post a Comment