Google Sheets contains a large library of prebuilt templates to make starting your project that much easier. In this video, author Jess Stratton shows you what templates are available, how to use one, and how to find it in Google Drive once it's created.
- [Instructor] Google Sheets gives you the ability to customize the background color of the cell and to change all the font properties of the data that's in the cell. However, working on a big blank sheet can be a little overwhelming if you're not sure how to get started with your project. To help you, Google Sheets has created a large template gallery that you can use to get started on your next project. To find the template gallery point your browser to sheets.google.com or in any existing spreadsheet click the green sheets icon in the top left hand side of the screen to go to Google Sheets home.
On this screen, you can see any recently accessed files as well as files that you've accessed 30 days and beyond. You can click blank to create a new blank spreadsheet, you can also search for an existing sheet, but what I'm interested in is the more button on the right hand side. Clicking the more button will bring up many more templates that you can use to start your project. Any recently used templates are at the top of the screen. Below that they are categorized. There's personal templates such as to do lists, budgets, calendars, travel planners, even a team roster.
There's work templates such as invoices, time sheets, budgets and purchase orders. Finally all the way down at the bottom there's some education templates such as attendance records and grade books. Let's create one so that you can see how easy it is to change the data and make it your own. I'll click team roster. It's going to open up a pre formatted spread sheet. It's already set for you to create. All you have to do is replace the text that's already there.
You can even change the font properties and the colors to match your team colors. Here's the roster. I'll start putting in my own data. I can then move my mouse and keep adding to my team roster. A neat thing about this template is that in addition to giving you a team roster sheet, at the very bottom, you can change tabs to get to a new worksheet.
This is your team's schedule. Here's where you can add in the entire schedule's worth of plays including how the team did at the end of it. At any time you can go back to Google Sheets home by clicking the icon in the top left hand side of the screen. If you've been working on this for a few minutes it will save this document. If you decide that you don't want it I do recommend deleting it so that it doesn't clutter up your Google Drive. To delete it find you document that you just created, click the three dots on the right hand side and select remove.
It's going to get moved to the trash. If you find that you do need it, it's still there it's just in Google Drive. You can access Google Drive by clicking the grid icon on the top right hand side of the screen and choosing Drive. In Google Drive click in the trash folder. Here's where you can see the team roster that we just deleted. At any time you can go back to Google Sheets, click more, find some more templates and play around with them.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons