l 培训内容:
Training content:
更好的管理你的数据- EXCEL 数据处理与统计技巧课程
Better Data Management- Data Processing and Statistics Skills by Using Excel
l 语言:中文
Training language:Chinese
l 课程简介
Introduction to the training
本课程适合有需要系统提升 Excel 使用水平,提高数据处理效率的 Excel 用户(中高级水平培训)。通过掌握数据分析中的理想数据源格式,改变建立数据表格的错误习惯。学习并掌握能提升数据处理效率的实用功能并掌握操作技巧;快速进行报表制作的重要工具和常用数据分析函数,提高数据统计分析效率。
This training is targeted for the users who need to improve their levels of using Excel and the efficiency of data processing. It helps them to mend their ways of creating data tables, learn practical operating skills about data process and some important tools of establishing data forms in an efficient manner by mastering the ideal data source formats in data analysis.
内容
Content
A. 数据处理基本流程和注意事项
Basic Flow and Precautions of Data Processing
B. 数据的收集和整理
Collecting and Sorting Data
C. 数据的快速统计与分析
Quick Statistics and Analysis of Data
D. 利用函数进行统计分析和报表制作
Using Functions to Analyze Statistics and Establishing Report Forms
E. 数据信息的呈现
Presenting Data Information
F. Excel 报表的发布准备
Preparing for Excel Report Forms
l 议程
Agenda
09:00--09:15 签到
Registration
09:15--09:30 欧盟商会开场词
Welcome remarks by the European Chamber
09:30--12:30 工作中的数据处理流程
The data processing flow in work
多种来源导入数据
Data-import from multiple sources
控制手工输入数据的合规性
Standardization of manual data-input
处理不合格的数据格式(数据有效性)
Process of invalid data(Data validity)
重复数据的处理
Process of duplicated data
排序与筛选的特殊应用
Sort and filter for special applications
12:30--14:00 午餐和休息
Lunch break
14:00--16:30 利用分类汇总快速统计数据
Quick stats by subtotals
灵活运用数据透视表构建报表及美化
Establishing report forms by the Pivot Table
统计函数的学习和应用(SUM、SUMIF、COUNT、COUNTIF、AVERAGE、AVERAGEIF 等)
Study and application of the statistical functions (SUM, SUMIF, COUNT, COUNTIF, AVERAG, AVERAGEIF...)
查找引用函数的学习和应用(VLOOKUP 等)
Study and application of lookup (VLOOKUP…)
逻辑函数的学习和应用(IF、AND、OR 等)
The logical functions (IF, AND, OR…)
利用函数综合解决实际问题——案例学习与函数常见错误的排除
Solving practical problems through different functions—case studies and elimination of common errors
专业化的商务图表应用
Application of professional business charts
Excel报表排版技巧
Typesetting skills on Excel report forms
16:30--17:00 答疑与互动环节
Questions & Answers