Excel for Creative Projects and Small Business
A course by Pete Raho , Craftsman and Entrepreneur
Joined March 2022
Learn to create effective solutions for your projects or business using spreadsheets to manage your tasks, budget, and sales using its tools and formulas
- 95% positive reviews (83)
- 5636 students
- Audio: English
- English, Spanish, Portuguese, German, French, Italian, Polish, Dutch
Learn to create effective solutions for your projects or business using spreadsheets to manage your tasks, budget, and sales using its tools and formulas
Let’s face it: Excel and Google Sheets can be daunting programs for beginners. However, they’re also a force to be reckoned with, as they are powerful tools for business and project management. Luckily, creative people like Peter Raho exist. As a craftsman and entrepreneur looking for solutions of his own, he took on the challenge to learn the program, and he’s here to teach you how to use it to your advantage.
In this online course, learn how to use Google Sheets to create personalized solutions for your project or business. Peter shares with you easy-to-follow steps on how to create custom spreadsheets to organize your workflow. Learn how to write formulas, create tasks, report data with charts, and more!
What will you learn in this online course?
16 lessons & 22 downloads
- 95% positive reviews (83)
- 5636 students
- 16 lessons (1h 56m)
- 22 additional resources (14 files)
- Online and at your own pace
- Available on the app
- Audio: English
- English, Spanish, Portuguese, German, French, Italian, Polish, Dutch
- Level: Beginner
- Unlimited access forever
Recommended software for this course
Google SheetsWhat is this course's project?
Create a workbook in Google Sheets that allows you to add information about projects, create invoices, and report data.
Projects by course students
Who is this online course for?
This course is for anyone who wants to create simple, customized tools for their business or project.
Requirements and materials
No previous experience required.
All you need is access to Google Sheets.
Reviews
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.
Content
-
U1
Introduction
-
About Me
-
Influences
-
-
U2
Introduction to Spreadsheets
-
The Finished Workbook
-
The Formulas
-
-
U3
Creating the Workbook
-
Creating the Dashboard, Orders, and the Filter Function
-
Adding Tasks to the Dashboard, Dates, and the IF Function
-
Formatting the Dashboard
-
VLOOKUP and How It Works
-
Formulas on the Invoice
-
Formatting the Invoice
-
-
U4
The Analysis
-
Measuring Performance: Tasks
-
Measuring Performance: Orders with Pivot Tables
-
Measuring Performance: Date Formulas
-
Measuring Performance: Creating Charts
-
-
U5
Additional Tips and Tricks
-
Printing
-
Getting Help with Formulas
-
-
FP
Final project
-
Excel for Creative Projects and Small Business
-
What to expect from a Domestika course
-
Learn at your own pace
Enjoy learning from home without a set schedule and with an easy-to-follow method. You set your own pace.
-
Learn from the best professionals
Learn valuable methods and techniques explained by top experts in the creative sector.
-
Meet expert teachers
Each expert teaches what they do best, with clear guidelines, true passion, and professional insight in every lesson.
-
Certificates
PlusIf you're a Plus member, get a custom certificate signed by your teacher for every course. Share it on your portfolio, social media, or wherever you like.
-
Get front-row seats
Videos of the highest quality, so you don't miss a single detail. With unlimited access, you can watch them as many times as you need to perfect your technique.
-
Share knowledge and ideas
Ask questions, request feedback, or offer solutions. Share your learning experience with other students in the community who are as passionate about creativity as you are.
-
Connect with a global creative community
The community is home to millions of people from around the world who are curious and passionate about exploring and expressing their creativity.
-
Watch professionally produced courses
Domestika curates its teacher roster and produces every course in-house to ensure a high-quality online learning experience.
FAQs
Domestika's courses are online classes that provide you with the tools and skills you need to complete a specific project. Every step of the project combines video lessons with complementary instructional material, so you can learn by doing. Domestika's courses also allow you to share your own projects with the teacher and with other students, creating a dynamic course community.
All courses are 100% online, so once they're published, courses start and finish whenever you want. You set the pace of the class. You can go back to review what interests you most and skip what you already know, ask questions, answer questions, share your projects, and more.
The courses are divided into different units. Each one includes lessons, informational text, tasks, and practice exercises to help you carry out your project step by step, with additional complementary resources and downloads. You'll also have access to an exclusive forum where you can interact with the teacher and with other students, as well as share your work and your course project, creating a community around the course.
You can redeem the course you received by accessing the redeeming page and entering your gift code.
Google Sheets
mayflowerpie
PlusGreat step by step instructions with template. Much better than anything I could find anywhere else online
sofiamonteiro1
Gostei muito do curso. Muito fácil de entender e acessível.
Obrigada
View translation
Hide translation
blanca_araoz
Curso muy interesante aunque me gustaría que tuviera audio en español
View translation
Hide translation
lavh1525
Muy practico.
View translation
Hide translation
cmoratinose
El curso es en inglés con subtítulos y es complicado seguir las explicaciones si tienes que leer a la vez.
View translation
Hide translation