☆ 1、如有部分内容理解不透或消化不好，可免费在以后培训班中重听；
      ☆ 2、在课程结束之后,授课老师会留给学员手机和E-mail,免费提供半年的课程技术支持，以便保证培训后的继续消化；
      ☆3、合格的学员可享受免费推荐就业机会。
      ☆4、合格学员免费颁发相关工程师等资格证书，提升您的职业资质。

Knowledge of Windows and MS Excel basics
Excel Data Types
Look up values ​​in a spreadsheet
Naming the range, create a range of labels
Modifying named ranges
Create custom number formats
Use AutoFormat options in a spreadsheet
Create a named style
Creating a user template
Protection sheets
Organizing data in a worksheet
Create a list of data
Adding to the list of series
Creating a custom sort lists
Consolidate data
Create conspect
Processing of data in a spreadsheet
Apply conditional formatting
Summarizing data with subtotals
Filter the list of data
Create a custom filter
Create an advanced filter
Create scenarios
Data Validation
Creating formulas
Aggregation of cell contents using the AutoSum
Adding in the dialog window
Insert Function
Editing formulas
Evaluate Formula
Using Solver tool to obtain specific values ​​of the arguments
Create a conditional formula
Using the data table to solve the formulas
Tracking error performance formulas
Look up values ​​in a particular row or column
Determine the value location
Returning values ​​from a cell in a specific location in the data list
Positioning of the data list
Create a table of credit
The processing of information from external data sources
Combining data from other Windows programs
Importing a delimited text file
Dividing a column of data into multiple columns
Create a Web Query
Importing database table
Using queries to selectively retrieve information from external databases
Calculate the average of the values ​​stored in the database
Produce data charts
Changing the chart type
Creating a custom chart types
Adding a trendline to a chart
Adding new values ​​and change data for the chart
Create a combination chart
Using Pivot Table reports
Basic information about PivotTables
Overview of PivotTable fields.
Create a PivotTable report with a list of data
Change the layout of a PivotTable
Filtering fields
Changing the type of calculation data fields
Grouping PivotTable data elements
Entering additional calculations to the data area
Add a calculated field
Adding a calculated
Get values ​​from a PivotTable report
Creating a PivotChart
Performing the pivot of information from external database
Change the layout of a PivotChart
Changing a PivotChart
Filtering fields PivotChart
Grouping elements PivotChart field
Add a table of data to the PivotChart