培训内容WORKSHOP CONTENTS
Participants will explore various automation solutions to each common business reporting problem. The result would be significant productivity gains in business reporting. We will show you how to reduce a 30min reporting process to 3 seconds!
我们将向您展示:如何将制作报告所耗费的时间,由原有的 30 分钟缩短至 3 秒钟!课堂中所探讨的各种自动化解决方案,完全可以应对常见商业报告所面临的问题。学习并掌握这些内容,可以帮您大大提高制作报告的效率。
更多“如何解决问题” MORE HOW-TO TOPICS
·How to automate database imports.
·How to replace manual pivot tables in reporting.
·How to systematically archive your reports.
·如何自动导入数据库信息?
·如何替代手动创建数据透视表?
·如何有条不紊的将报告存档?
前提条件PRE-REQUISITES
The great thing about this program is you do not need to have any IT background. You do need to have basic proficiency in Excel and an open mind to learn new ideas.
无需任何 IT 专业背景,更不需要有编程相关经验。只要对 Excel 基本功能比较熟悉,并且乐于接受新观点、新想法就非常适合报名参加本课程。
受众学员WHO SHOULD ENROLL
This is a career enhancing training program for business analysts, statisticians, business intelligence executives, reporting analysts, accountants.
本课程旨在提升职业实战技能,面向商业分析师,统计师,商业智能分析人员,报告分析师,财务等需要制作商务数据报告的相关工作者。
课程大纲COURSE CONTENT
Accessing data in Excel: A macro writer's perspective
Methods of loading and saving data in Excel
Control and manipulation of worksheet data
Utilizing functions in Excel
Data mining in Excel
Creating custom report worksheets
以Excel 宏的方式访问数据
加载、保存数据的方式
操作、控制数据表中的数据
在 Excel 中使用函数
在 Excel 中进行数据挖掘
创建自定义报告
Agenda (培训者请一定带电脑来参加)
08:30-09:00: Registration
09:00-12:00: Morning session
12:00-13:00: Lunch
13:00-16:00: Afternoon session
For bank transfers, please indicate use BJEVENT0318 as subject.
About the instructor
刘凯 Adam Liu
MCSE, MCDBA, MCP, MCT, Microsoft Most Valuable Professional (MVP)
Project Management Professional (Certified by US Project Management Institute)
Mr. Liu has four years’ experience in multinational companies and has six years’ experience in training. He is fluent in English and can conduct training in both English and Chinese. He is also a ‘Microsoft Most Valuable Professional. He has extensive practical experience in software applications and his main training areas include Microsoft Office products and Windows Vista/ Windows 7 as well as IBM Lotus Notes.
MCSE, MCDBA, MCP, MCT, 微软最有价值专家(MVP)
美国项目管理协会认证项目管理专家(PMP)
四年纯外企环境工作经验,六年丰富的教学经验,流利的英文可施行双语教学。
微软MVP最具价值专家。主要讲授课程包括微软MS Office全产品系及Windows Vista/7, IBM Lotus Notes等系列课程,在软件应用领域有着非常丰富的实践经验。
美国项目管理协会认证项目管理专家(PMP)。主要讲授MS Project实现项目管理,EPM及PMP认证课程等项目管理类课程。