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.
Ce cours fait partie de la Spécialisation Data Analysis and Presentation Skills: the PwC Approach
Problem Solving with Excel
proposé par
À propos de ce cours
4.7
2,650 notes
Compétences que vous acquerrez
Data AnalysisMicrosoft ExcelPivot TableData Cleansing
Programme du cours : ce que vous apprendrez dans ce cours
Semaine
1Overview 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.
13 vidéos (Total 60 min), 10 lectures, 4 quiz
13 vidéos
Tao of Excel6 min
Week 1 Welcome2 min
Excel Basics and Navigation Part 15 min
Excel Basics and Navigation Part 26 min
A Message from our Chief People Officer at PwC41s
Paste Special - Part 16 min
Paste Special - Part 22 min
Cell Locking - Part 15 min
Cell Locking - Part 22 min
Named Ranges6 min
Subtotal - Part 17 min
Subtotal - Part 22 min
10 lectures
Course Overview and Syllabus10 min
Meet the PwC Content Developers10 min
Guiding Principles for Using Excel30 min
Excel Basics Workbook10 min
Excel Basics and Navigation Handout10 min
Basic Functionality Workbook25 min
Basic Functionality Handout10 min
Subtotal Excel Workbook25 min
Subtotal Handout10 min
Week 1 Project30 min
4 exercices pour s'entraîner
Excel Basics and Navigation Quiz8 min
Basic Functionality Quiz6 min
Subtotal Quiz2 min
Week 1 project quiz5 min
Semaine
2vLookups 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.
16 vidéos (Total 51 min), 8 lectures, 4 quiz
16 vidéos
Welcome to Week 21 min
VLookup6 min
Use VLOOKUP, data validation and multiple VLOOKUPs together2 min
HLOOKUP2 min
Nesting5 min
Data Cleansing: Values - CLEAN- 1a2 min
Values - CLEAN -1b2 min
Values - TRIM1 min
Values - SUBSTITUTE2 min
Values - VALUE1 min
Values - TEXT2 min
Values - Stored as Text1 min
Data Cleansing: Text Functions4 min
Text - LEN3 min
Text - CONCATENATE3 min
Text - Data Validation5 min
8 lectures
VLookup Workbook30 min
VLookup Handout10 min
Data Cleansing: Values Workbook30 min
Data Cleansing: Values Handout10 min
Data Cleansing: Text Workbook30 min
Data Cleansing: Text Handout10 min
Week 2 Project35 min
Hints for Week 2 Project5 min
4 exercices pour s'entraîner
VLookup8 min
Data Cleanse - Values Quiz6 min
Data Cleanse - Text Quiz6 min
Week 2 Quiz5 min
Semaine
3Logical 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.
17 vidéos (Total 68 min), 5 lectures, 3 quiz
17 vidéos
Welcome to Week 32 min
Logical Functions: Introduction5 min
Logical Functions - COUNTIFS7 min
Logical Functions - COUNTIFS Part 22 min
Logical Functions - SUMIFS3 min
Logical Functions - SUMIFS Part 25 min
Logical Functions - IF + THEN1 min
Logical Functions - IF + AND2 min
Logical Functions - IF + OR2 min
Logical Functions - Nesting3 min
Bringing Value with Excel4 min
Pivot Tables4 min
Navigate a Pivot Table7 min
Sort a Pivot Table3 min
Advanced Filtering5 min
Calculated Fields3 min
Slicers2 min
5 lectures
Logical Functions Workbook10 min
Logical Functions Handout10 min
Pivot Tables Workbook40 min
Pivot Tables Handout10 min
Week 3 Project10 min
3 exercices pour s'entraîner
Logical Functions Quiz8 min
Pivot Tables Quiz8 min
Week 3 Project Quiz6 min
Semaine
4More 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.
12 vidéos (Total 64 min), 8 lectures, 4 quiz
12 vidéos
Welcome to Week 42 min
Intro to Statistical Forecasting9 min
Statistical Forecasting - Part 116 min
Statistical Forecasting - Part 27 min
Index Match2 min
Index Match: MATCH Formula2 min
x and y Variables3 min
2 Variable Lookup6 min
Financial Function - NPV and IRR6 min
Financial Function - Calculating Payment Schedule2 min
Financial Function - Calculating Payment Period1 min
Course Wrap-up2 min
8 lectures
Statistical Forecasting Workbook30 min
Statistical Forecasting Handout10 min
Index Match Workbook30 min
Index Match Handout10 min
Financial Function Workbook30 min
Financial Function Handout10 min
Week 4 Project40 min
Learn more about PwC and our career opportunities10 min
4 exercices pour s'entraîner
Statistical Forecasting Quiz12 min
Index Match Quiz8 min
Financial Functions8 min
Week 4 Project Quiz10 min
4.7
482 avis30%
a commencé une nouvelle carrière après avoir terminé ces cours
25%
a bénéficié d'un avantage concret dans sa carrière grâce à ce cours
Meilleurs avis
par ZA•Jan 2nd 2019
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
par MS•Nov 5th 2017
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.
Enseignant
Alex Mannella
Alumni / Former PrincipalÀ propos de PwC
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.
À propos de la Spécialisation 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.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
Une fois que vous êtes inscrit(e) pour un Certificat, vous pouvez accéder à toutes les vidéos de cours, et à tous les quiz et exercices de programmation (le cas échéant). Vous pouvez soumettre des devoirs à examiner par vos pairs et en examiner vous-même uniquement après le début de votre session. Si vous préférez explorer le cours sans l'acheter, vous ne serez peut-être pas en mesure d'accéder à certains devoirs.
À quoi ai-je droit si je m'abonne à cette Spécialisation ?
Lorsque vous vous inscrivez au cours, vous bénéficiez d'un accès à tous les cours de la Spécialisation, et vous obtenez un Certificat lorsque vous avez réussi. Votre Certificat électronique est alors ajouté à votre page Accomplissements. À partir de cette page, vous pouvez imprimer votre Certificat ou l'ajouter à votre profil LinkedIn. Si vous souhaitez seulement lire et visualiser le contenu du cours, vous pouvez accéder gratuitement au cours en tant qu'auditeur libre.
Quelle est la politique de remboursement ?
Une aide financière est-elle possible ?
D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.
Coursera propose un accès universel à la meilleure formation au monde,
en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.
© 2019 Coursera Inc. Tous droits réservés.
