Google Sheets for Creative Projects and Small Business
VLOOKUP and How It Works
A course by Pete Raho , Craftsman and Entrepreneur
Joined March 2022
About the video: VLOOKUP and How It Works
Overview
“Next, I will show you how to create an invoice you can print or email to customers. You will be able to change the contents of this invoice by changing the order number. In order to "look up" information on the invoice, you will learn how to use the VLOOKUP function. ”
In this video lesson Pete Raho addresses the topic: VLOOKUP and How It Works, which is part of the Domestika online course: Google Sheets for Creative Projects and Small Business. Learn to create effective solutions for your projects or business using spreadsheets to manage your tasks, budget, and sales using its tools and formulas.
Partial transcription of the video
“The VLOOKUP formula is one of the most powerful formulas when you're dealing with spreadsheets. And what it allows you to do is to take some big list of records, say a big list of orders that we have, like in our order spreadsheet, and it's going to go all the way down the side with the order numbers until it finds the right order number. and then go over a number of columns until it gets to say a person's name or the price they paid or whatever. So it allows you to take a big, big spreadsheet of information and pull out one particular value. In our case here, we're going to be using it to ...”
This transcript is automatically generated, so it may contain mistakes.
Course summary for: Google Sheets for Creative Projects and Small Business
-
Category
Marketing & Business -
Software
Google Sheets -
Areas
Business, Management & Productivity
Pete Raho
A course by Pete Raho
Pete Raho is a craftsman and entrepreneur based in Brooklyn, New York. Throughout his carer, he’s enjoyed bringing order to chaos by implementing his problem-solving skills in each role he’s taken on. During his undergrad at Fordham University in New York, he majored in both Art History and Biology, which has allowed him to be both creative and analytical. He also earned his MBA from New York University's Stern School of Business, specializing in Strategy.
Working as a client development analyst at the renowned Christie’s auction house for nearly a decade. He ran his own woodworking business, Gowanus Furniture, creating smart design for compact spaces. Peter was also a business analyst for the furniture retailer, West Elm. Currently, he's working in the world of audio equipment, buying and selling high-end audio tools at StereoBuyers.
- 100% positive reviews (91)
- 7,663 students
- 16 lessons (1h 56m)
- 22 additional resources (14 files)
- Online and at your own pace
- Available on the app
- Audio: English, Spanish (Latam), French, Italian, Portuguese, Turkish
- English · Spanish · Portuguese · German · French · Italian · Polish · Dutch · Turkish
- Level: Beginner
- Unlimited access forever
Recommended software & tools for this course
Google SheetsCategory
Areas
