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 (88)

7,195 students

Audio: English

· · · · · · ·

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

“ Formulas on the Invoice Let's put together our invoice. We'll use VLOOKUP which we just learned as well as our old friends, FILTER and SUM. Like we did with our Dashboard tab, we'll click on the Plus and then we will rename it Invoice. We can give it a jazzy color if you like. Let's make it green. With our invoice, we'll use this to display the information from our Orders tab in a much nicer, more effective way so we can print out something. All the information for the invoice lives on the Orders tab, we'll just use a few formulas on this tab to display it nicely. In cell A6, I'll type Or...”

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.