Visit our Homepage










Presented by:



Speaker:



 

 

易迪思培训中心 金牌讲师
微软（中国）特约讲师
美国 PMI 项目管理认证 PMP

 

Eddic （China）Training Center

(Click here to download bio)

 

Dear Member，

Member Training Program (Chinese Session):

Excel Advanced Tour &

MS PPT Design Ideas for Business

 Excel 高级课程（中文）

PPT商务演示?设计理念（中文）

 

9:30-16:30, Tue-Wed, May 12th -13th, 2015

(registration time: 9:00-9:30)

 

AmCham Tower Suite 1801, Guangzhou International Sourcing Center
华南美国商会塔海珠区琶洲大道东8号广州国际采购中心1801室

Cost: RMB2000/day/person for AmCham members
RMB2500/day/person for non-members

Advanced payment is needed, all income will go directly to the training company

培训费用：会员价2000元/天/λ（非会员2500元/天/λ）【含：授课、教材、午餐、税、赠送1年基础咨询】

此培训课程需提前缴�眩蟹延媒苯佑膳嘌倒臼杖�

备注：（学员上课需自备携带安装有Office 2007 及以上版本的笔记本 ）

 

May12th:

Excel Advanced Tour

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惯有的认识和了解，更上一层¥。

Who Should Attend? 受众学员

For experienced Excel users who need to get their Excel skills up to speed for reporting and analysis. 具备Excel先前使用经验，期望进一步优化汇总分析技能，快速提升制作报告水平的用户。

 

Advanced Topics Covered:课程大纲

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 EXCEL高级图表

• Combination Charts

• Waterfall Charts Explained

Go-seek, Scenario & Solver目标求解、方案分析及规划求解EXCEL宏

?         Introduction to Excel Macros

• What is a Macro?

• Recording a Macro for Querying Data, Synchronizing Pivot Tables

• Forms（Button、Combo-Box）

May 13th:

MS PPT Design Ideas for Business

PPT商务演示-设计理念（中文??

There’s more beyond PowerPoint templates, and bullet points. Pick up ideas on creating powerful visuals, beautiful design and typography to captivate your audience.

 

This seminar is about how to create great looking slides. Making bad slides is easy and we have seen many. Making good slides is easy too, but you need to be willing to invest in your slides and invest in your own visual thinking skills. We’ll help you with the PowerPoint techniques along the way. 将文字排列成行，加上项目编号，再套用所ν统一的模板。嗯，这看起来不错，很整齐。其实，完全可以换一种方式来设计PowerPoint演示文稿。对，û错，是设计！采用丰富的可视化元素，精美的排版布局牢牢抓住观众的眼球。

 

本课程和您一起讨论如何创建漂亮的幻灯片。糟糕的页面做起来很容易，我们也见得太多太多。想要完成漂亮、精美、具有专业水准的页面也不是难事；不过，需要您在PowerPoint上稍稍花点心思。我们精心准备的课程内容一定可以帮您达成心愿。

Target Group受众对象

The full day workshop is open to all who creates slides for themselves or for someone else.

本课程面向所有需要制作演示文稿的商业用户，无论是为自己制作还是为其他人准备，都适合参加学习和讨论。

About the Trainer

Ms. Wang not only is Gold medal lecturer in Eddic Training Center, but also the Microsoft (﴾China)﴿ lecturer, certificated by PMP in USA.
She has 10 years experience in training, so she is familiar with thinking mode of business people and well knows the training
expectations of those companies ; She can identify the essential issues of companies to train participants and then improve the
efficiency of training.

10年企业培训经验，熟悉企业人思维模式以及工作心态，了解企业培训需求与期望；抓住企业存在的实质问题进行有效培
训，提高企业效率。

Training style:
For effective blend of steady theoretical knowledge and rich experience in the training, she formed a rigorous, clear, practical but
vivid and humorous style of training. She can explain complicated questions in simple way with her original viewpoint. The courses
she held are substantial in content, meticulously give participants a fresh feeling. Therefore, MS.Wang has been received high praise
from her customers.

授课风格：
扎实的理论知识与丰富培�稻榈挠行Ы岷希纬闪搜辖鳌⑶逦⑹涤谩⑸⒂哪呐嘌捣绺瘛Ｅ嘌悼纬躺钊肭吵觯�
格新颖、活跃，视角独到，内容充实缜密，给人耳目一新的感觉，一贯受到客户的高度赞扬。

 

With best regards,

 

Harley Seyedin



President
The American Chamber of Commerce in South China
Vice Chairman, China Affairs
The Asia Pacific Council of American Chambers of Commerce

For more information, please contact

AmCham South China at (86-20) 8335-1476

or email events-b@amcham-southchina.org.

Please complete the form and return it by email to events-b@amcham-southchina.org before May 8th, 2015

□ I would like to join the Training Program:

Member

(Y/N)

Name

Position

Company

Tel

Email

Day 1

(May 12)

Day 2 (May 13)

　

　

　

　

　

 

 

　

The American Chamber of Commerce in South China, 2015