Seminar
Focus：Formulas, Functions and Pivot Table
When you have trouble with the time-consuming process and analysis of business data, Excel will help you deal with these situations easily. However, it’s a new challenge for you that how to quickly and effectively master Excel’s functions and pivot table.
Through thematic explanation during the training, you will acquire Excel’s advanced functions and techniques in data analysis, and achieve higher efficiency.
Through thematic explanation during the training, you will acquire Excel’s advanced functions and techniques in data analysis, and achieve higher efficiency.
All CEGOS open courses are upgraded!
- Equipped with LearningHub platform
- Every learner will presented with the following e-Learning courses for FREE!
All CEGOS open courses are upgraded!
- Equipped with LearningHub platform
- Every learner will presented with the following e-Learning courses for FREE!
Summary
When you have trouble with the time-consuming process and analysis of business data, Excel will help you deal with these situations easily. However, it’s a new challenge for you that how to quickly and effectively master Excel’s functions and pivot table.
Through thematic explanation during the training, you will acquire Excel’s advanced functions and techniques in data analysis, and achieve higher efficiency.
Through thematic explanation during the training, you will acquire Excel’s advanced functions and techniques in data analysis, and achieve higher efficiency.
Attendees
* All professionals who need to increase work efficiency by using Excel
* Staffs in all functional departments who want to improve the skills of data process, analysis and decision-making
* Financial and administrative staffs who need to strengthen the control of internal costs
* Staffs in all functional departments who want to improve the skills of data process, analysis and decision-making
* Financial and administrative staffs who need to strengthen the control of internal costs
01
Preparation before seminar
02
Outlines
1. Formulas and functions:from fundamental to application
* Understanding the concept properly
* The key for advance operation: the reference
* A new way to classify the functions
* How to master a variety of general functions
* Different styles of data operation in human resource, administration, finance, sales, procurement and manufacture areas
2. Pivot table: grasp the structure
* Using database concept to manage Excel data sheets
* The principle of pivot table
- Create a fancy pivot table and setting up
- Different operation setting in pivot table
- Special functions you need to know in pivot table
* The data analysis exercise in human resource, administration, finance, sales, procurement and manufacture areas
* Understanding the concept properly
* The key for advance operation: the reference
* A new way to classify the functions
* How to master a variety of general functions
* Different styles of data operation in human resource, administration, finance, sales, procurement and manufacture areas
2. Pivot table: grasp the structure
* Using database concept to manage Excel data sheets
* The principle of pivot table
- Create a fancy pivot table and setting up
- Different operation setting in pivot table
- Special functions you need to know in pivot table
* The data analysis exercise in human resource, administration, finance, sales, procurement and manufacture areas
03
Follow-up after seminar
Objectives
Schedules
开课地点： {{city}}
{{selected_activities.duration}} {{selected_activities.city_id}}
我要报名 Recent clients
Duration：{{seminar_duration}}
Price：{{seminar_price | EoFormatPrice}} CNY * per participant
Learning form：
Open Course
In-house
Virtual Classroom
| {{act.duration}} | {{act.city_id}} |
Seminar Inquiry
{{eo_store_model_footer}}
Our Honors
CEGOS MANAGEMENT CONSULTING (SHANGHAI) CO., LTD. Address：Rm 802, B-Tower, No.370, Pudian Road, Pudong, Shanghai
CEGOS BEIJING BRANCH OFFICE Address：7/F Taohui Xintian, 219 Wangfujing Street, Dongcheng, Beijing
CEGOS CHENGDU BRANCH OFFICE Address：13th, Floor, East Tower, Leading Cener, No.3-5, Xiyu Street, Qingyang, Chengdu
Shanghai administration ©2021 - CEGOS CHINA - Privacy Policy