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
审阅
Nov 05, 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.
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
探索我们的目录
免费加入并获得个性化推荐、更新和优惠。
Coursera Footer
© 2020 Coursera Inc.保留所有权利。
