Best seller

Google Sheets for Creative Projects and Small Business

VLOOKUP and How It Works

A course by Pete Raho , Craftsman and Entrepreneur

Best seller

100% positive reviews (88)

7,195 students

Audio: English

· · · · · · ·

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

“ VLOOKUP and How It Works The VLOOKUP formula is the most powerful when dealing with spreadsheets. What it allows you to do is take some big list of records, a big list of orders we have, like in our order spreadsheet, and it goes 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 a person's name, the price they paid, or whatever. It allows you to take a big spreadsheet of information and pull out one particular value. In our case here, we'll be using it to first find the person's name and print that...”

This transcript is automatically generated, so it may contain mistakes.

Course summary for: Google Sheets for Creative Projects and Small Business

Level: Beginner
100% positive reviews (88)
7195 students
5 units
16 lessons (1h 56m)
14 downloads

Category
Marketing & Business
Software
Google Sheets
Areas
Business, Management & Productivity

Pete Raho

A course by Pete Raho

Teacher Plus

Craftsman and Entrepreneur

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.