Google Sheets For Beginners: Create a Simple File Tracker
Sharon Sheppard, Your Google Workspace Guide
Watch this class and thousands more
Watch this class and thousands more
Lessons in This Class
-
-
1.
Intro
1:54
-
2.
Class Project
0:44
-
3.
Where & How to Access Google Sheets
1:18
-
4.
Rename, Star + Customise Your Sheet
4:25
-
5.
What Details to Include
4:32
-
6.
NEW Google Sheets Tables Update
14:33
-
7.
How to Freeze Rows & Columns
3:13
-
8.
How to Insert Links into Cells
1:53
-
9.
All About Dropdown Lists
5:26
-
10.
Using Data Validation for Date Cells
2:22
-
11.
How to Insert Notes
1:50
-
12.
How to Add Coloured Rows
3:04
-
13.
How to Apply & Use Filters
2:58
-
14.
How to Set Your Sheet Ready for Printing
7:09
-
15.
Wrap Up
1:01
-
-
- --
- Beginner level
- Intermediate level
- Advanced level
- All levels
Community Generated
The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.
98
Students
1
Projects
About This Class
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:
- The different ways to access a blank Google Sheet
- How to rename the file for better organisation
- How to change text fonts, size and colours
- How to create & edit dropdown lists
- How to add links to cells
- How to use data validation to format cells for dates
- How to insert notes to remind you what the columns do
- How to apply and use filters in the sheet
- How to set up the sheet ready for printing
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:
- an active Google account (free or paid),
- a computer,
- an internet connection.
I hope you enjoy this class, and if you have any questions, please feel free to reach out to me.
Sharon x
Meet Your Teacher
I'm Sharon!
I'm a Virtual Assistant, YouTube content creator, and Google Ninja.
A few of my clients have called me the 'Workspace Whisperer' as I love sharing timesaving tips, tools and features, specifically using the free version of Google Workspace.
I'm on a mission to help solopreneurs, freelancers, and small business owners get to grips with all things Google, through online courses and step-by-step tutorials. My aim is to help you be more productive using the free version of Google apps, to show you that you don't need complicated, expensive systems to have a well-oiled, efficient admin process.
I send out a fortnightly email containing a handy walk-through of a feature, tool or task you can do in your Google Workspace - if you'd like to sign up please ... See full profile
Hands-on Class Project
By the end of the class, you will have your own File Tracker sheet, which you will have customised with your own choice of fonts, colours and styles to make it your own - take a screenshot of your sheet and upload that into your project area.
I can't wait to see what you come up with!
Class Ratings
Why Join Skillshare?
Take award-winning Skillshare Original Classes
Each class has short lessons, hands-on projects
Your membership supports Skillshare teachers
Learn From Anywhere
Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.
