Home

Beginning a new job that requires advanced Excel skills? This is an activity-based workshop that will cover advanced Excel features and commands that you can use at work.


您是否面临这样的挑战：需要掌握更高级的Excel应用技巧，以应对一项新的工作任务？大量的动手实践活动，丰富的实战经验技巧，涵盖多项Excel关键技术。没错！这就是本课程的魅力所在，帮助参与者拓展对Excel惯有的认识和了解，更上一层楼。

Session Outline

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宏


  • 什么是宏，它能实现什么？
  • 录制宏，实现按照条件查询
  • 录制宏，实现同步多透视表
  • 常用窗体控件（按钮、组合框等）
Who should attend?

Experienced Excel users who need to get their Excel skills up to speed for reporting and analysis.


具备Excel先前使用经验，期望进一步优化汇总分析技能，快速提升制作报告水平的用户。


Agenda

08:45 Registration & Networking
09:00 Morning Session
10:30 Morning Session Coffee Break
10:45 Morning Session
12:00 Lunch
13:00 Afternoon Session
15:30 Afternoon Session Coffee Break
15:45 Afternoon Session
17:00 Session Ends

Refreshments will be served during the coffee break for the attendees. Lunch at a nearby restaurant is also included with the ticket price.

Speakers

  • 胡芸芸 (易迪思金牌讲师 微软认证讲师（MCT） 微软认证OFFICE专家（MOS） 微软认证技术专家（MCITP） 《PPT变形记—从低质到高质呈现的华丽转变》作者)

    胡芸芸

    易迪思金牌讲师 微软认证讲师（MCT） 微软认证OFFICE专家（MOS） 微软认证技术专家（MCITP） 《PPT变形记—从低质到高质呈现的华丽转变》作者

    微软认证讲师，9年教学经验
    微软认证技术专家，通过微软全球技术测试获得微软技术认证，成为微软认证技术专家（MCITP）
    网易云课堂—企业版 签约讲师
    《PPT变形记—从低质到高质呈现的华丽转变》作者
    三茅人力资源网专栏作家
    致力于企业办公效率与办公技能提升的培训与知识分享

    With 9 years’ experience as a Microsoft Certified Trainer
    MCTS/MCITP Get the Microsoft technology certification through its global test.
    Contracted lecturer in Study.163
    Author of book 《PPT变形记—从低质到高质呈现的华丽转变》
    Columnist for hrloo.com
    Devote to sharing the experience in the upgrading of office efficiency and office skills

    view more

Tickets

A prepayment is required for all full-day training sessions. 

Member Ticket
Member Price RMB 2,650
Member Company Employee Ticket
Standard Price RMB 3,650
Non-Member Ticket
Standard Price RMB 4,650
Member Ticket + Redeem 500 RMB Voucher

This ticket is only eligible for members who have a RMB 500 voucher for FULL-DAY TRAININGS. Failure to present the voucher will result in paying the full price for the session.

If you have any questions about this ticket, please contact ivette.corominas@amcham-shanghai.org

Member Price RMB 2,150
Member Company Employee Ticket + Redeem 500 RMB Voucher

This ticket is only eligible for member company employees who have a RMB 500 voucher for FULL-DAY TRAININGS. Failure to present the voucher will result in paying the full price for the session.

If you have any questions about this ticket, please contact ivette.corominas@amcham-shanghai.org

Standard Price RMB 3,150

Registration

  • All registrations shall be made online before the session. For full-day sessions, payment also shall be made before the session.
  • For half-day sessions, AmCham Shanghai members are eligible to attend free of charge with Training Credit*; AmCham Shanghai members without Training Credit are eligible to attend at “Member Rate”; Employees who work at AmCham Shanghai member companies are eligible to attend at "Employee Rate".
  • For full-day sessions, AmCham Shanghai members are eligible to attend at “Member Rate”; Employees who work at AmCham Shanghai member companies are eligible to attend at “Employee Rate”; Non-members are eligible to attend at “Non-Member Rate”.
  • Limited spaces are available and attendance will be given on a first-come, first-served basis.
  • Members please bring your membership card and non-members bring your business card upon check-in at the training session.
Walk-in and Cancellation Policy
  • This session requires confirmation of attendance in advance. If you attend this session without prior registration, you will be charged an RMB50 "walk-in" fee as member and RMB100 as employee.
  • Cancellation: If you need to cancel your registration for a half-day session, please notify Ivette Corominas at (86 21) 6279 7119 ext. 5671 or email ivette.corominas@amcham-shanghai.org no less than 24 hours in advance. If you need to cancel your registration for a full-day session, please notify Ivette Corominas at least two weeks prior to the session for a full refund. Cancellation made within two weeks before the session will not be refundable.
  • To ensure that you have a seat, please come to the session on time. Open seats will be released to other guests 15 minutes after the session starts.

Venue

AmCham Shanghai Conference Center

Suite 568, Shanghai Centre, 1376 Nanjing Road West
Shanghai, China

If you have any questions please contact

Contact Organizer

Show on map