Excel技能樹（五）數(shù)據(jù)可視化

【課程簡介】

詳細介紹工作中常用的數(shù)據(jù)可視化方法。學(xué)完本課程你會理解可視化方法多種多樣，可視化技巧靈活多變。本文除了介紹Excel圖表和條件格式的基本操作方法外，更主要的是詳細介紹了幾十個具體的可視化案例，每一個案例你都可以做成模板，用在未來的工作中。結(jié)合這些案例介紹的可視化思路，讓你也可以獨立設(shè)計巧妙專業(yè)的圖表，提高你工作的專業(yè)度。

【課程目標】

掌握條件格式的正確使用方法；掌握各種常見的圖表制作技巧

【目標人員】

HR，財務(wù)，市場管理等部門的員工；數(shù)據(jù)分析崗位的員工

【學(xué)員基礎(chǔ)】

掌握Excel基礎(chǔ)知識；熟悉Excel常用函數(shù)；

【課程大綱】

第一章 用條件格式進行可視化

1.1   條件格式之數(shù)據(jù)條（免費試聽）                                                        

1.2   條件格式之色階                                                                                         

1.3   條件格式之突出顯示                                                                               

1.4   條件格式之圖標集                                                                                  

1.5   條件格式之兩個列表數(shù)據(jù)對比                                                             

1.6   條件格式之檢查表                                                                                  

1.7   條件格式之交替陰影顯示                                                                     

1.8   條件格式之熱力圖                                                                                    

1.9   條件格式之簡易甘特圖                                                                         

1.10 條件格式之可視化百分比                                                                     

1.11 條件格式規(guī)則的管理                                                                              

第二章 專業(yè)圖表制作

2.1   創(chuàng)建一個圖表                                                                                             

2.2   《柱形、折線、面積、餅圖、復(fù)合餅圖（什么數(shù)什么圖）》  

2.3   《雷達圖、散點圖、象限圖、氣泡（適用的數(shù)據(jù)）》                

2.4   更改圖表類型                                                                                             

2.5   修改圖表數(shù)據(jù)                                                                                            

2.6   修改圖表元素                                                                                             

2.7   分類軸、數(shù)值軸設(shè)置                                                                               

2.8   圖表格式設(shè)置                                                                                            

2.9   圖表系列格式設(shè)置                                                                                  

2.10 餅圖、復(fù)合餅圖                                                                                       

2.11 散點圖相關(guān)                                                                                          

2.12 其他圖表元素                                                                                             

2.13 《雙Y軸多圖表設(shè)置（XY軸設(shè)定）》                                                

2.14 《預(yù)算實際，項目進度（溫度計）體現(xiàn)》                                    

2.15 《商務(wù)圖表數(shù)據(jù)標簽的特殊設(shè)定技巧》                                         

2.16 《多折線，多類型（錯行法）》                                                        

2.17 《分析式圖表（平均線、上下限、高低點）》                           

2.18 《三列數(shù)據(jù)相差懸殊（平板圖）》                                                    

2.19 《手風琴式圖表（項目太多）》                                                        

2.20 《增數(shù)減數(shù)自如（自動縮放式圖表）》                                           

2.21 《關(guān)注最近數(shù)據(jù)情況（最近一周動態(tài)圖表）》                              

2.22 《交互式組合框動態(tài)圖表》                                                                 

2.23 《甘特圖、動態(tài)甘特圖》                                                                      

2.24 《漏斗圖（環(huán)節(jié)轉(zhuǎn)化率關(guān)注）》                                                          

2.25 《旋風圖、雙層餅圖（多項目比例）》                                            

2.26 《瀑布圖（階梯圖）》                                                                         

第三章 數(shù)據(jù)可視化總結(jié)

3.1   什么是專業(yè)圖表                                                                                       

3.2   如何選擇圖表                                                                                            

3.3   圖表制作中的常見錯誤