When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

SkillShare logo

Google Sheets For Beginners: Create a Simple File Tracker

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon56 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Google Sheets For Beginners: Create a Simple File Tracker

Intro

Class Project

Where & How to Access Google Sheets

Rename, Star + Customise Your Sheet

What Details to Include

NEW Google Sheets Tables Update

How to Freeze Rows & Columns

How to Insert Links into Cells

All About Dropdown Lists

Using Data Validation for Date Cells

How to Insert Notes

How to Add Coloured Rows

How to Apply & Use Filters

How to Set Your Sheet Ready for Printing

Wrap Up

What You Will Learn?

  • Does the thought of working with Google Sheets fill you with dread?.
  • Have you been putting off creating a spreadsheet that will really help you keep track of your to-do list, or your budget, because you’ve never used Google Sheets before?.
  • Maybe you’ve stopped yourself from trying it because you think you need to know long, complicated formulas to make it work..
  • Here’s the good news - you don’t need to know long complicated formulas if you don’t want to..
  • I believe that spreadsheets don't need to be all-singing, all-dancing, and full of complicated formulas... they just need to give you what you want to see..
  • So if you're a bit wary of using Google Sheets, then hopefully this class will help build up your confidence to create more sheets that work for you, remember to keep things as simple as possible, and at the end of it you will have a simple spreadsheet for you to keep track of all of your files and folders in your Google Drive, to help you feel more organised..
  • It's a win-win :).
  • What you will learn.
  • In this class I show you the steps needed to open a new Google Sheet and create your own Google Drive file tracker..
  • You will learn:.
  • This class will help you with the basics of Google Sheets, and don’t worry, I keep things as simple as possible, and the video lessons are bite sized so you won't feel overwhelmed..
  •  .
  • What you will need: .
  • To complete this class you will need:.
  • I hope you enjoy this class, and if you have any questions, please feel free to reach out to me..
  • Sharon x.