课程版本：技能提升精讲版 -- 0.5天（3小时）
授课语言：中文
Agenda 课程安排：
13:30-14:00 Registration 注册登记
14:00-17:00 Training and Q&A 课程培训及问题解答
WHO SHOULD ATTEND? 课程受众：
For experienced Excel users who need to get their Excel skills up to speed for reporting and analysis.
本课程适合具备 Excel 先前使用经验，期望进一步优化汇总分析技能，快速提升制作报告水平的用户。
TRAINING OBJECTIVE 培训目标：
Beginning a new job that needs advanced Excel skills? This is an activity-based workshop to cover advanced Excel features and commands for Excel users who wish to deepen their knowledge of this business application.
您是否面临这样的挑战：需要掌握更高级的Excel 应用技巧，以应对一项新的工作任务？大量的动手实践活动，丰富的实战经验技巧, 涵盖多项Excel 关键技术。没错！这就是本课程的魅力所在，帮助参与者拓展对Excel惯有的认识和了解，更上一层楼。
COURSE OUTLINE 课程大纲：
This program prepares you to take up business analysts roles.
Advanced Cell Formatting 单元格格式高级设置
Applying Functions (COUNTIF, AND, OR) to Conditional Format 条件格式中常用的函数（COUNTIF, AND, OR）
Highlighting Duplicates in Column 高亮显示重复数据
Must Know Functions 必备常用函数
Date and Time Functions, Logical Functions, 时间、日期类函数，逻辑函数
Lookup Functions, Statistical Functions & more. 查找函数，统计函数，其他常用函数
Digital Dashboard 构建数字仪表盘报表
Knowing Digital Dashboard Report Design Concept 报表设计思路与理念
Advanced Formulas & Techniques. 向仪表盘添加微型图表，向仪表盘添加数据有效性，添加常用函数（VLOOKUP,INDEX），高级函数、公式（数组公式）
Sorting & Filtering 排序筛选
Computed Criteria Examples 含计算公式的条件区域
Finding the Unique Values 查找不重复的数值记录
Pivot Table 数据透视
Calculated Fields and Items 添加计算字段、计算项
Grouping Dates/Numeric Items 对数字、日期进行分组
Multiple Consolidation Ranges 多重数据区域汇总合并
More on Excel Charts EXCEL 高级图表
Combination Charts 创建多类型组合图
Waterfall Charts Explained 创建叙述型瀑布图
Go-seek, Scenario & Solver 目标求解、方案分析及规划求解
Introduction to Excel Macros EXCEL 宏
What is a Macro? 什么是宏，它能实现什么？
Recording a Macro for Querying Data, Synchronizing Pivot Tables 录制宏，实现按照条件查询，实现按照条件查询
Forms (Button, Combo-Box) 常用窗体控件（按钮、组合框等）
Registration
1. Online registration
2. Email registration: please send Company Name, Name, Title, Mobile Number to awang@europeanchamber.com.cn. The registration is complete only if a confirmation letter is received.
活动注册
1. 网上注册
2. 邮件注册:请将公司名称，姓名，职务，手机号码发送到awang@europeanchamber.com.cn 。收到商会邮件确认后注册成功。
RMB Bank Account 报名汇款账号
A/C Name: 中国欧盟商会
China CITIC Bank 中信银行京城大厦支行
Capital Mansion Sub Branch
No.6, Xinyuan Nan Road
Chaoyang District, 100004 Beijing
A/CNo.: 7110210182500027543
S.W.I.F.T. Code: CIBKCNBJ100
北京市朝阳区新源南路6号京城大厦
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.
All our events are held in English and are off-the-record unless otherwise stated.
活动条款
活动的席位有限。为了确保您的出席，我们建议所有活动都提前网上注册或邮件注册。对于任何未提前注册者，我们都不能保证您的参与。
我们全部活动都由英文召开，且除特殊说明外均为非公开的。
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 awang@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website.
取消报名
如果您不能参加已注册过的活动，请在不少于一个工作日的时间内取消您的注册。若您未能及时地通知我们，我们将收取您相应的活动费用。
如取消注册您可以： 1) 发送邮件至 awang@europeanchamber.com.cn； 或 2) 网站注册者可在网上取消。
