提升數(shù)據(jù)分析能力的Excel超級實踐

1.日常辦公中的Excel數(shù)據(jù)處理
如何高效、規(guī)范地輸入數(shù)據(jù)，并格式化
常用函數(shù)、公式應用
在人事、行政、財務、銷售、采購、生產(chǎn)等方面的數(shù)據(jù)處理要點

2.高效的Excel數(shù)據(jù)管理
用數(shù)據(jù)庫理念對Excel數(shù)據(jù)表單進行管理
整理、排序、篩選、查找、匹配、分類匯總
Excel中的多人協(xié)同工作、共享數(shù)據(jù)
在人事、行政、財務、銷售、采購、生產(chǎn)等方面的不同數(shù)據(jù)管理風格

3.強大的Excel數(shù)據(jù)分析
對不同數(shù)據(jù)表、不同行列進行對比、交叉分析
利用數(shù)據(jù)透視表（圖）進行數(shù)據(jù)匯總分析
利用規(guī)劃求解工具進行決策分析
在人事、行政、財務、銷售、采購、生產(chǎn)等方面的數(shù)據(jù)分析工具

4.豐富的Excel工作報告
利用數(shù)據(jù)透視表（圖）快速創(chuàng)建個性化的動態(tài)圖表
利用各種數(shù)據(jù)表繪制動態(tài)實用圖表
訪問外部數(shù)據(jù)源制作工作報告
在人事、行政、財務、銷售、采購、生產(chǎn)等方面的工作報告樣例

5.Excel的高級應用
利用Excel的高級函數(shù)和公式改善數(shù)據(jù)分析能力
創(chuàng)建自定義函數(shù)和VBA來提高數(shù)據(jù)分析效率
Excel與MS Office其他應用程序的數(shù)據(jù)協(xié)同
Excel的其它高階技巧在實踐中的運用

1. Excel data maintenance in office
How to input and format data effectively
Using 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