Creating a Template Spreadsheet

Learn how to create a project template spreadsheet, pre-built with your company information, logos & typical items that can be used for future projects.
Setting Up the Project Setup Sheet
Next Video

Creating a Template Spreadsheet

3:22
Learn how to create a project template spreadsheet, pre-built with your company information, logos & typical items that can be used for future projects.

Video Topics

  • 00:30 - Copy the Original Download File
  • 00:40 - Creating a Template File Folder
  • 01:00 - Open the Spreadsheet
  • 01:25 - Setup Your Company Information Sheet on the Information Sheet
  • 01:45 - Input Company Logos on All Reports
  • 02:05 - Customize your Repair Cost Items and Unit Costs on the Repair Cost Estimator
  • 02:30 - Save the Project Template File
  • 03:00 - Or Perform a 'Save As' function to Save a 'Template File' instead of 'Template Folder'

Video Transcript

Downloading the House Flipping Spreadsheet

Start to Finish Overview

Opening the Spreadsheet

Creating a New Project in Google Sheets

Enabling Macros

Authorizing the Spreadsheet

Creating a Template Spreadsheet

Project Setup for Google Sheets

Setting Up the Project Setup Sheet

Zooming In Google Sheets

Creating a New Project

Sharing the Spreadsheet

Saving the Spreadsheet

Printing the Spreadsheet in Google Sheets

Printing to a PDF