THIS TRAINING WILL BE IN CHINESE LANGUAGE ONLY
Many people have to work overtime till midnight in order to deal with the data processing. Faced with the huge amount of data and complicated repetitive work, what method and skill we need to master is helpful to easy control the Excel ?We will find out the answer in our course. From the data searching, sorting and rapid making business reports, many secrets and skills can be found to make our work easier and intelligence.
万家灯火的时候,很多人都在为了处理工作数据而加班。面对海量的工作数据和繁复的重复工作,我们需要掌握什么样的方法和技巧才能轻松驾驭Excel制作报表?答案将在本次课程中得到揭晓。从数据的查找、整理到商务报表的快速制作,其中有很多很多的秘密和技巧可以让我们的工作更轻松、更智能。
MAIN CONTENT 主要内容
- Reasonable design of Excel data structure 合理的Excel数据结构设计
- Data collection and analysis skills(Containing PivotTable and popular function) 数据的整理和分析技巧(含数据透视和常用函数)
- Effective presentation data with chart 利用图表有效呈现数据
- The method of data security and protection 数据的安全和保护方法
- Software version required:Office 2010 or 2007 软件版本为Office 2010或2007
AUDIENCE 课程受众
For the People who need to improve the Excel using level, improve the efficiency of data processing.(Mid-Senior course)
本课程适合有需要系统提升Excel使用水平,提高数据处理效率的Excel用户(中高级水平培训)
COURSE OBJECTIVE 课程目标
- Master the proposed data source formats in data processing,correct the error habit of establishing the data form. 掌握数据分析中的理想数据源格式,改变建立数据表格的错误习惯。
- Learn and master the practical function of enhance the efficiency of processing data, and operation skills. 学习并掌握能提升数据处理效率的实用功能并掌握操作技巧。
- Master the tools of fast making report and the popular data analysis function, improve the efficiency of data analysis. 掌握快速进行报表制作的重要工具和常用数据分析函数,提高数据统计分析效率。
- Find the suitable data presentation and performance practices, highlighting the information of data, improve the work reports quality. 找到适合自己的数据呈现方式和表现手法,突出数据信息,提高工作报表质量。
COURSE AGENDA 课程大纲
9:00 to 9:30 Registration
9:30 to 9:45 The basic data processing flow and the notice 数据处理基本流程和注意事项
- The data processing flow in the work 工作中的数据处理流程
- The precondition-prerequisite of data processing 数据处理的必要前提
9:45 to 11:10 Data collection and sorting 数据的收集和整理
- Data collection 数据的收集
- Multiple sources of data import 多种来源导入数据
- Standard the manual input data 控制手工输入数据的合规性
- The sorting of the data 数据的整理
- The processing of unqualified data (Data validation) 处理不合格的数据格式(数据有效性)
- The processing of repeated data 重复数据的处理
- Popular tools of data processing 常用数据处理工具
- The special usage of sort 排序的特殊应用
- The advanced usage of filter 筛选的高级应用
13:30 to 14:50 Data analysis faster 数据的快速统计与分析
- Summary data fast with subtotals 利用分类汇总快速统计数据
- Use the PivotTable to build report 灵活运用数据透视表构建报表
- The premise of PivotTable 数据透视的构建前提
- PivotTable getting start 数据透视表的构建方法和技巧
- The adjustment and beautification of PivotTable 数据透视表的调整和美化
14:50 to 16:20 Statistical analysis and report making with function 利用函数进行统计分析和报表制作
- The necessary knowledge of using function 函数运用的必要准备知识
- The learning of popular function 常用函数的学习
- The statistical function(SUM, SUMIF, COUNT, COUNTIF, AVERAG, AVERAGEIF…)统计函数的学习和应用(SUM、SUMIF、COUNT、COUNTIF、AVERAGE、AVERAGEIF等)
- The lookup function(VLOOKUP…) 查找引用函数的学习和应用(VLOOKUP等)
- The logical function(IF, AND, OR…)逻辑函数的学习和应用(IF、AND、OR等)
- Use the different functions together to solve practical problems——case study 利用函数综合解决实际问题——案例学习
- Troubleshooting for function error 函数常见错误的排除
16:20 to 17:30 The present of data information 数据信息的呈现
- Professional business chart 专业化的商务图表应用
- The popular chart types and tips 常用图表类型与制作技巧
- The layout and beautify of chart 图表的布局与美化
- The senior skills of chart application 图表应用高级技巧
- Use conditional formatting presenting data information 使用条件格式呈现数据信息
- Use default conditional formatting 自动套用条件格式
- Use a custom conditional formatting 自定义你的条件格式
17:30 to 17:50 Excel reports preparation Excel报表的发布准备
- The Excel report typesetting skills Excel报表排版技巧
- Use hyperlinks in the table 表内超链接的使用
- Typesetting skills 排版技巧
- The publish settings of electronic version 电子版本的发布设置
- Protect the report not to be changed 保护报表不被更改
- Set the editing area 设置允许编辑区域