【Online Training】Data Analysis Training:The Tips of Excel 线上培训《Excel必备秘籍》(CN中文) Go back »
-
Time2022-04-21 | 09:00 - 16:30
-
Venue:Zoom Online
-
Address:Online ( the way to enter the webinar will be shared prior to the event)
线上(会议链接提前发送) -
Fee:Members: 998 |
Non Members: 1098
The European Chamber Southwest China Chapter sincerely invites you to attend the Online Training Data Analysis Training:The Tips of Excel on 21st April, Thursday, 2022.
中国欧盟商会西南分会诚邀您参加将于2022年4月21日(星期四)由中国欧盟商会举办的线上培训《Excel必备秘籍》。
课程受益
• 掌握职场高阶函数,处理更为复杂的数据统计与分析;
• 掌握数据分析的相关工具,有效挖掘数据价值;
• 掌握数据看板制作方法,数据分析结果更全面、系统及高效;
• 掌握高阶商务图表类型的绘制,让数据传达形式更为新颖及多样化;
Course Benefits
• 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;
课程受众
适合希望通过EXCEL快速提高工作效率,掌握数据分析方法的企业员工。
Course Audience
Suitable for employees who want to improve their work efficiency and master data analysis methods.
课程大纲
一、表格根基:高级操作技巧
1. 智能表格
2. 条件格式
3. 分列与快速填充
4. 工作簿、工作表和单元格数据保护
5. 邮件合并
二、表格灵魂:函数公式魅力
1. 公式与基础函数
2. 统计求和家族: Sum, sumif, sumifs, count, countif, countifs
3. 逻辑查找帮你解难题: lookup, vlookup,match
4. 日期函数: datedif, networkdays
三、表格利器:透视规划分析
1. 初始数据透视表
2. 同一字段不同汇总方式
3. 透视表自动和手动组合
4. 切片器使用与联动
5. 动态数据透视表设置
四、Power Query
1. 工作簿自动汇总
2. 文件夹自动汇总
五、表格印象:图表演示之道
1. 迷你图、双Y轴图、复合饼图
2. 图表美化:柱形图、折线图、饼图
3. 计划与实际对比图制作:温度计柱形图、柱形+堆积图
六、总结提高:学以致用,整体答疑
Outline
Table Basis: Advanced Skills
1. Smart form
2. Conditional format
3. Sorting and fast filling
4. Data protection of workbooks, worksheets and cells
5. Mail merge
Soul of Table: The Charming of Formulas
1. Formula and basic function
2. Sum, SUMIF, SUMIF, Count, CountIF, CountIFS
3. Solve difficult problems - Logic search: Lookup, VLookup, Match
4. Date function: datedif, networkdays
The Weapon of Table: PivotTable
1. Initial PivotTable
2. Different summary methods for the same syllable
3. Automatic and manual combination of pivot table
4. Slicer use and linkage
5. Dynamic PivotTable settings
Power Query
1. Automatic summarizing of workbook
2. Automatic summarizing of file
The Impression of Table:Business charts
1. Mini chart, double Y-axis chart, Pie chart
2. Chart beautification: column chart, line chart, pie chart
3. Making contrast: thermometer column chart, column stack chart
Q&A
Disclaimer 免责声明:
Participants must ensure have no travelling or living history of high risk areas recently and maintain proper social distancing norms and abide by the Chongqing Municipal Government’s Epidemic Prevention and Control Rules. If you do not follow the relevant regulations, the European Union Chamber of Commerce in China accepts no responsibility for any physical discomfort you may experience during or after the event. Thank you for your understanding and cooperation!
参加者必须确保近期无疫情高风险地区旅居史,并保持适当的社交距离,遵守重庆市政府关于流行病预防和控制的相关规定。如果您不遵守相关规定,则中国欧盟商会对您在活动期间或之后可能遭受的任何身体不适不承担任何责任。 感谢您的理解与配合!
Registration 活动注册
1. Online registration by 19th April, 2022. 网上注册(截止2022年4月19日)。
2. Email registration by 19th April, 2022: please send Company Name, Name, Title (both in Chinese and English), Mobile Number and Email Box to chongqing@europeanchamber.com.cn . The registration is complete only if a confirmation letter is received. 邮件注册(截止2022年4月19日):请将中英文的公司名称、姓名、职务,手机号码和邮箱发送到 chongqing@europeanchamber.com.cn 。收到商会邮件确认后注册成功。
Payment Remark 付款注意事项:
付款方式:报名后可将报名费转账至以下账户,并在银行转账单上附注 CQ20220421;也可以联系商会工作人员获取支付宝账号或商会微信账号,付款后备注附注 CQ20220421。
RMB Bank Account 报名汇款账号
A/C Name: 中国欧盟商会
China CITIC Bank 中信银行京城大厦支行
Capital Mansion Sub Branch
No.6, Xinyuan Nan Road
Chaoyang District, 100004 Beijing
A/C No. 银行账号: 7110210182500027543
S.W.I.F.T. Code: CIBKCNBJ100
开户行行号: 302100011026
北京市朝阳区新源南路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 chongqing@europeanchamber.com.cn , or 2) cancel online if you registered for the event through the website.
如果您不能参加已注册过的活动,请在不少于一个工作日的时间内取消您的注册。若您未能及时地通知我们,我们将收取您相应的活动费用。
如取消注册您可以: 1) 发送邮件至 chongqing@europeanchamber.com.cn; 或 2) 网站注册者可在网上取消。
Advisory Council Policy 顾问委员会政策
Members of the Advisory Council may receive complimentary admission to Chamber seminars, conferences and factory visits up to two attendees per event. Additional participants will be charged at the member rate.Advisory Council members will still be charged the standard member rate for participation in training courses and special events, such as gala balls, government appreciation dinners, or admission to corporate social events/tournaments.For further information contact Natalia Chen via chongqing@europeanchamber.com.cn
欧盟商会顾问委员会成员将获得包括讲座、会议、工厂参观等商会活动的免费入场券。每次活动仅限两人免费参加,额外参与者按会员价格收取门票。欧盟商会顾问委员会成员在参加商会培训和其他特殊活动时需按普通会员价格收取门票,例如:欢迎酒会、政府答谢晚宴、或社交活动等。获取更多相关信息请联系陈怡帆 chongqing@europeanchamber.com.cn
Speakers
Ms. Grace Yan
Ms. Grace Yan
多家 500 强企业 Office 培训授课经验
长期为客户和学员解决 Office 问题
多个自媒体公众号微课讲师
受众学员 10000 人以上
Rich office training in many global 500 companies
Solove office problem for clients and trainees
Micro-class trainer for many Wechat Office Accounts
More than 10,000 trainees
多年 500 强外企工作经验,能准确挖掘企业培训需求,快速帮助学员提高 Office 技能;课程结构条例清晰,课程案例吻合工作需要;授课风格生动有趣,善于调动学员积极性,深受学员喜欢和好评。
Having many working experiences in G500 companies, being able to meet corporate’s training requirements, can help students’ office skills quickly, the training is designed in good logic, having a humor teaching style in class and being well acclaimed by trainees
Office 办公系统课程
《Excel 商务数据处理与分析》
《Excel 数据透视表与图表美颜》
《Excel 高级商务图表制作》
《Excel 在 HR 中的高效应用》
《大数据时代——用 PPT 讲话》
《Office365 该这样玩儿》
Office Series Courses
Business Data Processing and Analysis by Excel
Excel PivotTable and Charts Beautify
How to Make Business Charts by Excel
Excel Makes HR Work More Efficient
PPT Talks in Age of Big Data
Office 365 Is More Than Office
曾经服务客户
雪佛龙中国能源公司
中国石油西南天然气研究院沃尔沃汽车制造有限公司 西南美商会
新电科技有限公司澳新银行
保利地产
当纳利印刷有限公司四川机场集团
中国核动力研究设计院电子科大成都研究院 西安印钞有限公司
中粮大悦城
上海国际医学园区中国中铁西南院
Clients
Chevron China Energy Company
Petrol China
Volvo Cars Co., Ltd
Southwest AmCham
NCSI
ANZ Bank
Poly Real Estate
RR Donnelley Publishing and Printing Company
Sichuan Airport Group
Nuclear Power Institute of China
Chengdu Institute of UESTC
Xi’an Banknote Printing Co., Ltd
Joy City of COFCO
Shanghai International Medical Zone
Southwest Institute of CRECG