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.

Organise Your Google Drive Files: Create a Simple File Tracker using Google Sheets
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
Free

This Course Includes
skillshare
0 (0 reviews )
42 minutes
english
Online - Self Paced
course
SkillShare
About Organise Your Google Drive Files: Create a Simple File Tracker using Google Sheets
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.