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

• Introduction
• Introduction to Spreadsheets
• Creating the Workbook
• The Analysis
• Additional Tips and Tricks
• Final project

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!

• About Me
• Influences
• The Finished Workbook
• The Formulas
• 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
• Measuring Performance: Tasks
• Measuring Performance: Orders with Pivot Tables
• Measuring Performance: Date Formulas
• Measuring Performance: Creating Charts
• Printing
• Getting Help with Formulas
• Excel for Creative Projects and Small Business