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.
このコースはData Analysis and Presentation Skills: the PwC Approach の専門講座に属します。
Problem Solving with Excel
提供：
このコースについて
139,917 最近の表示
習得するスキル
Data AnalysisMicrosoft ExcelPivot TableData Cleansing
このCourseを受講している学習者は
- Auditors
- Accountants
- Financial Advisors
- Controllers
- Chief Financial Officers (CFOs)
シラバス - 本コースの学習内容
週
14時間で修了
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.
13件のビデオ （合計60分）, 10 readings, 4 quizzes
13件のビデオ
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 15 分
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 Quiz8 分
Basic Functionality Quiz6 分
Subtotal Quiz2 分
Week 1 project quiz5 分
週
24時間で修了
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.
16件のビデオ （合計51分）, 8 readings, 4 quizzes
16件のビデオ
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の練習問題
VLookup8 分
Data Cleansing - Values Quiz6 分
Data Cleanse - Text Quiz6 分
Week 2 Quiz5 分
週
33時間で修了
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.
17件のビデオ （合計68分）, 5 readings, 3 quizzes
17件のビデオ
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 Quiz8 分
Pivot Tables Quiz8 分
Week 3 Project Quiz6 分
週
45時間で修了
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.
12件のビデオ （合計64分）, 8 readings, 4 quizzes
12件のビデオ
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 Quiz12 分
Index Match Quiz8 分
Financial Functions8 分
Week 4 Project Quiz10 分
4.7
583件のレビュー32%
コース終了後に新しいキャリアをスタートした
28%
コースが具体的なキャリアアップにつながった
11%
昇給や昇進につながった
Problem Solving with Excel からの人気レビュー
An amazing course with very interactive video lessons and exercises that made sure that candidates were equipped with good knowledge by the end of the course. Thank You for the opportunity
The course is phenomenal for the finance professionals especially for the ones who are early in their careers. I would highly recommend this course to business students and professionals.
講師
Alex Mannella
Alumni / Former PrincipalPwCについて
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.
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 the PwC L&D Spark page or simply search "Coursera" on PwC Spark.
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.
What's more, should you enroll in these courses, you will be invited to join PwC's talent network. Those who opt into this talent network will receive information about PwC career opportunities, thought leadership, and happenings in the PwC global network.
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.
よくある質問
いつ講座や課題にアクセスできるようになりますか？
修了証に登録すると、すべてのビデオ、テスト、およびプログラミング課題（該当する場合）にアクセスできます。ピアレビュー課題は、セッションが開始してからのみ、提出およびレビューできます。購入せずにコースを検討することを選択する場合、特定の課題にアクセスすることはできません。
この専門講座をサブスクライブすると何を行うことができるようになりますか？
コースに登録する際、専門講座のすべてのコースにアクセスできます。コースの完了時には修了証を取得できます。電子修了証が成果のページに追加され、そこから修了証を印刷したり、LinkedInのプロフィールに追加したりできます。コースの内容の閲覧のみを希望する場合は、無料でコースを聴講できます。
返金ポリシーについて教えてください。
学資援助はありますか？
さらに質問がある場合は、受講者向けヘルプセンターにアクセスしてください。