有没有遇到过如此情况?
面对大量表格、数据,老板已经交代了各项分析任务,可却如何都无法想出该如何入手?数据工具、函数应用、甚至透视表都已经信手拈来,可为何数据却总是不能随我心愿?问题出在哪里?
其实,数据应用的精髓您是否真的了然于胸?学会使用分析工具?了解更多的函数应用?甚至搞定 VB 编程?歪掉了歪掉了,套路完全搞错!事实上,对我们日常所需的数据分析工作来说,最为重要的核心问题恰恰是被很多人完全忽略掉的一项,那就是,原始数据表单的结构设计!
EXCEL 数据管理高阶体验——将会从日常所需的各类分析需求入手,深入揭露数据表单的设计原则与思路,从根本上解决您的数据应用与分析困扰,真正实现随心所欲的掌控您的数据!
培训要点:
EXCEL 数据表结构设计
- Excel 的规范化数据编辑与查询方式
- 使用 Excel 进行数据查询与分析时的理想数据结构规范
- Excel 规范数据结构的设计思路与修改方式
多表数据关联与链接时的 VB 与函数应用
- 此部分内容将首先解决类似多年份、多月份、多部门等多张数据表单内容的罗列或汇总加工操作,让您每年、每月、每周甚至每天都要头痛的繁复劳动可以瞬间搞定,真正实现工作效率的最大提升。
- 此部分内容另一核心研究对象为应用函数实现多表数据的链接计算与统计分析,所涉及函数将包含数据查询、汇总、判断、分析、日期、文本处理等多方面,也将初步探讨关于自定义专门计算函数的应用规范。
Excel 批量数据的分析规范与技巧
- 此部分内容将以人事、财务、销售相关的实际案例为分析对象,以数据透视表为应用工具,彻底为您扫清在批量数据分析过程中所遇到抑或可能遇到的诸多困扰,彻底实现您的数据“随心所欲”!
TRAINING AND ORIENTATION:
EXCEL Data Table Structure Design
-To edit and query Excel data standardize
-Ideal for data query and analysis using Excel data structure specification
-Excel specification data structure design and modifications
VB and Function Application with multiple linked data
-This section will solve similar year and month, multiple departments and multiple data form the content of list or summary machining operations, your yearly, monthly, weekly or even daily headache of complicated labor can instantly efficiency maximum lift.
-Another core part of this study using multiple tables of data link calculation and statistical analysis, involving function will include a data query, collection, evaluation, analysis, date, text-processing and other aspects, will also help to deal with a custom application of specialized calculation function specification.
Excel Bulk data analysis of norms and techniques
-This section will provide personnel, finance, sales, analysis of actual cases related to the object, PivotTable tool, completely cleared in the bulk of the data analysis for you encountered or may encounter many problems in the process, which can realize the data follow your heart.
Agenda
12:30-13:00 Registration
13:00 – 14:30 Session 1
14:30 – 14:40 Break
14:40 – 17:00 Session 2
17:00 End
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.
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 nanjing@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website.