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

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

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

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

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

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


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