Explore

Problem Solving with Excel

Approx. 20 hours to complete

Save Course

Go to Course

Course Summary

Excel Analysis is a course that teaches you how to use Excel for data analysis, data visualization, and data-driven decision making. You will learn how to use advanced Excel functions and tools to analyze and manipulate data, create charts and graphs, and make informed business decisions.

Key Learning Points

Learn how to use Excel for data analysis
Master advanced Excel functions and tools
Create charts and graphs for data visualization
Make data-driven decisions for your business

Learning Outcomes

Master advanced Excel functions and tools for data analysis
Create charts and graphs for data visualization
Make data-driven decisions for your business

Prerequisites or good to have knowledge before taking this course

Basic understanding of Excel
Access to Microsoft Excel

Course Difficulty Level

Intermediate

Course Format

Online
Self-paced

Similar Courses

Data Analysis with Excel
Excel Skills for Business: Essentials
Data Visualization with Advanced Excel

Related Education Paths

Related Books

Description

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.

Outline

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

Summary of User Reviews

The Excel Analysis course on Coursera has received high praise from its users. It is considered to be an excellent resource for learning data analysis with Excel. Many users have found the course to be well-structured, engaging, and informative.

Key Aspect Users Liked About This Course

The course covers a wide range of topics and provides practical exercises that help users apply what they have learned.

Pros from User Reviews

The course is comprehensive and covers a wide range of topics related to data analysis with Excel.
The instructors are knowledgeable and provide clear explanations of complex concepts.
The course includes practical exercises that help users apply what they have learned.
The course is well-structured and easy to follow, even for beginners.

Cons from User Reviews

Some users have found the pace of the course to be too slow.
The course may not be suitable for users who are already familiar with Excel and data analysis.
The course does not cover advanced topics in depth.
Some users have reported technical issues with the course platform.
The course may be too basic for users who are looking for more advanced Excel skills.

Recommended for you

Supply Chain of Perishable Products: Inventory Management

Newsvendor Model in less than 60 minutes In this course, we will learn how to manage a supply chain of perishable products....

Save Course

Responsibility Accounting & Performance Measurement

Managerial accounting tools of responsibility accounting and other performance measures related to decentralization Responsibility accounting & performance measures....

Save Course

Boosting Productivity through the Tech Stack

This is Course 4 in the Salesforce Sales Development Representative Professional Certificate. This course demonstrates how to enhance productivity by implementing tech tools that streamline your SDR workflow....

Save Course

Problem-solving and Decision-making Strategies

Adapt to Every Situation. Generate, Evaluate, and Choose Between Alternative Courses of Action. This course gives you exactly what you need to improve your problem-solving and decision-making habits....

Save Course