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

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

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

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

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

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


1. Excel data maintenance in office
How to input and format data effectively
Common functions and formulas
Keys of data maintenance in human resources, administration, finance, sales, procurement and manufacture areas

2. Efficient Excel data management
Using database concept to manage Excel data sheets
Data sorting, filtering, finding, matching and subtotals
Excel collaboration with other people, sharing data and information
Different styles of data management in human resources, administration, finance, sales, procurement and manufacture areas

3. Powerful Excel data analysis
Analyzing and matching different sheets, columns, rows
Using pivot tables to analyze data
Using solver tools for decision analysis
The data analysis tools in human resources, administration, finance, sales, procurement and 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 resources, administration, finance, sales, procurement and manufacture areas

5. Excel advanced tips
Using Excel advanced functions and formulas to improve the ability of data analysis
Custom functions and VBA
Excel data collaboration with other office applications
Other Excel applications