我要預(yù)訂

咨詢電話：027-5111 9925 , 027-5111 9926手機(jī)：18971071887郵箱：Service@mingketang.com

課程背景

本課程根據(jù)企業(yè)實(shí)際工作場景，專門為業(yè)務(wù)人員量身定制。課程將涉及專業(yè)數(shù)據(jù)處理、數(shù)據(jù)建模、數(shù)據(jù)分析方法、專業(yè)級報表的制作方法、如何美化與優(yōu)化報表的外等，并介紹企業(yè)數(shù)據(jù)報表中的常用數(shù)據(jù)處理技巧、函數(shù)等技術(shù)。通過本課程的學(xué)習(xí)，將了解Excel 在數(shù)據(jù)處理和分析工作中的使用方法和技巧，全面提升工作人員的數(shù)據(jù)分析能力。

課程收獲

數(shù)據(jù)處理與分析：學(xué)習(xí)專業(yè)的數(shù)據(jù)處理方法

數(shù)據(jù)建模技巧：掌握使用Excel進(jìn)行數(shù)據(jù)建模的方法和技巧

專業(yè)級報表制作：掌握如何制作專業(yè)級的報表

常用數(shù)據(jù)處理技巧與函數(shù)：掌握企業(yè)數(shù)據(jù)報表中常用的數(shù)據(jù)處理技巧和函數(shù)

課程大綱

1.如何理解數(shù)據(jù)

1.1.常用數(shù)據(jù)指標(biāo)有哪些

1.2.如何選擇指標(biāo)

1.3.明確問題

2.數(shù)據(jù)分析四步法

2.1.獲取和清洗數(shù)據(jù)

2.2.數(shù)據(jù)建模

2.3.數(shù)據(jù)分析

2.4.數(shù)據(jù)可視化

3.高級操作技巧

3.1.分列與快速填充

3.2.突出顯示數(shù)據(jù)的條件格式

3.3.保證錄入數(shù)據(jù)準(zhǔn)確的數(shù)據(jù)驗(yàn)證

4.常用函數(shù)解析

4.1.公式與基礎(chǔ)函數(shù)

4.2.統(tǒng)計求和家族: Sum, Sumif, Sumifs, Count, Countif, Countifs

4.3.邏輯查找函數(shù): Vlookup，Xlookup, Match, Index, Offset等

5.自動獲取和清洗數(shù)據(jù)

5.1.數(shù)據(jù)自動處理

5.2.比Vlookup更厲害的合并查詢

5.3.自動合并多表的追加查詢

5.4.自動合并工作簿

5.5.自動合并文件夾

5.6.自動更新分組

5.7.數(shù)據(jù)排序和篩選

5.8.連接動態(tài)數(shù)據(jù)透視表

6.數(shù)據(jù)建模

6.1.創(chuàng)建日期維度表

6.2.星形模型

6.3.雪花模型

6.4.創(chuàng)建數(shù)據(jù)透視表源

7.數(shù)據(jù)分析

7.1.創(chuàng)建來自數(shù)據(jù)模型的數(shù)據(jù)透視表

7.2.更改值匯總依據(jù)和匯總方式

7.3.創(chuàng)建環(huán)比和同比

7.4.更改透視表布局

7.5.添加切片器

7.6.切片器控制多圖

8.如何分析數(shù)據(jù)

8.1.數(shù)據(jù)分析四層次

8.2.RFM分析法

8.3.相關(guān)性分析法

8.4.邏輯樹分析法

8.5.其它分析法

9.數(shù)據(jù)可視化看板制作

9.1.看板設(shè)計規(guī)則

9.2.看板色彩搭配原則

9.3.圖表三大誤區(qū)

9.4.專業(yè)圖表五大特征

9.5.創(chuàng)意折線圖、柱形圖和比例圖

9.6.控件圖表制作

晏老師

晏艷 Grace老師簡介

AIGC專家

微軟認(rèn)證講師（MCT）

微軟金牌合作伙伴講師

微軟365系列中英雙語講師

微軟Office國際大師認(rèn)證

微軟Power BI、PPT、 Excel、Word國際認(rèn)證專家（全球Word唯一滿分獲得者）

自媒體“Office女神”創(chuàng)辦人

Grace Yan is a seasoned AIGC expert, a Microsoft Certified Trainer (MCT), and a Microsoft Gold Partner Instructor. She also serves as a bilingual (Chinese and English) instructor for the Microsoft 365 products. Holding multiple professional certifications from Microsoft, she has earned the distinction of being a Microsoft Office Master, as well as a certified specialist in Microsoft Power BI, PowerPoint, Excel, and Word (with a perfect mark in Microsoft Office Word certification exam). Furthermore, Grace is the founder of the self-media platform "Office Goddess".

資歷優(yōu)勢

曾任全球前10強(qiáng)外企內(nèi)部培訓(xùn)講師，知名世界500強(qiáng)外企從業(yè)經(jīng)歷（戴爾、雪佛龍和保樂力加），多家500強(qiáng)企業(yè)AIGC及微軟365系列（包括 Excel、PPT、Word、Power BI、Teams、SharePoint、OneDrive for Business、Forms、Outlook、Loop等）培訓(xùn)授課經(jīng)驗(yàn)，長期為客戶和學(xué)員解決實(shí)際應(yīng)用問題，線下受眾學(xué)員100,000人以上，課程培訓(xùn)語種——中英雙語教學(xué)（英語專業(yè)八級，聽說讀寫譯流利）。

She has served as an internal training instructor for a top 10 global multinational corporation, with extensive experience working at renowned Fortune 500 companies including Dell, Chevron, and Pernod Ricard. Possesses a wealth of training experience in AIGC and the Microsoft 365 products for many Fortune 500 enterprises, covering applications such as Excel, PowerPoint, Word, Power BI, Teams, SharePoint, OneDrive for Business, Forms, Outlook, Loop and so on. Over the years, she has consistently addressed practical application issues for clients and trainees, reaching more than 100,000 trainees offline. Her training is delivered bilingually both in Chinese and English (TEM8). Grace is also fluency in listening, speaking, reading, writing, and translation.

授課風(fēng)格

作為AIGC深度研究專家和10余年Office軟件深度用戶，晏老師擁有多年500強(qiáng)外企工作經(jīng)驗(yàn)，能準(zhǔn)確挖掘企業(yè)培訓(xùn)需求，快速幫助學(xué)員提高Office技能；課程結(jié)構(gòu)條例清晰，課程案例吻合工作需要；授課風(fēng)格生動有趣，善于調(diào)動學(xué)員積極性，深受學(xué)員喜歡和好評。

As an expert in AIGC and with over a decade of extensive experience in Office software, Grace possesses a wealth of corporate experience within Fortune 500 companies, enabling her to accurately identify enterprise’s training needs. She is good at enhancing students' Office skills by customized training. Grace, being adept at motivating trainees, is very popular among trainees and enjoys good feedback from trainees.

主講課程

《AI智能辦公：從0到1 訓(xùn)練AI超級助手》

《Excel數(shù)據(jù)分析與決策支持》

《Power BI數(shù)據(jù)分析和可視化看板》

《PPT大師課——PPT設(shè)計與演講力》

部分服務(wù)客戶

1.1部分客戶Clients

制造業(yè)：康明斯（北京、武漢、西安、重慶、十堰）、現(xiàn)代汽車、索尼（大連、上海）、中國船舶重慶、日立電梯廣州、國際航空維修、鞍鋼（大連、成都）、大眾天津、東電化上海、西門子北京、空氣產(chǎn)品、丹佛斯天津、長春一汽、神鋼建機(jī)成都、沃爾沃汽車成都、西安印鈔、當(dāng)納利印刷等。

Manufacturing: Cummins (Beijing, Wuhan, Xi'an, Chongqing, Shiyan), Hyundai Motor, Sony (Dalian, Shanghai), China Shipbuilding (Chongqing), Hitachi Elevator (Guangzhou), International Aviation Maintenance, Ansteel (Dalian, Chengdu), Volkswagen Tianjin, TDK Shanghai, Siemens Beijing, Air Products, Danfoss Tianjin, FAW Changchun, Kobelco Construction Machinery Chengdu, Volvo Cars Chengdu, Xi'an Banknote Printing, RR Donnelley Printing, etc.

?能源行業(yè)：國家電網(wǎng)（北京、石家莊、保定、蘭州、慶陽等）、中國石油（西南分公司、天然氣項(xiàng)目、硫磺項(xiàng)目、頁巖氣項(xiàng)目、重慶氣礦）、長慶石油第二采油廠、雪佛龍能源、涼山礦業(yè)、力量煤業(yè)、英國石油、中國華能、中國電建、中國核動力研究院、大川電力等。

?Energy: State Grid (Beijing, Shijiazhuang, Baoding, Lanzhou, Qingyang, etc.), CNPC (Southwest Branch, CDB Project, Sulfur Project, Shale Gas Project, Chongqing Gas Field), Changqing Petroleum Exploration and Th 2ndProduction Plant, Chevron Energy, Liangshan Mining, Power Coal Industry, BP, China Huaneng, China Energy Engineering Corporation, China Nuclear Power Research Institute, Daguan Electric Power, etc.

?建筑行業(yè)：中建八局西南分公司、中建八局華中分公司、中國中鐵西南院、保利地產(chǎn)、中糧、貴州路橋、重慶高速、重慶路威等。

Construction: CSCEC 8th Bureau Southwest Branch, CSCEC Eighth Bureau Central China Branch, CREC Southwest Academy, Poly Real Estate, COFCO, Guizhou Road & Bridge Co., Ltd., Chongqing Expressway Group, Chongqing Luwei Highway, etc.

金融行業(yè)：摩根大通、澳新銀行、浦發(fā)銀行、招商銀行、四川銀行、楷博財經(jīng)、利比投資、中業(yè)投資等。

Financial: JPMorgan Chase, ANZ Bank, SPD Bank, China Merchants Bank, Sichuan Bank, Kaplan Financial, Libra Investments, Zhongye Investment, etc.

教育行業(yè)：清華大學(xué)、復(fù)旦大學(xué)、浙江財經(jīng)大學(xué)、上海美國學(xué)校、西南財經(jīng)大學(xué)、電子科大成都研究院、新東方前途出國等。

Education: Tsinghua University, Fudan University, Zhejiang University of Finance & Economics, Shanghai American School, Southwestern University of Finance and Economics, University of Electronic Science and Technology of China Chengdu Research Institute, New Oriental Overseas, etc.

IT行業(yè)：華為、微軟中國、惠普、戴爾、北京智慧星光、上北智信等。

IT: Huawei, Microsoft China, HP, Dell, Beijing Zhishiguang Technology, SharewinfoTechnology, etc.

保險行業(yè)：中意人壽、大都會人壽、安盛天平財產(chǎn)保險等。

Insurance: Generali China Life Insurance, MetLife, AXA Tianping Property Insurance, etc.

醫(yī)療行業(yè)：中國生物制藥、勃格林殷格翰、協(xié)和麒麟（中國）制藥、上海國際醫(yī)學(xué)園區(qū)、上海雷度米特等。

Healthcare: China Biotech Pharmaceutical, Boehringer Ingelheim, Kyowa Kirin (China) Pharmaceutical, Shanghai International Medical Park, Shanghai Radiometer Medical, etc.

快消行業(yè)：茅臺集團(tuán)、保樂力加、威肯、重慶國金等。

FMCG: Moutai Group, Pernod Ricard, Waken Bhd., Chongqing Golden Resources Group, etc.

其它行業(yè)：四川機(jī)場集團(tuán)、西南美商會、上海美商會、歐盟商會、新蛋科技、天津大眾、丹納赫(上海)、上海泰克科技、加納海威、空港大酒店、成都地鐵、泰和泰律師事務(wù)所、嘉納海威、重慶兩江產(chǎn)業(yè)園區(qū)等。

Other: Sichuan Airport Group, Southwest US Chamber of Commerce, Shanghai US Chamber of Commerce, European Union Chamber of Commerce in China, Newegg Technologies, Tianjin Volkswagen, Danaher (Shanghai), Shanghai Tektronix Technology, Ghana Haiwei, Airport Hotel, Chengdu Metro, Taihe Law Firm, Jianhae Haiwei, Chongqing Liangjiang Industrial Park, etc.

我要預(yù)訂

咨詢電話：027-5111 9925 , 027-5111 9926手機(jī)：18971071887郵箱：Service@mingketang.com