課時(shí)01.前言X.flv
課時(shí)02.七天的工作如何能一天完成X.flv
課時(shí)03.快速處理數(shù)據(jù)實(shí)戰(zhàn)案例X.flv
課時(shí)04.低效表格案例分析.flv_d.flv
課時(shí)05.財(cái)務(wù)職場表格的分類及設(shè)計(jì).flv_dX.flv
課時(shí)06.這樣設(shè)計(jì)表格工作效率就是高.flv_d.flv
課時(shí)07.基礎(chǔ)數(shù)據(jù)十宗罪處理（1）.flv_dX.flv
課時(shí)08.基礎(chǔ)數(shù)據(jù)十宗罪處理（2）.flv_d.flv
課時(shí)09.四表工作流程讓效率飛起來.flv
課時(shí)10.制作一個(gè)不會(huì)錯(cuò)的集團(tuán)下發(fā)表格.flv_d.flv
課時(shí)11.如何引入ERP數(shù)據(jù)進(jìn)行二次處理X.flv
課時(shí)12.如何處理ERP不規(guī)范數(shù)據(jù).flv_d.flv
課時(shí)13.如何實(shí)現(xiàn)多張表格關(guān)聯(lián)查詢.flv_dX.flv
課時(shí)14.不打開文件也可以做數(shù)據(jù)分析.flv_d.flv
課時(shí)15.一分鐘核對數(shù)據(jù)大法-合并計(jì)算法1X.flv
課時(shí)16.一分鐘核對數(shù)據(jù)大法-公式法.flv_d.flv
課時(shí)17.一分鐘核對數(shù)據(jù)大法-快捷鍵法和選擇性粘貼法.flv_dX.flv
課時(shí)18.如何一眼看出需要關(guān)注的數(shù)據(jù).flv_d.flv
課時(shí)19.高級(jí)篩選的7個(gè)高能玩法（1）.flv_dX.flv
課時(shí)20.高級(jí)篩選的7個(gè)高能玩法（2）.flv_d.flv
課時(shí)21.八個(gè)步驟掌握百分之九十的數(shù)據(jù)透視功能（1）X.flv
課時(shí)22.八個(gè)步驟掌握百分之九十的數(shù)據(jù)透視功能（2）.flv_d.flv
課時(shí)23.八個(gè)步驟掌握百分之九十的數(shù)據(jù)透視功能（3）.flv_d.flv
課時(shí)24.八個(gè)步驟掌握百分之九十的數(shù)據(jù)透視功能（4）.flv_dX.flv
課時(shí)25.多表匯總分析（1）-12個(gè)月部門成本費(fèi)用表匯總.flv_d.flv
課時(shí)26.多表匯總分析（2）-24個(gè)月部門成本費(fèi)用表匯總及三年銷售數(shù)據(jù)匯總.flv_d.flv
課時(shí)27.對外上報(bào)表格還原成基礎(chǔ)數(shù)據(jù)表格.flv_dX.flv
課時(shí)28.綜合應(yīng)用實(shí)戰(zhàn)案例.flv_d.flv
課時(shí)29.函數(shù)用不好天天加班少不了.flv
課時(shí)30.函數(shù)使用打基礎(chǔ)（注意事項(xiàng)-三大格式-絕對和相對引用）.flv_dX.flv
課時(shí)31.利用名稱制作智能報(bào)銷單.flv_d.flv
課時(shí)32.條件判斷函數(shù)（績效測算-付款方案判斷-電商應(yīng)用實(shí)戰(zhàn)）.flv_d.flv
課時(shí)33.日期函數(shù)1（計(jì)算年齡-計(jì)算賬齡-提示合同到期日）.flv_dX.flv
課時(shí)34.日期函數(shù)2-提示員工勞務(wù)合同續(xù)簽日.flv_d.flv
課時(shí)35.文本函數(shù)-快速提取地址及會(huì)計(jì)科目編碼等.flv_d.flv
課時(shí)36.文本函數(shù)-自定義分析及警示模板基礎(chǔ).flv_dX.flv
課時(shí)37.統(tǒng)計(jì)函數(shù)-SUMIF(S)做一張靈活的銷售業(yè)務(wù)統(tǒng)計(jì)表.flv_d.flv
課時(shí)38.匯總函數(shù)(1)-SUMIF(S)單條件和多條件求和.flv_dX.flv
課時(shí)39.匯總函數(shù)(2)-SUMIF(S)間隔求和和明細(xì)賬取數(shù).flv_d.flv
課時(shí)40.查找引用函數(shù)(1)VLOOKUP員工信息查詢表-利潤簡表-個(gè)所稅快速計(jì)算.flv_dX.flv
課時(shí)41.查找引用函數(shù)(2)-MATCH動(dòng)態(tài)門店業(yè)務(wù)查詢報(bào)表.flv_d.flv
課時(shí)42.查找引用函數(shù)(3)-INDEX兩條件查找和最新報(bào)價(jià)查詢.flv_dX.flv
課時(shí)43.查找引用函數(shù)(4)-INDIRECT多表一秒?yún)R總.flv_d.flv
課時(shí)44.查找引用函數(shù)(5)-OFFSET高級(jí)查詢函數(shù)技能.flv_dX.flv
課時(shí)45.查找引用函數(shù)(6)-OFFSET制作動(dòng)態(tài)分析模板.flv_d.flv
課時(shí)46.公式錯(cuò)誤處理及批量修改保護(hù)公式.flv_dX.flv
課時(shí)47.多個(gè)結(jié)構(gòu)相同表格的合并-10個(gè)公司利潤表合并（公式法）.flv
課時(shí)48.多個(gè)結(jié)構(gòu)相同表格的合并-10個(gè)公司稅負(fù)統(tǒng)計(jì)表合并（合并計(jì)算法）.flv_d.flv
課時(shí)48.多個(gè)結(jié)構(gòu)相同表格的合并-10個(gè)公司稅負(fù)統(tǒng)計(jì)表合并（合并計(jì)算法）.flv_dX.flv
課時(shí)49.多個(gè)結(jié)構(gòu)相同表格的合并-多月工資表的快速匯總（數(shù)據(jù)透視法）.flv_d.flv
課時(shí)50.多個(gè)結(jié)構(gòu)不同表格的合并-多個(gè)公司業(yè)務(wù)統(tǒng)計(jì)表合并（數(shù)據(jù)透視法）.flv_d.flv
課時(shí)50.多個(gè)結(jié)構(gòu)不同表格的合并-多個(gè)公司業(yè)務(wù)統(tǒng)計(jì)表合并（數(shù)據(jù)透視法）.flv_dX.flv
課時(shí)51.多個(gè)結(jié)構(gòu)不同表格的合并-多月成本費(fèi)用表合并（數(shù)據(jù)透視法）.flv_d.flv
課時(shí)52.多個(gè)工作簿的合并-合并財(cái)務(wù)報(bào)表實(shí)戰(zhàn)-INDIRECT法.flv_d.flv
課時(shí)52.多個(gè)工作簿的合并-合并財(cái)務(wù)報(bào)表實(shí)戰(zhàn)-INDIRECT法.flv_dX.flv
課時(shí)53.多個(gè)工作簿的合并-合并財(cái)務(wù)報(bào)表實(shí)戰(zhàn)-替換公式法.flv_d.flv
課時(shí)54.怎樣按照數(shù)據(jù)關(guān)系選擇圖表.flv
課時(shí)54.怎樣按照數(shù)據(jù)關(guān)系選擇圖表X.flv
課時(shí)55.圖表元素構(gòu)成說明.flv_d.flv
課時(shí)56.第一張專業(yè)圖表的制作.flv_d.flv
課時(shí)56.第一張專業(yè)圖表的制作.flv_dX.flv
課時(shí)57.如何建立專業(yè)圖表顏色庫.flv_d.flv
課時(shí)58.雙軸柱形圖-展現(xiàn)預(yù)算完成進(jìn)度.flv_dX.flv
課時(shí)59.條形圖-整齊排名輪業(yè)績.flv_d.flv
課時(shí)60.餅圖和環(huán)形圖-項(xiàng)目比重看的清.flv_d.flv
課時(shí)61.折線圖-趨勢分析要做透.flv_dX.flv
課時(shí)62.瀑布圖-差異原因弄清楚.flv_d.flv
課時(shí)63.旋風(fēng)圖-財(cái)務(wù)指標(biāo)對比清.flv_d.flv
課時(shí)64.儀表盤-商務(wù)氣息就靠它.flv_dX.flv
課時(shí)65.動(dòng)態(tài)圖表（1）-控件的基本使用方法.flv_d.flv
課時(shí)66.動(dòng)態(tài)圖表（2）-讓圖表的所有元素都動(dòng)起來.flv_d.flv
課時(shí)67.動(dòng)態(tài)圖表（3）-選項(xiàng)按鈕讓對比看的清.flv_d.flv
課時(shí)67.動(dòng)態(tài)圖表（3）-選項(xiàng)按鈕讓對比看的清.flv_dX.flv
課時(shí)68.動(dòng)態(tài)圖表（4）-用列表框做數(shù)據(jù)查詢器.flv_d.flv
課時(shí)69.利潤監(jiān)控儀表板的制作.flv_d.flv
課時(shí)70.如何做好公司財(cái)務(wù)分析X.flv
課時(shí)71.經(jīng)營分析會(huì)決策模型制作實(shí)操.flv_d.flv
課時(shí)72.利潤影響因素決策模型制作實(shí)操.flv_d.flv
課時(shí)73.一鍵測算目標(biāo)利潤模型制作實(shí)操.flv_dX.flv
課時(shí)74.管理者駕駛艙基礎(chǔ)概念.flv_d.flv
課時(shí)75.管理者駕駛艙的制作步驟.flv_d.flv
課時(shí)76.管理者駕駛艙具體實(shí)操（1）.flv_d.flv
課時(shí)77.管理者駕駛艙具體實(shí)操（2）.flv_d.flv
課時(shí)78.管理者駕駛艙具體實(shí)操（3）.flv_d.flv
課時(shí)79.word版本自動(dòng)分析模板的制作.flv_d.flv
課時(shí)80.經(jīng)營分析會(huì)PPT的制作.flv_d.flv
課時(shí)81.企業(yè)登記的變化.flv_d.flv
課時(shí)82.發(fā)票管理及風(fēng)險(xiǎn)管控.flv_d.flv
課時(shí)83.費(fèi)用報(bào)銷那些事兒.flv
