WHO SHOULD ATTEND 课程受众:
For experienced Excel users who need to get their Excel skills up to speed for reporting and analysis.
本课程适合具备 Excel 先前使用经验,期望进一步优化汇总分析技能,快速提升制作报告水平的用户。
PS: Please bring your laptop with Office 2010 or above. 软件版本为Office 2010及以上版本
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
· 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.
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
· Combination Charts
· Waterfall Charts Explained
Go-seek, Scenario & Solver
Introduction to Excel Macros
· What is a Macro?
· Recording a Macro for Querying Data, Synchronizing Pivot Tables
· Forms (Button, Combo-Box)
课程大纲:
单元格格式高级设置
· 条件格式中常用的函数
· COUNTIF, AND, OR
· 高亮显示重复数据
必备常用函数
· 时间、日期类函数
· 逻辑函数
· 查找函数
· 统计函数
· 其他常用函数
构建数字仪表盘报表
· 报表设计思路与理念
· 向仪表盘添加微型图表
· 向仪表盘添加数据有效性
· 添加常用函数(VLOOKUP,INDEX)
· 高级函数、公式(数组公式)
排序筛选
· 含计算公式的条件区域
· 查找不重复的数值记录
数据透视
· 添加计算字段、计算项
· 对数字、日期进行分组
· 多重数据区域汇总合并
EXCEL 高级图表
· 创建多类型组合图
· 创建叙述型瀑布图
· 创建双坐标轴图表
目标求解、方案分析及规划求解
EXCEL 宏
· 什么是宏,它能实现什么?
· 录制宏,实现按照条件查询
· 录制宏,实现同步多透视表
· 常用窗体控件(按钮、组合框等)
Language 语言:Chinese (中文)
Agenda 课程安排:
13:30-14:00 Registration 注册登记
14:00-17:00 Training and Q&A 课程培训及问题解答
Registration
1. Online registration
2. Email registration: please send Company Name, Name, Title, Mobile Number to chongqing@europeanchamber.com.cn. The registration is complete only if a confirmation letter is received.
活动注册
1. 网上注册
2. 邮件注册: 请将公司名称,姓名,职务,手机号码发送到 chongqing@europeanchamber.com.cn收到商会邮件确认后注册成功。
Payment支付方式
1. 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号京城大厦
2. Pay in cash. 现场现金支付
3. Pay by Wechat. 商会微信号转账
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 chongqing@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website.
取消报名
如果您不能参加已注册过的活动,请在不少于一个工作日的时间内取消您的注册。若您未能及时地通知我们,我们将收取您相应的活动费用。
如取消注册您可以: 1) 发送邮件至 chongqing@europeanchamber.com.cn; 或 2) 网站注册者可在网上取消。