Excel中級28講

【課程簡介】

這是一門所有使用 Excel的工作人員的必修課，也是所有Excel使用者必須學(xué)習(xí)的唯一一門課程。本課程幫助學(xué)員建立使用Excel工作的正確方法，解決Excel工作“花費時間多”，“速度慢”，“報表錯誤多”，“報表不專業(yè)”等四大問題。

【課程大綱】

第一章，概述                                                                                            

1.1   什么是excel工作的標(biāo)準(zhǔn)模式（免費試聽）                                    

第二章，常用報表有哪些                      

2.1   分段展示報表的實現(xiàn)方法                                                           

2.2   分部門（地區(qū)、類別）報表的快速實現(xiàn)方法                                

2.3   逐月統(tǒng)計類報表的實現(xiàn)方式及日期類數(shù)據(jù)的處理                        

2.4   數(shù)據(jù)占比及增長率等報表的實現(xiàn)方法                                          

2.5   匯總表格中不能直接得到的數(shù)據(jù)                                                  

2.6   在標(biāo)準(zhǔn)模式中自動制作報表                                                         

第三章，函數(shù)的中級應(yīng)用                      

3.1   文本函數(shù)                                                                                    

3.2   身份證相關(guān)問題                                                                          

3.3   日期函數(shù)                                                                                    

3.4   if函數(shù)中的條件                                                                           

3.5   sumif和countif中的條件                                                            

3.6   index函數(shù)                                                                                 

3.7   match函數(shù)                                                                               

3.8   sumproduct函數(shù)                                                                       

3.9   各種查找場景                                                                            

3.10 工作中的日期處理                                                                       

3.11 工作中的時間處理                                                                    

3.12 offset函數(shù)的使用                                                                     

3.13 函數(shù)的綜合應(yīng)用                                                                           

第四章，如何規(guī)范處理源數(shù)據(jù)                      

4.1   源數(shù)據(jù)表規(guī)范                                                                                

4.2   將多個表的數(shù)據(jù)合并到一張表                                                       

4.3   橫表轉(zhuǎn)豎表（逆透視）                                                                   

4.4   重復(fù)數(shù)據(jù)處理                                                                             

4.5   排名問題                                                                                         

第五章，快速制作專業(yè)報表                           

5.1   專業(yè)報表要求與規(guī)范                                                                        

5.2   避免數(shù)據(jù)中的錯誤                                                                        

5.3   數(shù)據(jù)可視化初步