Description
In this course, you will :
- Learn the fundamentals of Excel navigation and basic functions.
- You'll learn how to use the basic Excel screen, including formulae, subtotals, and text formatting. We will provide you the opportunity to complete a problem-solving exercise with basic Excel skills.
- Learn about the VLookup, value cleaning, and text functions. We will also discuss PwC's perspective on the importance of data cleansing and the use of relevant functions.
- Have the opportunity to solve a problem using VLookup, value cleansing, and the text function.
- Learn about logical functions and pivot tables. We'll demonstrate how to design and use pivot tables to solve business problems.
- Allow you to practice designing and using a pivot table to address a business problem. Finally, we will provide insight into PwC's opinions on the impact of Excel on your career and work.
- Learn more complex Excel formulas. We will demonstrate how to establish statistical formulas, do index matching, and finally, build financial calculations.
- Give you the possibility to issue solve using statistical formulas. Finally, we will give you the opportunity to apply what you have learned through a final project.
Syllabus:
- Overview of Excel
- vLookups and Data Cleansing
- Logical Functions & Pivot Tables
- More Advanced Formulas