Why do you need Google Sheets? Because the business world is changing and Google Sheets is the best spreadsheet application out there to meet your needs! Welcome to the course that will help you have a smooth start into the world of data organization and data presentation!
In the upcoming video sessions on Google sheets, we’ll build the basics you need. We’ll go through the key features that will help you gain confidence and increase your productivity immensely. You do need sheets more than you suppose. Because I’m sure you’re working with others, you’re collaborating with your teammates every day. I’ll show you how to make Sheets help you. Because I’m sure you need your data and visualizations up-to-date - now, in this meeting. Not a recent version saved on someone’s computer - but the latest one, the one that was updated a minute ago. This is what Sheets can do for you.
In the course you’re about to start, we’ll first head for the the big picture:
how to create a blank sheet document,
how to resize your rows and columns,
how to format a cell,
how to add checkboxes,
how to format your date,
how to use the very, very basic functions in sheets.
It’s not by chance that each and every lecture for the course answers the question HOW - how to do this or that, how to find an answer to your problem. That’s what you’ll actually need every day - that’s what you’ll get here structured and practised with a lot of exercises.
Then we’re moving to what Sheets can do for you - if you know how to ask for it :)
How to continue working in Sheets when offline for example.
How to email your spreadsheet file from the application directly.
How to add a table of contents to your document.
How to switch between different versions of your data file.
When these are clarified, we’ll dig a little deeper. Once you cover all lectures, you’ll also know
how to validate your data,
how to sort and filter it,
how to handle the various errors that come up all the time,
how to take advantage of the conditional formatting rules,
how to use some of the most common advanced functions in Sheets… and much, much more!
After each video you’ll find a file with the data we’re operating on. You’ll have the raw data, so that you can follow along, as well as the answers, the final version of the file. In order to take the most out of the course, it’s my strong advise to follow along. Google sheets, similar to other applications, can be mastered only when practised, on a daily basis. Ready to start?
