Advanced Excel Training in Data Management

From the data searching, sorting and rapid making business reports, many secrets and skills can be found to make our work easier and more intelligence.

 

TRAINING OVERVIEW

Many people have to work overtime till midnight in order to deal with the data processing. Facing the huge amount of data and unlimited repetitive work, what method and skill we need to master to generate the report by Excel easily? We will find out the answer in our course. From the data searching, sorting and rapid making business reports, many secrets and skills can be found to make our work easier and more intelligence.

 

TRAINING OUTLINE

  • Part 1: 

Application of complex functions (40Mins)
Advanced functions and functions Integration
The other common functions

  • Part 2: 

Experience Advanced techniques for data
Effective early warning Management (30Mins)
Data validity do cascading menus
Conditional formatting enhancements
Defining conditional format

  • Part 3: 

Advanced statistical analysis of data(30Mins)
Rank
Custom list
Sort by custom sequence
Advanced filter
Or, with, without a condition.
Multi-condition application

  • Part 4: 

Chart application(1h)
Chart type
Cylindrical diagram / broken line diagram?
Percentage stacking map and pie chart
Scatter chart, bubble chart, and radar map
Mini picture
Chart format
Source data modification
Custom chart format and type
Examples of common business charts

  • Part 5: 

PivotTable and its Application(1h)
Considerations for creating PivotTable
New slicer function
Create a data perspective
Advanced application of PivotTable

  • Part 6: 

Window control(1h)
Form control
Radio frame
Check box
Control link
Scoring computation
Creating dynamic diagrams with controls
Application of dynamic chart making

  • Part 7: 

Using macros to improve work efficiency(20Mins)
Macro introduction
Macro recording
Macro editing
Dynamic query using Macro Real data

  • Part 8: 

Excel Advanced data Analysis tool of Excel(30Mins)
Variable solution
Scenario manager
Audit worksheet

  • Part 9: 

Data security (20Mins)
Protecting workbook structures
Working in collaboration with the workbook

 

AGENDA

Date 日期: 11th September 2019 (1 Day)
Time 时间: 9:00 am - 5:00 pm
Language 培训语言: Chinese
Price 价格: 
1800 RMB* for CCI FRANCE CHINE Members 会员价
2000 RMB* for Non Members 非会员价

*subject to 6.72% VAT tax. Fee includes lectures, course materials and lunch.
此价格为税前价格,需加收6.72%税费。价格包括会务,资料费,午餐费。


TARGET GROUP

For experienced Excel users who need to get their Excel skills up to speed for reporting and analysis.

 

REGISTRATION

 

Share this page Share on FacebookShare on TwitterShare on Linkedin

Close

CCI FRANCE CHINE HOTLINE