本課程是 Data Analysis and Presentation Skills: the PwC Approach 專項課程專項課程的一部分

4.7
星
5,132 個評分

Alex Mannella

127,323 人已註冊

提供方

Data Analysis and Presentation Skills: the PwC Approach 專項課程普华永道

課程信息

69,231 次近期查看

This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of excel through guided demonstration. Each week you will build on your excel skills and be provided an opportunity to practice what you’ve learned. Finally, you will have a chance to put your knowledge to work in a final project.  Please note, the content in this course was developed using a Windows version of Excel 2013.  
This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

可靈活調整截止日期

根據您的日程表重置截止日期。

可分享的證書

完成後獲得證書

100% 在線

立即開始，按照自己的計劃學習。

第 2 門課程（共 5 門）

Data Analysis and Presentation Skills: the PwC Approach 專項課程

初級

完成時間大約為20 小時

英語（English）

您將獲得的技能

Data Analysis
Microsoft Excel
Pivot Table
Data Cleansing

可靈活調整截止日期

根據您的日程表重置截止日期。

可分享的證書

完成後獲得證書

100% 在線

立即開始，按照自己的計劃學習。

第 2 門課程（共 5 門）

Data Analysis and Presentation Skills: the PwC Approach 專項課程

初級

完成時間大約為20 小時

英語（English）

授課教師

授課教師評分

4.62/5 （419 個評分）

Alex Mannella

Alumni / Former Principal

307,704 個學生

5 門課程

提供方

普华永道

授課大綱 - 您將從這門課程中學到什麼

內容評分93%（21,380 個評分）

週

週 1

完成時間為 6 小時

Overview of Excel

In this module, you will learn the basics of Excel navigation and Excel basic functionality. You will learn how to navigate the basic Excel screen including using formulas, subtotals and text formatting. We will provide you an opportunity to perform a problem solving exercise using basic Excel skills. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.

完成時間為 6 小時

13 個視頻（總計 61 分鐘）, 10 個閱讀材料, 4 個測驗

13 個視頻

Welcome to Problem Solving with Excel4分鐘

Tao of Excel6分鐘

Week 1 Welcome2分鐘

Excel Basics and Navigation Part 15分鐘

Excel Basics and Navigation Part 26分鐘

A Message from our Chief People Officer at PwC41

Paste Special - Part 16分鐘

Paste Special - Part 22分鐘

Cell Locking - Part 16分鐘

Cell Locking - Part 22分鐘

Named Ranges6分鐘

Subtotal - Part 17分鐘

Subtotal - Part 22分鐘

10 個閱讀材料

Course Overview and Syllabus10分鐘

Meet the PwC Content Developers10分鐘

Guiding Principles for Using Excel30分鐘

Excel Basics Workbook10分鐘

Excel Basics and Navigation Handout10分鐘

Basic Functionality Workbook25分鐘

Basic Functionality Handout10分鐘

Subtotal Excel Workbook25分鐘

Subtotal Handout10分鐘

Week 1 Project30分鐘

4 個練習

Excel Basics and Navigation Quiz30分鐘

Basic Functionality Quiz30分鐘

Subtotal Quiz30分鐘

Week 1 project quiz5分鐘

週

週 2

完成時間為 5 小時

vLookups and Data Cleansing

In this module you will learn about VLookup, value cleansing and text functions. We will also introduce you to PwC's perspective on the value in cleansing data and using the appropriate functions. Finally, we will provide you an opportunity to perform a problem solving exercise using VLookup, value cleansing and text function. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.

完成時間為 5 小時

16 個視頻（總計 51 分鐘）, 8 個閱讀材料, 4 個測驗

16 個視頻

Welcome to Week 21分鐘

VLookup6分鐘

Use VLOOKUP, data validation and multiple VLOOKUPs together2分鐘

HLOOKUP2分鐘

Nesting5分鐘

Data Cleansing: Values - CLEAN- 1a2分鐘

Data Cleansing: Values - CLEAN -1b2分鐘

Data Cleansing: Values - TRIM1分鐘

Data Cleansing: Values - SUBSTITUTE -3a2分鐘

Data Cleansing: Values - SUBSTITUTE - 3b1分鐘

Data Cleansing: Values - STORED AS TEXT2分鐘

Data Cleansing: Values - De-DUPLICATING1分鐘

Data Cleansing: Text Functions4分鐘

Text - LEN & FIND3分鐘

Text - CONCATENATE3分鐘

Text - Data Validation5分鐘

8 個閱讀材料

VLookup Workbook30分鐘

VLookup Handout10分鐘

Data Cleansing: Values Workbook30分鐘

Data Cleansing: Values Handout10分鐘

Data Cleansing: Text Workbook30分鐘

Data Cleansing: Text Handout10分鐘

Hints for Week 2 Project5分鐘

Week 2 Project35分鐘

4 個練習

VLookup30分鐘

Data Cleansing - Values Quiz30分鐘

Data Cleanse - Text Quiz30分鐘

Week 2 Quiz5分鐘

週

週 3

完成時間為 4 小時

Logical Functions & Pivot Tables

In this module, you will learn about logical functions and pivot tables. We will show you how to create and use pivot tables to solve business problems. We will give you an opportunity to practice creating and using a pivot table to solve a business problem. Finally, we will share some insight on PwC’s perspectives on the impact of Excel on your career and work. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.

完成時間為 4 小時

17 個視頻（總計 68 分鐘）, 5 個閱讀材料, 3 個測驗

17 個視頻

Welcome to Week 32分鐘

Logical Functions: Introduction5分鐘

Logical Functions - COUNTIFS7分鐘

Logical Functions - COUNTIFS Part 22分鐘

Logical Functions - SUMIFS3分鐘

Logical Functions - SUMIFS Part 25分鐘

Logical Functions - IF + THEN1分鐘

Logical Functions - IF + AND2分鐘

Logical Functions - IF + OR2分鐘

Logical Functions - Nesting3分鐘

Bringing Value with Excel4分鐘

Pivot Tables4分鐘

Navigate a Pivot Table7分鐘

Sort a Pivot Table3分鐘

Advanced Filtering5分鐘

Calculated Fields3分鐘

Slicers2分鐘

5 個閱讀材料

Logical Functions Workbook10分鐘

Logical Functions Handout10分鐘

Pivot Tables Workbook40分鐘

Pivot Tables Handout10分鐘

Week 3 Project10分鐘

3 個練習

Logical Functions Quiz30分鐘

Pivot Tables Quiz30分鐘

Week 3 Project Quiz30分鐘

週

週 4

完成時間為 6 小時

More Advanced Formulas

In this module you will learn more advanced Excel formulas. We will show you how to create statistical formulas, perform an index match, and lastly, build financial formulas. We will provide you with an opportunity to problem solve using statistical formulas. Finally, we will give you an opportunity to practice what you have learned through a final project. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.

完成時間為 6 小時

12 個視頻（總計 64 分鐘）, 8 個閱讀材料, 4 個測驗

12 個視頻

Welcome to Week 42分鐘

Intro to Statistical Forecasting9分鐘

Statistical Forecasting - Part 116分鐘

Statistical Forecasting - Part 27分鐘

Index Match2分鐘

Index Match: MATCH Formula2分鐘

x and y Variables3分鐘

2 Variable Lookup6分鐘

Financial Function - NPV and IRR6分鐘

Financial Function - Calculating Payment Schedule2分鐘

Financial Function - Calculating Payment Period1分鐘

Course Wrap-up2分鐘

8 個閱讀材料

Statistical Forecasting Workbook30分鐘

Statistical Forecasting Handout10分鐘

Index Match Workbook30分鐘

Index Match Handout10分鐘

Financial Function Workbook30分鐘

Financial Function Handout10分鐘

Week 4 Project40分鐘

Learn more about PwC and our career opportunities10分鐘

4 個練習

Statistical Forecasting Quiz30分鐘

Index Match Quiz30分鐘

Financial Functions30分鐘

Week 4 Project Quiz10分鐘

審閱

4.7

945 條評論

5 stars
77.08%
4 stars
18.72%
3 stars
3.09%
2 stars
0.68%
1 star
0.40%

來自PROBLEM SOLVING WITH EXCEL 的熱門評論

由 YZ 提供2018年11月17日

100% perfect course. Exactly what I needed. Thought I knew how to use Excel but I actually didn't. Covers useful knowledge which I didn't have the chance to learn in university.

由 JG 提供2017年9月4日

Great course so far, learned a lot about how to use Excel functions to solve problems. However, the course may need an update on the missing videos and minor calculation errors in the workbooks.

由 GA 提供2020年12月21日

Great course that starts with basics for newcomers to Excel and slowly builds up to some intermediate and advanced formulas that can be used for all sorts of business and real world problem solving

由 KH 提供2018年11月10日

Minor formula errors and inconsistencies in the materials vs. what is being presented in the videos, but nothing that would prevent someone from learning the skills being presented.

查看所有評論

關於 Data Analysis and Presentation Skills: the PwC Approach 專項課程

If you are a PwC Employee, gain access to the PwC Specialization and Courses for free using the instructions on Vantage.

This Specialization will help you get practical with data analysis, turning business intelligence into real-world outcomes. We'll explore how a combination of better understanding, filtering, and application of data can help you solve problems faster - leading to smarter and more effective decision-making. You’ll learn how to use Microsoft Excel, PowerPoint, and other common data analysis and communication tools, and perhaps most importantly, we'll help you to present data to others in a way that gets them engaged in your story and motivated to act. Please note: If you'd like to audit the courses in this Specialization, you'll need to enroll in each course separately and then you will see the audit option. This specialization was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

Data Analysis and Presentation Skills: the PwC Approach

常見問題

我什么时候能够访问课程视频和作业？
讲座和作业的访问权限取决于您的注册类型。如果您以旁听模式参加课程，则可以免费查看大多数课程资料。要访问评分作业并获得证书，您需要在旁听期间或之后购买证书体验。如果看不到旁听选项：
课程可能不提供旁听选项。您可以尝试免费试用，也可以申请助学金。
课程可能会改为提供'完整课程，没有证书'。通过此选项，您可以查看所有课程材料、提交所要求的作业，以及获得最终成绩。这也意味着您将无法购买证书体验。
我订阅此专项课程后会得到什么？
您注册课程后，将有权访问专项课程中的所有课程，并且会在完成课程后获得证书。您的电子课程证书将添加到您的成就页中，您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容，可以免费旁听课程。
有助学金吗？
是的。如果您负担不起学习计划的注册费，则可以在选择学习计划时申请助学金或奖学金。如果您选择的学习计划提供助学金或奖学金，则您将在描述页面上看到一个申请链接。

還有其他問題嗎？請訪問學生幫助中心。

Problem Solving with Excel

課程信息

您將獲得的技能