Problem Solving with Excel

Problem Solving with Excel

Problem Solving with Excel

PwC

About this course: 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.

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 the basic Excel skills.

13 videos, 10 readings

Video: Welcome to Problem Solving with Excel

阅读: Course Overview and Syllabus

阅读: Meet the PwC Content Developers

讨论提示: Meet Your Classmates

Video: Tao of Excel

阅读: Guiding Principles for Using Excel

Video: Week 1 Welcome

阅读: Excel Basics Workbook

Video: Excel Basics and Navigation Part 1

Video: Excel Basics and Navigation Part 2

阅读: Excel Basics and Navigation Handout

Video: A Message from our Chief People Officer at PwC

阅读: Basic Functionality Workbook

Video: Paste Special - Part 1

Video: Paste Special - Part 2

Video: Cell Locking - Part 1

Video: Cell Locking - Part 2

Video: Named Ranges

阅读: Basic Functionality Handout

阅读: Subtotal Excel Workbook

Video: Subtotal - Part 1

Video: Subtotal - Part 2

阅读: Subtotal Handout

阅读: Week 1 Project

Graded: Excel Basics and Navigation Quiz

Graded: Basic Functionality Quiz

Graded: Subtotal Quiz

Graded: Week 1 project quiz

WEEK 2

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.

16 videos, 8 readings

Video: Welcome to Week 2

阅读: VLookup Workbook

Video: VLookup

Video: Use VLOOKUP, data validation and multiple VLOOKUPs together

Video: HLOOKUP

Video: Nesting

阅读: VLookup Handout

阅读: Data Cleansing: Values Workbook

Video: Data Cleansing: Values - CLEAN- 1a

Video: Values - CLEAN -1b

Video: Values - TRIM

Video: Values - SUBSTITUTE

Video: Values - VALUE

Video: Values - TEXT

Video: Values - Stored as Text

阅读: Data Cleansing: Values Handout

阅读: Data Cleansing: Text Workbook

Video: Data Cleansing: Text Functions

Video: Text - LEN

Video: Text - CONCATENATE

Video: Text - Data Validation

阅读: Data Cleansing: Text Handout

阅读: Week 2 Project

阅读: Hints for Week 2 Project

Graded: VLookup

Graded: Data Cleanse - Values Quiz

Graded: Data Cleanse - Text Quiz

Graded: Week 2 Quiz

WEEK 3

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.

17 videos, 5 readings

Video: Welcome to Week 3

阅读: Logical Functions Workbook

Video: Logical Functions: Introduction

Video: Logical Functions - COUNTIFS

Video: Logical Functions - COUNTIFS Part 2

Video: Logical Functions - SUMIFS

Video: Logical Functions - SUMIFS Part 2

Video: Logical Functions - IF + THEN

Video: Logical Functions - IF + AND

Video: Logical Functions - IF + OR

Video: Logical Functions - Nesting

阅读: Logical Functions Handout

Video: Bringing Value with Excel

讨论提示: How will you bring value by using Excel?

阅读: Pivot Tables Workbook

Video: Pivot Tables

Video: Navigate a Pivot Table

Video: Sort a Pivot Table

Video: Advanced Filtering

Video: Calculated Fields

Video: Slicers

阅读: Pivot Tables Handout

阅读: Week 3 Project

Graded: Logical Functions Quiz

Graded: Pivot Tables Quiz

Graded: Week 3 Project Quiz

WEEK 4

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.

12 videos, 8 readings

Video: Welcome to Week 4

阅读: Statistical Forecasting Workbook

Video: Intro to Statistical Forcasting

Video: Statistical Forecasting - Part 1

Video: Statistical Forecasting - Part 2

阅读: Statistical Forecasting Handout

阅读: Index Match Workbook

Video: Index Match

Video: Index Match: MATCH Formula

Video: x and y Variables

Video: 2 Variable Lookup

阅读: Index Match Handout

阅读: Financial Function Workbook

Video: Financial Function - NPV and IRR

Video: Financial Function - Calculating Payment Schedule

Video: Financial Function - Calculating Payment Period

阅读: Financial Function Handout

阅读: Week 4 Project

Video: Course Wrap-up

阅读: Learn more about PwC and our career opportunities

Graded: Statistical Forecasting Quiz

Graded: Index Match Quiz

Graded: Financial Functions

Graded: Week 4 Project Quiz

FAQs

How It Works

课程作业

每门课程都像是一本互动的教科书，具有预先录制的视频、测验和项目。

来自同学的帮助

与其他成千上万的学生相联系，对想法进行辩论，讨论课程材料，并寻求帮助来掌握概念。

证书

获得正式认证的作业，并与朋友、同事和雇主分享您的成功。

Creators

PwC

With offices in 157 countries and more than 208,000 people, PwC is among the leading professional services networks in the world. Our purpose is to build trust in society and solve important problems. We help organisations and individuals create the value they’re looking for, by delivering quality in assurance, tax and advisory services.

Pricing

旁听

购买课程

访问课程材料

Available

Available

访问评分的材料

-

Not available

Available

收到最终成绩

-

Not available

Available

获得可共享的课程证书

-

Not available

Available

Ratings and Reviews

Rated 4.7 out of 5 of 1,153 ratings

PS

This course offers some very practical excel skills that will help bring your work to the next level.