Best seller

Google Sheets for Creative Projects and Small Business

Formulas on the Invoice

A course by Pete Raho , Craftsman and Entrepreneur

Best seller

100% positive reviews (90)

7,497 students

Audio: English, Italian, Portuguese

· · · · · · ·

About the video: Formulas on the Invoice

Overview

“In this lesson, I'll show you how to create formulas using VLOOKUP. I'll also talk about FILTER and SUM, along with some new tools to develop your invoice. ”

In this video lesson Pete Raho addresses the topic: Formulas on the Invoice, 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

“Now let's put together our invoice. We're going to use VLOOKUP that we just learned, as well as our old friends, fILTER and SUM. So just like we did with our dashboard tab, we're going to click on the plus And then we're going to rename it invoice. And we can give it a jazzy color if you like. Let's make it green. All right. So with our invoice, what we're going to do is we're going to use this to display the information from our orders tab in a much nicer, more effective way so we can print out something. But basically all the information for the invoice lives on the order tab. We're just ...”

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 (90)
7497 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.