Problem Solving with Excel
4.5 /5- Offered byCoursera
Problem Solving with Excel at Coursera Overview
Duration | 20 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Problem Solving with Excel at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 2 of 5 in the Data Analysis and Presentation Skills: the PwC Approach Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Beginner Level
- Approx. 20 hours to complete
- English Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, Turkish, English, Spanish
Problem Solving with Excel at Coursera Course details
- 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.
Problem Solving with Excel at Coursera Curriculum
Overview of Excel
Welcome to Problem Solving with Excel
Tao of Excel
Week 1 Welcome
Excel Basics and Navigation Part 1
Excel Basics and Navigation Part 2
A Message from our Chief People Officer at PwC
Paste Special - Part 1
Paste Special - Part 2
Cell Locking - Part 1
Cell Locking - Part 2
Named Ranges
Subtotal - Part 1
Subtotal - Part 2
Course Overview and Syllabus
Meet the PwC Content Developers
Guiding Principles for Using Excel
Excel Basics Workbook
Excel Basics and Navigation Handout
Basic Functionality Workbook
Basic Functionality Handout
Subtotal Excel Workbook
Subtotal Handout
Week 1 Project
Excel Basics and Navigation Quiz
Basic Functionality Quiz
Subtotal Quiz
Week 1 project quiz
vLookups and Data Cleansing
Welcome to Week 2
VLookup
Use VLOOKUP, data validation and multiple VLOOKUPs together
HLOOKUP
Nesting
Data Cleansing: Values - CLEAN- 1a
Data Cleansing: Values - CLEAN -1b
Data Cleansing: Values - TRIM
Data Cleansing: Values - SUBSTITUTE -3a
Data Cleansing: Values - SUBSTITUTE - 3b
Data Cleansing: Values - STORED AS TEXT
Data Cleansing: Values - De-DUPLICATING
Data Cleansing: Text Functions
Text - LEN & FIND
Text - CONCATENATE
Text - Data Validation
VLookup Workbook
VLookup Handout
Data Cleansing: Values Workbook
Data Cleansing: Values Handout
Data Cleansing: Text Workbook
Data Cleansing: Text Handout
Hints for Week 2 Project
Week 2 Project
VLookup
Data Cleansing - Values Quiz
Data Cleanse - Text Quiz
Week 2 Quiz
Logical Functions & Pivot Tables
Welcome to Week 3
Logical Functions: Introduction
Logical Functions - COUNTIFS
Logical Functions - COUNTIFS Part 2
Logical Functions - SUMIFS
Logical Functions - SUMIFS Part 2
Logical Functions - IF + THEN
Logical Functions - IF + AND
Logical Functions - IF + OR
Logical Functions - Nesting
Bringing Value with Excel
Pivot Tables
Navigate a Pivot Table
Sort a Pivot Table
Advanced Filtering
Calculated Fields
Slicers
Logical Functions Workbook
Logical Functions Handout
Pivot Tables Workbook
Pivot Tables Handout
Week 3 Project
Logical Functions Quiz
Pivot Tables Quiz
Week 3 Project Quiz
More Advanced Formulas
Welcome to Week 4
Intro to Statistical Forecasting
Statistical Forecasting - Part 1
Statistical Forecasting - Part 2
Index Match
Index Match: MATCH Formula
x and y Variables
2 Variable Lookup
Financial Function - NPV and IRR
Financial Function - Calculating Payment Schedule
Financial Function - Calculating Payment Period
Course Wrap-up
Statistical Forecasting Workbook
Statistical Forecasting Handout
Index Match Workbook
Index Match Handout
Financial Function Workbook
Financial Function Handout
Week 4 Project
Learn more about PwC and our career opportunities
Statistical Forecasting Quiz
Index Match Quiz
Financial Functions
Week 4 Project Quiz
Problem Solving with Excel at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?