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
审阅
4.7（5,041 个评分）
- 5 stars77.12%
- 4 stars18.68%
- 3 stars3.07%
- 2 stars0.69%
- 1 star0.41%
SA
Nov 4, 2020
Really useful training, lot's of meaningful functions (vlookup, index(match) & text functions).\n\nGood to learn formulas in english too and get familiar with them (I was french Excel user).
ZA
Jan 1, 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
从本节课中
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
© 2022 Coursera Inc.保留所有权利。
