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 is part of the Data Analysis and Presentation Skills: the PwC Approach Specialization
About this Course
Skills you will gain
- Data Analysis
- Microsoft Excel
- Pivot Table
- Data Cleansing
Syllabus - What you will learn from this course
Overview of Excel
vLookups and Data Cleansing
Logical Functions & Pivot Tables
More Advanced Formulas
- 5 stars77.08%
- 4 stars18.69%
- 3 stars3.12%
- 2 stars0.67%
- 1 star0.40%
TOP REVIEWS FROM PROBLEM SOLVING WITH EXCEL
Really useful training, lot's of meaningful functions (vlookup, index(match) & text functions).
Good to learn formulas in english too and get familiar with them (I was french Excel user).
Some questions in the cumulative exercise should be phrased in a more "lay man" manner. I don't seem to understand the question(s) at times. Overall still a very good learning journey for me
Great course that starts with basics for newcomers to Excel and slowly builds up to some intermediate and advanced formulas that can be used for all sorts of business and real world problem solving
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.
About the Data Analysis and Presentation Skills: the PwC Approach Specialization
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.