1. Excel data maintenance in office
* How to input and format data effectively
* Common functions and formulas
* The keys of data maintenance in human resource, administration, finance, sales, procurement, manufacture areas
 
2. Efficient Excel data management
* Using database concept to manage Excel data sheets
* Data sorting, filtering, finding, matching, subtotals
* Excel collaboration with other people, sharing data and information
* Different styles of data management in human resource, administration, finance, sales, procurement, manufacture areas

3. Powerful Excel data analysis
* Analyzing and matching different sheets, columns, rows 
* Using pivot tables to analyze data
* Using solver tools to decision analysis
* The data analysis tools in human resource, administration, finance, sales, procurement, manufacture areas 

4. Abundant Excel work reports
* Using pivot tables to create personalized dynamic diagrams
* Using different data sheets to create practical charts
* Visiting external data to make work reports
* Work report templates in human resource, administration, finance, sales, procurement, manufacture areas

5. Excel advanced tips
* Using Excel advanced functions and formulas to improve the ability of data analysis
* Creating user - defined functions to improve the efficiency of data analysis
* Excel data collaboration with other office applications
* Other Excel applications