学习目标/ Course Objectives:
1. 掌握以数据分析为基础的业务问题解决思路
2. 掌握用Excel追踪、管理、分析和展示数据的实用技巧
3. 最大化工作汇报中的数据价值，用数据增强汇报的逻辑、故事性和说服力

1. Business problem solving based on data analysis
2. Practical skills of tracking, managing, analyzing and displaying data with Excel
3. Maximize the value of data in the work report, and use data to enhance the logic, story telling and persuasion of the report

课程大纲：Course Outline:

单元1：    工作汇报中的Excel应用 Work report with Excel

数据分析报告的类型，数据分析报表结构，撰写分析报告的要求

Data analysis reports include structure of data analysis report and requirements for writing analysis report

单元2：    数据分析基础 Data Analysis Fundamentals

绝对引用，定义名称，常用函数（SUM, SUMIF, COUNT, COUNTA, COUNTIF, DATE, TODAY, NOW, TRIM, LEFT, RIGHT, ROUND, ROUNDUP, ROUNDDOWN, IF, VLOOKUP…）

单元格属性，使用表样式，使用条件格式
Absolute Reference, Name Define, Frequently Used Functions (SUM, SUMIF, COUNT, COUNTA, COUNTIF, DATE, TODAY, NOW, TRIM, LEFT, RIGHT, ROUND, ROUNDUP, ROUNDDOWN, IF, VLOOKUP …), Cell Format, Table Styles, Conditional Formatting)

单元3：    数据库管理Database Management

规范化数据，利用自定义列表控制排序，数据库高级筛，数据库函数 (DSUM, DCOUNT, DAVERAGE…)，

分类汇总，合并计算工作表，数据导入导出
Data Normalization, Use Custom List For Data Sorting, Advanced Filter, Database Functions (DSUM, DCOUNT, DAVERAGE…), Subtotal, Consolidation, Import and Export Data

单元4：    数据透视表及图表报告 Pivot Table & Chart Report

整理数据，创建透视表，改变透视结构，透视表汇总，透视表计算，切片器以及时间线，分组功能，
Organize Your Data, Create A Pivottable, Change Layout, Pivottable Summary, Calculated Field, Slicer, Timeline, Grouping Intervals，

图表美化,Make Excel chart fruitful

柱状图，折线图，圆饼图， 树状图， 瀑布图， 漏斗图 ,直方图,箱形图,散点分布图， 填充式图表,等等

Histogram chart,Line chart,Round pie chart, Tree chart, Waterfall figure chart, Funnel figure chart, Histogram chart, Box figure chart, Thermometer chart, Filled chart,etc.

Terms & Conditions:

Events have limited seating so to ensure your attendance we encourage advance online registration and payment for ALL events. We cannot guarantee entry to anyone not registered in advance.

Cancellation Policy:

If you cannot attend an event for which you have registered, please cancel your registration no later than one business day prior to the event. If you fail to notify us of your cancellation in a timely fashion, you will be charged for event costs.

To cancel you can: 1) email: yangzhao@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website.

Speakers

Ms. Shanshan Yu

office trainer

Ms. Shanshan Yu

office trainer

View speaker details

Computer Instructor and Consultant
Provide my clients with standard or customized computer training
course (MS Office Word, Excel, PowerPoint, Access, Outlook, Project
beginning to advanced level, 2000 version to 2013 version, also Lotus
Notes Client training) according to their demand in both Chinese and
English.
Office Applications Consultant
Developing Access databases; Developing end-user manual;
Designing PowerPoint presentation; Trouble-shooting for MS Excel,
Project and PowerPoint etc.
1999 – 2002 New Horizons Computer Learning Center, Shanghai

计算机培训及咨询，微软认证授权中心特邀讲师
根据客户的要求，提供标准或者专业定制的计算机中英文培训课程。
微软 Office 课程包括 2003 至 2013 版本的 Word, Excel, PowerPoint, Access,
Outlook, Project 等系列课程。
办公软件应用咨询（部分案例）
为以下公司开发 Access 数据库：
构天管理咨询（中国）：管理培训数据库
中国南方航空公司：客户飞行里程查询数据库
全球贸易（智利）有限公司：出口记录跟踪数据库
上海美国商会：事件管理数据库
为和记黄埔（上海），上海美国商会等设计 PowerPoint 演示文稿
为飞利浦（中国）和贝卡尔特（中国）编写 Lotus Notes 终端用户手册
为所有的客户解决软件使用当中的疑难问题
1999 - 2002：新地平线计算机系统有限公司，上海

Related

Contact