Microsoft Office Trainings

Course Introduction

In modern workplace, the demand for data management and analysis is increasing day by day. As an important member of the OFFICE, with its powerful data processing functions, the application of EXCEL in people’s daily work has become more and more extensive and in-depth.

This course simulates people’s work scenarios and uses a large number of real-life cases to explain the problems and common usage requirements faced by professionals of EXCEL, as well as the shortcomings and blind spots of EXCEL-related applications. The training encourages attendees to fully understand and master the functions and application skills of EXCEL, to meet the diversified data processing needs in daily work, and to greatly improve office efficiency and data processing quality.

Training Content and Goals

1. Excel efficiency skills

• how to quickly move to a specified cell
• how to quickly select a data area
• how to batch modify whole data
• how to batch input data
• recognize the stored and displayed values of data
• how to quickly convert cell formats

2. Application of data analysis and sorting tools

• Pivot Table, a sharp tool for multidimensional and multilevel analysis
• extended usage of Pivot Table
• conditional format to visualize your analysis results
• turn non-standard into standard
• data validation, prefabricated format, my site, I decide
• consolidation calculation allows you to consolidate data with one click
• fill in quickly and let Excel know your mind

Please note: Attendees need to bring a laptop with a working Excel software

Eddic Training Center

Eddic (China) Training Center is China’s leading enterprise-level training service provider and was founded in 2003. Currently, the organization has more than 800 cooperative lecturers, focusing on the enterprise-level training field. Eddic continuously accumulate its expertise from real life business and offers tailor-made training courses and consulting services.