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
审阅
MS
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.
DA
May 07, 2020
This course was really informative and motivated the learner to practice everything practically. There was some audio problem in some of the lectures though which could be improved.
从本节课中
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
探索我们的目录
免费加入并获得个性化推荐、更新和优惠。
© 2020 Coursera Inc.保留所有权利。
