
Master the basics of Google Sheets, including Google Drive, navigation, structure, formatting, and essential formulas, to build a five-year pro forma and a one-year monthly budget.
Sign in to Google Drive and learn four ways to work with Google Sheets: templates, blank sheets, importing Microsoft files, and converting Excel files.
Explore the foundations of Google Sheets, including the structure of spreadsheets with columns, rows, and cells; name ranges; and efficient navigation using keyboard shortcuts and the formula bar.
Explore the Google Sheets menu bar and the concept of sheets within a workbook, including file imports and exports, charts, formatting, sorting, and adding or renaming sheets.
Master formatting in Google Sheets by adjusting row heights and column widths, applying auto size, hiding and unhiding sheets, and using essential shortcuts for copy, paste, and formatting.
Explore the Google Sheets formatting bar to quickly format numbers, fonts, borders, and merged cells, using paint format and quick shortcuts to tell clear data stories.
Master basic formulas and functions in Google Sheets, including addition, subtraction, multiplication, division, and parentheses. Learn to reference cells and build complex calculations for the entrepreneur.
Explore five common Google Sheets functions—sum, average, count, min, max—and learn quick entry, autofill, copy-paste formulas, and anchoring with F4 to protect references.
Create a comprehensive five-year financial model in Google Sheets, covering revenue, cogs, gross profit and margin, and below-the-line expenses to produce a complete pro forma for investors.
Build a monthly operating budget in Google Sheets, detailing starting cash, revenue, expenses by category (product and service direct expenses, R&D, sales and marketing, general and administrative), and capital contributions.
Welcome to GOOGLE SHEETS for ENTREPRENEURS & SMALL BUSINESS OWNERS!
This is a HANDS ON, working course. So, although its short, its POWERFUL. We'll cover Google Drive, Google Sheets and how to use this dynamic tool to create business solutions for your small business or startup (heck, it even works for big businesses!). The two tools that we'll build FROM SCRATCH are:
A Five Year Financial Model
A Detailed Operating Budget
We're going to cover EVERYTHING you need in this course to be successful:
Chapter 3, we're going to cover the basics and getting started with Google Drive.
Chapter 4, we're going to cover the basics of Google Drive and Spreadsheets. How to upload them, convert them and the four ways that you can work on them.
Chapter 5, we're going to cover the Spreadsheet structure and how to use the shortcut commands and the menu bar to make your life easier.
Chapter 6, we're going to cover cover how you can format rows, columns and sheets!
Chapter 7, we'll continue the formatting fun and we'll cover formatting everything using the formatting bar.
Chapter 8, we'll explore the power of formulas and how they can be used in spreadsheets.
Chapter 9, we'll wrap things up with a conversation on functions and we'll use the most common ones.
This is where things get fun! We'll take everything we've learned and we'll build the two tools I mentioned above. We'll first build a five year financial model and we'll finish the course by building a Detailed Twelve (12) Month Operating Budget.
The Result:
You'll be ready to deploy Google Sheets into your business. You'll have two working templates that you can use however and wherever you want! Its going to be a fun course.
We'll see you in class.