execl 课程投票
请各位伙伴在周四下班之前完成投票哦。
我们会按投票结果进行课程安排
H5，H5页面制作工具
- START
- Hi Partners：We have providedfive courses for you.Please choose the courses you need.We will teach themost selective courses
- Execl Class Selection
- Class one: Excel basics
- File naming, save as and version control
- Basic equation - sum, average, max, min
- Dragging and complex sorting
- Text in excel - Alt Enter
- Merging
- Format and alignment (Ctrl + 1)
- Find and replace
- Spell check
- Charts - Basic
- Number and Edit shortcuts
- Paste as
- Printing in excel
- Comment
- View - freeze, new window, grid line
- Conditional formatting
- Positioning (Ctrl + G)
- Group
- File naming, save as and version control
- Class four:how to build a good excel model and check for errors in an excel model
- Model building principles - yellow cell, logical flow within one tab, logical flow across different tabs, assumption page, complexity of equations
- Table visualization – color, alignment, white space
- Data validation
- Class three:pivot table and index match
- Pivot table
- Index Match
- Pivot table
- Class two: Excel equations
- date, if, sumif, sumifs, iferror, left, right, min, max
- Other relevant equations
- date, if, sumif, sumifs, iferror, left, right, min, max
- Class five: data visualization
- Examples of bad design obscuring the message of the data
- The principles of good data visualization
- Applying the principles in reports and presentations
- Tools to use to help apply the principles
皖公网安备 34010402701575号
