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

【課程簡介】

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

【課程目標】

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

【目標人員】

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

【學員基礎】

掌握Excel基礎知識；熟悉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   《柱形、折線、面積、餅圖、復合餅圖（什么數(shù)什么圖）》  

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

2.4   更改圖表類型                                                                                             

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

2.6   修改圖表元素                                                                                             

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

2.8   圖表格式設置                                                                                            

2.9   圖表系列格式設置                                                                                  

2.10 餅圖、復合餅圖                                                                                       

2.11 散點圖相關                                                                                          

2.12 其他圖表元素                                                                                             

2.13 《雙Y軸多圖表設置（XY軸設定）》                                                

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

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

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

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

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

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

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

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

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

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

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

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

2.26 《瀑布圖（階梯圖）》                                                                         

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

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

3.2   如何選擇圖表                                                                                            

3.3   圖表制作中的常見錯誤