Completion

CERTIFICATE

Problem Solving with Excel

Name: Problem Solving with Excel
Rating: 4.7 (5364 reviews)

This course is part of Data Analysis and Presentation Skills: the PwC Approach.

Course Cost

Free course

Beginner

Skill Level

19 Hours

Self-paced lessons

This course cannot be purchased separately - to access the complete learning experience, graded assignments, and earn certificates, you'll need to enroll in the full Data Analysis and Presentation Skills: the PwC Approach Specialization program. You can audit this specific course for free to explore the content, which includes access to course materials and lectures. This allows you to learn at your own pace without any financial commitment.

4.7

1,46,579 Enrolled

Alex Mannella

English

4.7

1,46,579 Enrolled

English

Alex Mannella

What you'll learn

Master Excel navigation and basic functionality

Learn VLookup and advanced data cleansing techniques

Create and analyze pivot tables for data insights

Develop skills in statistical and financial formulas

Apply Excel functions to solve business problems

Skills you'll gain

Microsoft Excel

Data Analysis

Pivot Tables

VLookup

Data Cleansing

Statistical Analysis

Financial Functions

Business Analytics

Spreadsheet Modeling

Problem Solving

This course includes:

4 Hours PreRecorded video

15 assignments

Access on Mobile, Tablet, Desktop

FullTime access

Shareable certificate

Closed caption

Get a Completion Certificate

Share your certificate with prospective employers and your professional network on LinkedIn.

CREATED BY

PROVIDED BY

Get a Completion Certificate

Share your certificate with prospective employers and your professional network on LinkedIn.

CREATED BY

PROVIDED BY

Top companies offer this course to their employees

Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.

There are 4 modules in this course

This comprehensive Excel course teaches both basic and advanced features for business problem-solving. Starting with Excel navigation and basic functions, the curriculum progresses through VLookups, data cleansing, pivot tables, and advanced formulas. Students learn through guided demonstrations and hands-on projects, covering essential skills like statistical forecasting, financial modeling, and data analysis. The course is designed to build practical Excel expertise for real-world business applications.

Overview of Excel

Module 1 · 5 Hours to complete

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.

Skills you'll gain

Excel Basics

Data Navigation

Formula Usage

Text Formatting

Subtotal Functions

This course includes:

13 Videos

4 Assignments

10 Reading Materials

vLookups and Data Cleansing

Module 2 · 5 Hours to complete

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.

Skills you'll gain

VLookup Functions

Data Cleansing

Text Functions

Data Validation

Excel Analysis

This course includes:

16 Videos

4 Assignments

8 Reading Materials

Logical Functions & Pivot Tables

Module 3 · 4 Hours to complete

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.

Skills you'll gain

Logical Functions

Pivot Tables

Data Analysis

Business Solutions

Excel Functions

This course includes:

17 Videos

3 Assignments

5 Reading Materials

More Advanced Formulas

Module 4 · 5 Hours to complete

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.

Skills you'll gain

Advanced Excel

Statistical Analysis

Index Match

Financial Formulas

Data Functions

This course includes:

12 Videos

4 Assignments

8 Reading Materials

Fee Structure

Individual course purchase is not available - to enroll in this course with a certificate, you need to purchase the complete Professional Certificate Course. For enrollment and detailed fee structure, visit the following: Data Analysis and Presentation Skills: the PwC Approach

Reviews

Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.

Faculties

These are the expert instructors who will be teaching you throughout the course. With a wealth of knowledge and real-world experience, they're here to guide, inspire, and support you every step of the way. Get to know the people who will help you reach your learning goals and make the most of your journey.

4.7

Reviews

3,65,962

Students

Courses

Alex Mannella

Alex Mannella has established himself as a leading authority in data analytics and customer value management, drawing from his experience as a founding Partner in PwC's Information and Analytics Practice. His expertise spans customer value management (CVM), response modeling, database marketing, and data mining, with significant achievements in developing segmentation algorithms and artificial intelligence applications. Prior to PwC, as head of research at Econometrics, Inc., he led the redesign of a national database containing over 180 million records and developed the influential life-stage variable for CRM analysis. His academic influence extends across prestigious institutions as a guest lecturer at UCLA, Stanford, ITAM, Universidad de los Andes, IIM-B, and ISB. He currently serves on the advisory board at the University of Chicago Graham School while maintaining active membership in the American Statistical Association (Chicago Chapter) and the Chicago Association of Direct Marketing. His Coursera courses focus on data analysis, visualization, and business presentation skills, reflecting his commitment to sharing expertise in data-driven decision making.

Beginner

Skill Level

19 Hours

Self-paced lessons

Course Cost

Free course

Completion

CERTIFICATE

Frequently asked Questions

Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.

Problem Solving with Excel

What you'll learn

Skills you'll gain

This course includes:

Get a Completion Certificate

Get a Completion Certificate

Top companies offer this course to their employees

There are 4 modules in this course

Overview of Excel

Skills you'll gain

This course includes:

vLookups and Data Cleansing

Skills you'll gain

This course includes:

Logical Functions & Pivot Tables

Skills you'll gain

This course includes:

More Advanced Formulas

Skills you'll gain

This course includes:

Fee Structure

Reviews

Faculties

Frequently asked Questions

When will I have access to the lectures and assignments?

What will I get if I subscribe to this Specialization?

What is the refund policy?

Is financial aid available?