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 (数据分析):
Dialog box : additional small controls, menu, modals popped up after selecting a menu item.
Pivot table: Pivot table row column, value, filter is what not to show
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.
It's possible to select data cells and name those cells. See an example here :
This is called named range.
Post a Comment