How To Improve Efficiency with the help of Excel

How to improve efficiency through Excel with assessment

1. How To Improve Efficiency
Excel Basic Operation
3:33 PM

2. Course Target
•Build standard
•Skill
•Minds
3:33 PM

3. Schedule
•9:30~10:00 Basic Introduction of Excel
•10:00~10:15 Basic Rule
•10:15~10:30 Quick Operation
•10:40~11:10 Excel Modules
•11:10~12:00 Filter/Data validation/Conditional format
•14:00~15:00 Function
•15:00~15:30 PV table
•15:30~16:00 Chart/Photo
•16:10~16:30 Sheet Protection
•16:40~15:00 Macro
•17:00~17:30 Case study
3:33 PM

4. What is Excel
3:33 PM

5. What is Excel
3:33 PM

6. What is Excel?
•Where’s it from?
•What’s the usage?
3:33 PM

7. History
1977 VisiCalc
1983 Lotus1-2-3
1985 ExcelforMacintosh
1987 Excel2forWindows
1990 Excel3
1992 Excel4
1993 Excel5
1995 Excel95
1997 Excel97
1999 Excel2000
2001 ExcelXP
2003 Excel2003
2006 Excel2007
2010 Excel2010
2013 Excel2013
Dan Bricklin and Bob Frankston
3:33 PM

8. 8 Basic Rule
Save
Don’t open too many excel
Don’t pull to cover when being in filter
XLS and XLSX$
If you send it to others, keep it stupid and simple
Don’t merge cells until printing
Unique Format/name
如果有人问你要一些
modelname和model
code,你发给了他这些，
他可能不会很开心
只给对方需
要看到的信
息
3:33 PM

9. Quick Operation
3:33 PM
Ctrl+C copy
Ctrl+V paste
Ctrl+D paste
Pull to cover cells copy fomula, 创建等差数列

10. Quick Operation
3:33 PM
Ctrl+A select all and smart
Ctrl+方向键、 双击表格线 move to the end
Shift+方向键 continue select
Cttl+shift+方向键

11. Quick Operation
3:33 PM
Format painter copy formula
Ctrl+Z Redo
F4 repeat last operation/add $

12. Quick Operation
3:33 PM
Ctrl+N
Ctrl+P
Turn to number 1
Ctrl+shift+L filter
怎样发现快捷键？

13. What Excel includes
3:33 PM

14. What Excel includes
•Input & Format
•Calculation
•请大家把信封里的各种功能分到这两个主功能下面
3:33 PM

15. What Excel includes
3:33 PM
Input & Format
Analysis

16. Conditional Format
•自动标记具有指定特征的数据
•按照你的想法把数据显示成不同的颜色
3:33 PM

17. Data Reorganize
Unique Form(size of cell, column, row, contents, color)
Unique name for one same object
Unique location for one same object
3:33 PM

18. Filter
By name
By Color
By Top10%
Custom your own rule(date/month/year/contain/not contain…)
Tips: If you filter, maybe you need select
3:33 PM

19. Data validation
Convenient choice
Unique input data form
Auto alert input error
3:33 PM

20. Other Function
Round
today,month,weeknum
if error
Left right
&
If
countif
Sumproduct
数组函数（ transpose/offset）
3:33 PM

21. Pivot Table
3:33 PM

22. Pivot Table
•So important!!!!
3:33 PM

23. Chart
•Make data visible
•Consider for your viewer
•Be beautiful
•Data adapts to chart, chart adapts to data
3:33 PM

24. Chart
3:33 PM

25. Photo
•Filter with data
•Align
•Compress
3:33 PM

26. Sheet protection
你做的表格，很简
洁，清晰，有现成
的公式，发出前，
是这样的
收回后，是这样
的…….
别乱改我的表格，锁定它！
3:33 PM

27. Macro
•所谓宏，就是一些命令组织在一起，作为一个单独命令完成一个特定
任务。
•一串语言，替你告诉电脑应该做的操作，不需要你手动的重复操作
3:33 PM

28. Learn by myself
3:33 PM

29. Homework
3:33 PM

30. Thanks~
3:33 PM

31. •内容太多 游戏环节需要控制和圆回来
•Target:
•Schedule: 白板纸
•Expectation by 贴纸
•8 rules 快捷键物料化
•题目调整，和品牌联系起来，更亲切
•分组按照掌握的能力
•最后把salary tool 做出来思路
3:33 PM