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.
Use VLOOKUP, data validation and multiple VLOOKUPs together
Loading...
您将学习的技能
Data Analysis, Microsoft Excel, Pivot Table, Data Cleansing
审阅
BY
Jan 17, 2019
The functions introduced in this course are very useful for me to utilize the excel in my academic studies and I also think this will help me to develop greatly in my future career.
TW
Jan 03, 2017
It's a great course with clear instructions and insightful practices. I learnt useful functionalities and tools that could be used in my future career as an accounting professional.
从本节课中
vLookups 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. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.
教学方
Alex Mannella
Alumni / Former Principal