Excel中級28講

【課程簡介】

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

【課程大綱】

第一章，概述                                                                                            

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

第二章，常用報(bào)表有哪些                      

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

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

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

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

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

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

第三章，函數(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 工作中的時(shí)間處理                                                                    

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è)報(bào)表                           

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

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

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