国产极品粉嫩福利姬萌白酱_伊人WWW22综合色_久久精品a一国产成人免费网站_法国啄木乌AV片在线播放

全國 [城市選擇] [會員登錄] [講師注冊] [機構注冊] [助教注冊]  
中國企業培訓講師
Excel實戰技能高級篇
 
講師(shi):代國強 瀏覽次數(shu):2575

課程描(miao)述INTRODUCTION

Excel實戰

· 其他人員· 新晉主管· 中層領導· 儲備干部· 財務主管

培訓講師:代國強    課程價格:¥元/人    培訓天數:2天   

日程安(an)排SCHEDULE

課程大綱(gang)Syllabus

Excel實戰

課程背景
隨著大數據時代的帶來,數據越來越成為企業最寶貴的資源。但是很多企業卻沒有深入的挖掘隱藏在數據背后的經營管理信息,使得數據資產沒有發揮應有的價值。本課程的主要目的在于提高學員的數據分析技巧,培養學員通過數據分析得出經營管理信息的技能,為科學決策打下堅實的基礎。
課程對象
適合于各個層(ceng)級的(de)員工

課程大綱
模塊一、使用Excel函數對數據進行處理

【教學目的】函數是Excel經典功能之一,也是學習Excel的一個難點。本模塊通過講解最常用的函數,解決最常見的數據分析問題,同時起到拋磚引玉的作用,讓學生有思路學習其他工作中常遇到的函數。
1. 數據的引用(*引用、相對引用、混合引用)
2. 使用VLOOKUP實現*查找
3. 使用VLOOKUP實現模糊查找
4. INDIRECT+MATCH組合函數實現查找
5. 使用OFFSET+MATCH函數實現二維查找
6. 使用INDIRECT實現文本查找
7. SUMIF,SUMIFS條(tiao)件求和的運用

模塊二、使用Excel數據透視表對數據進行快速匯總
【教學目的】毫不夸張的說,數據透視表是Excel最重要的功能,該工具可以立體化的分析數據,多維度的觀察分析數據,是工作中最實用、并且很易用的工具,學員務必掌握。
1. 數據透視表結構介紹
2. 制作基本的數據透視表
3. 結構百分比、環比、環比百分比報表的制作
4. 使用計算字段與計算項工具挖掘數據深層次關系
5. 動態數據透視表的制作
6. 利用數(shu)據透(tou)視表實現應(ying)收賬(zhang)款(kuan)賬(zhang)齡分析

模塊三、數據分析第四步——使用Excel條件格式提示異常數據值
【教學目的】條件格式可以使得滿足一定管理要求的數據更加醒目的呈現出來,使得管理者更快的找到數據異常值,鎖定分析重點。
1. 使用條件格式工具實現應收賬款管理
2. 利用控件技術實現自定義條件格式
【案例】使用條件格式實現(xian)應收賬款管理(li)

模塊四、運用Excel圖表呈現數據分析結果
【教學目的】合理的選擇Excel圖表可以使得數據的呈現更加生動,提高數據的可讀性。本模塊的目的在于講解常見的商務圖表。
1. 使用雙Excel雙坐標圖表達不同量級的數據
2. 使用Excel雷達圖表達多指標比較信息
3. 使用Excel瀑布圖變量的變化過程
4. 使用Excel甘特(te)圖表達項目計劃

講師介紹
代國強老師

  上海財經大學公共管理學院研究生特聘講師
  中國注冊會計師(CPA)高級講師
  *注冊管理會計師(CMA)高級講師
  Excel財務管理應用實戰家
  Excel生產管理應用實戰家
  Excel VBA建模應用實戰家
  Excel+PPT職場(chang)技能培訓講師(shi)

【背景介紹】
1、職場經驗:
近5年美資企業財務管理經驗,包括預算管理、業績評價、投資決策分析等模塊。
參與格雷斯(中國)實施2個ERP設計、格雷斯(中國)財務信息系統建設,積累了一手的項目管理與信息系統建設的經驗。熟悉制造型企業的財務、采購、生產管理流程。
曾經為世界500強公司提供完整的VBA數據分析解決方案。
2、 學歷及教育背景:
同濟大學      財務管理學 本科
上海(hai)財經大(da)學  經濟學   ;  碩士(shi)

【專業強項】
1. 擅長從管理的角度講解課程內容,能夠把課程很好的與管理結合起來,而不是枯燥的講技術操作;
2. 來自企業一線的豐富實戰案例供學生借鑒,能夠以解決問題的方式設計課程;
3. 精通教練技術,能夠在課堂中營造實戰場景,善于提問,引導學生的思考,現場解決管理中存在的疑難雜癥;
4. 出色的表達能力,講課邏輯清晰,能夠幫助學生抽絲剝繭,掌握課程脈絡;
5. 近5年的(de)基于Excel的(de)數據分析培(pei)訓(xun)(xun)經驗(yan),5年注冊會計師培(pei)訓(xun)(xun)經驗(yan)。知識面廣,不僅僅講(jiang)授(shou)Office的(de)操(cao)作,而且可以結合客戶的(de)管(guan)理實際,設計出結合管(guan)理的(de)Office數據分析課(ke)程(cheng)。上課(ke)思路清(qing)晰,耐(nai)心對待每一位學員,學員滿意度到達(da)95%。

【服務客戶】
拜耳制(zhi)藥、樂購、阿(a)克蘇諾(nuo)貝(bei)爾、貝(bei)卡爾特(te)(te)(te)、愛(ai)普森、吉(ji)田拉鏈(YKK)、喜來(lai)登(deng)酒店、奧美廣告、巴(ba)魯夫(fu)(上(shang)(shang)(shang)海(hai)(hai))貿易、大(da)金(jin)(jin)空調、萊福康、范斯特(te)(te)(te)侖、上(shang)(shang)(shang)菱電(dian)(dian)器、煙草集(ji)(ji)(ji)團(tuan)(tuan)、電(dian)(dian)信實(shi)業、信誠科(ke)(ke)(ke)(ke)技(ji)(ji)(ji)(ji)(ji)、華(hua)普科(ke)(ke)(ke)(ke)技(ji)(ji)(ji)(ji)(ji)、華(hua)鑫(xin)證券、中(zhong)(zhong)(zhong)富證券、震旦投(tou)資、重慶師范大(da)學、海(hai)(hai)南贊邦制(zhi)藥有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、金(jin)(jin)煤控(kong)股(gu)(gu)(gu)集(ji)(ji)(ji)團(tuan)(tuan)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、英特(te)(te)(te)矽(xi)爾(武(wu)(wu)漢)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、寧波勝維德(de)赫華(hua)翔汽(qi)(qi)車(che)鏡有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、蘇州(zhou)(zhou)旭創(chuang)科(ke)(ke)(ke)(ke)技(ji)(ji)(ji)(ji)(ji)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、中(zhong)(zhong)(zhong)海(hai)(hai)油(you)能源發展(zhan)上(shang)(shang)(shang)海(hai)(hai)人力資源服(fu)務分公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、金(jin)(jin)煤控(kong)股(gu)(gu)(gu)集(ji)(ji)(ji)團(tuan)(tuan)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、交(jiao)銀(yin)康聯人壽(shou)保險(xian)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、成都雙流國際(ji)機場航(hang)(hang)空地面服(fu)務有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、大(da)眾(zhong)汽(qi)(qi)車(che)變(bian)速器(上(shang)(shang)(shang)海(hai)(hai))有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、重慶師范大(da)學、上(shang)(shang)(shang)海(hai)(hai)來(lai)伊份股(gu)(gu)(gu)份有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、博(bo)戈橡膠(jiao)金(jin)(jin)屬(上(shang)(shang)(shang)海(hai)(hai))有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、東電(dian)(dian)光電(dian)(dian)半導體設備(昆山)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、上(shang)(shang)(shang)海(hai)(hai)欣坤服(fu)飾(shi)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、上(shang)(shang)(shang)海(hai)(hai)市信息管(guan)線有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、琳得(de)科(ke)(ke)(ke)(ke)膠(jiao)膜科(ke)(ke)(ke)(ke)技(ji)(ji)(ji)(ji)(ji)(上(shang)(shang)(shang)海(hai)(hai))有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、上(shang)(shang)(shang)海(hai)(hai)精吉(ji)通(tong)訊(xun)技(ji)(ji)(ji)(ji)(ji)術有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、儒拉瑪特(te)(te)(te)、福伊特(te)(te)(te)工(gong)業技(ji)(ji)(ji)(ji)(ji)術有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、上(shang)(shang)(shang)海(hai)(hai)源耀生物股(gu)(gu)(gu)份有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、石家莊科(ke)(ke)(ke)(ke)迪(di)醫藥經銷有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、巨化集(ji)(ji)(ji)團(tuan)(tuan)技(ji)(ji)(ji)(ji)(ji)術中(zhong)(zhong)(zhong)心、伽藍(集(ji)(ji)(ji)團(tuan)(tuan))股(gu)(gu)(gu)份有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、蘇州(zhou)(zhou)優帕特(te)(te)(te)企業管(guan)理咨詢有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、西(xi)藏奇正藏藥股(gu)(gu)(gu)份有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、歐(ou)萊雅(ya)、學大(da)教育集(ji)(ji)(ji)團(tuan)(tuan)、伍爾特(te)(te)(te)(中(zhong)(zhong)(zhong)國)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、雅(ya)馬(ma)哈動力機械(江蘇)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、諾(nuo)華(hua)賽分離技(ji)(ji)(ji)(ji)(ji)術(上(shang)(shang)(shang)海(hai)(hai))有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、杭州(zhou)(zhou)尚盈(ying)服(fu)飾(shi)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、平安銀(yin)行、上(shang)(shang)(shang)海(hai)(hai)長征富民金(jin)(jin)山制(zhi)藥有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、贊奇科(ke)(ke)(ke)(ke)技(ji)(ji)(ji)(ji)(ji)發展(zhan)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、無錫電(dian)(dian)裝汽(qi)(qi)車(che)部件有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、萬向A一二(er)三系(xi)統(tong)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、寧波艾思科(ke)(ke)(ke)(ke)汽(qi)(qi)車(che)音(yin)響通(tong)訊(xun)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、上(shang)(shang)(shang)海(hai)(hai)航(hang)(hang)天科(ke)(ke)(ke)(ke)技(ji)(ji)(ji)(ji)(ji)集(ji)(ji)(ji)團(tuan)(tuan)第(di)八研究院、嘉興真功夫(fu)農產品(pin)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、上(shang)(shang)(shang)海(hai)(hai)錦湖日麗塑(su)料有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、思琳商貿(上(shang)(shang)(shang)海(hai)(hai))有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、中(zhong)(zhong)(zhong)國外(wai)匯(hui)交(jiao)易中(zhong)(zhong)(zhong)心、上(shang)(shang)(shang)海(hai)(hai)艾仕國際(ji)貿易有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、中(zhong)(zhong)(zhong)國移動、荷貝(bei)克電(dian)(dian)源系(xi)統(tong)(武(wu)(wu)漢)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、深(shen)圳(zhen)欣銳科(ke)(ke)(ke)(ke)技(ji)(ji)(ji)(ji)(ji)股(gu)(gu)(gu)份有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、深(shen)圳(zhen)紫金(jin)(jin)支點(dian)技(ji)(ji)(ji)(ji)(ji)術股(gu)(gu)(gu)份有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、CMS招商證券、大(da)眾(zhong)汽(qi)(qi)車(che)變(bian)速器(上(shang)(shang)(shang)海(hai)(hai))有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、蘇州(zhou)(zhou)工(gong)業園區金(jin)(jin)雞湖農村(cun)小額貸(dai)款(kuan)有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、艾思科(ke)(ke)(ke)(ke)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)、中(zhong)(zhong)(zhong)國電(dian)(dian)信股(gu)(gu)(gu)份有(you)(you)(you)(you)(you)(you)(you)(you)限(xian)(xian)(xian)(xian)公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)上(shang)(shang)(shang)海(hai)(hai)分公(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)(gong)司(si)(si)(si)(si)(si)(si)

Excel實戰


轉載://citymember.cn/gkk_detail/28708.html

已(yi)開課(ke)時間Have start time

在線(xian)報(bao)名Online registration

    參(can)加(jia)課程:Excel實戰技能高級篇

    單(dan)位名稱:

  • 參(can)加日(ri)期(qi):
  • 聯系人(ren):
  • 手機號碼:
  • 座機(ji)電話(hua):
  • QQ或微信:
  • 參(can)加人數:
  • 開票(piao)信(xin)息:
  • 輸入(ru)驗證(zheng):  看不清楚?點擊驗證碼刷新
付款信息:
開戶名:上海投智企業管理咨詢有限公司
開戶行:中國銀行股份有限公司上海市長壽支行
帳號:454 665 731 584