Home

课程目标：

  • 掌握职场高阶函数，处理更为复杂的数据统计与分析；
  • 掌握数据分析的相关工具，有效挖掘数据价值；
  • 掌握数据看板制作方法，数据分析结果更全面、系统及高效；
  • 掌握高阶商务图表类型的绘制，让数据传达形式更为新颖及多样化；


Learning Objectives:

  • Master the higher-level functions to process more complex data statistics and analysis;
  • Master the relevant tools of data analysis and find the value of data effectively;
  • Master data table production methods, make data analysis results more comprehensive, systematic and efficient;
  • Master the drawing methods of high-level business chart types to make the forms of data transmission more novel and diversified;

Session Outline

9:00 – 10:30

单元1：  数据分析基础 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

 

10:45 – 12:00

单元2：  数据库管理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

 

13:30 – 15:00

单元3：  数据透视表及图表报告 PivotTable & Chart Report


整理数据，创建透视表，改变透视结构，透视表汇总，透视表计算，切片器以及时间线，分组功能，

Organize Your Data, Create A Pivottable, Change Layout, Pivottable Summary, Calculated Field, Slicer, Timeline, Grouping Intervals，

 

15:15-16:15

图表美化Excel chart beautification


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

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.

 

 

16:15 – 16:30 Q&A

Speakers

  • 余珊珊

    余珊珊

    易迪思 Office 金牌讲师
    Microsoft Office 咨询顾问、资深培训师

    计算机培训及咨询，微软认证授权中心特邀讲师
    根据客户的要求，提供标准或者专业定制的计算机中英文培训课程。
    微软 Office 课程包括 2003 至 2013 版本的 Word, Excel, PowerPoint, Access, Outlook, Project 等系列课程。

    英文课计算机讲师
    提供给客户全方位的流行软件的培训，（全部 Microsoft Office 软件）Lotus Notes，Internet 工具，脚本语言（HTML），以及各种 International 证书课 程（NHIPP – New Horizons Internet Professional Program 是 CIW 在中国 的教学课程）

    职业教育:
    2005年3月 - 微软认证专家（Certified Microsoft Office Specialist） 1999年9月 - 美国新地平线计算机系统（上海）有限公司

    view more

Tickets

Please use your own name and email when registering for a training session. Additional fees may apply if you fail to register under your own identity. 


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

全天培训课程需要提前付款。

Member Ticket
Member Price RMB 998
Member Company Employee Ticket
Standard Price RMB 998
Non-member Ticket
Standard Price RMB 1,098

Registration

  • All registrations shall be made online before the session. Payment also shall be made before the session.
  • 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".
Cancellation Policy
  • Cancellation: If you need to cancel your registration, please notify David Ma at (86 21) 6169 3016 or email david.ma@amcham-shanghai.org at least two weeks prior to the session for a full refund. Cancellation made within two weeks before the session will not be refundable.