Sunday, July 10, 2022
Excel for Data Analysts
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.
Plugins : sublime plugin for sublime editor, extensions for vscode. VSCode (VS Code) basics: Drag file to text editing panel to preview, e...
This review is updated continuously throughout the program. Yay I just joined the Udacity Nanodegree for Digital Marketing! I am such an Uda...
All you need to know about Snap IPO. Tech startup news explained for Youtubers in minutes.
The bogus request from P2PU to hunt for HTML tags in real life has yielded a lot of good thoughts. My first impression was that this is stup...