Get started with Google Sheets with this comprehensive course for absolute beginners
**This course includes course instructor files and exercise files to work with and follow along.**
What you’ll learn
- Different ways of accessing Google Sheets and getting familiar with the Google Sheets interface.
- Working with cells, rows, and columns, including group and merge.
- PC and Mac keyboard shortcuts.
- How to apply themes, formatting, and conditional formatting.
- Inserting images, links, checkboxes, comments, and notes.
- Making use of Google Drawings to insert videos and drawings.
- Adding data validations and dropdown selections.
- How to sort and filter data in Google Sheets and working with multiple sheets.
- An overview of basic formulas and functions and how to use the Query function.
- Creating charts and graphs, learning different chart types, editing, and customizing charts.
- Sharing your sheet and collaborating with other users.
- Publishing, downloading, and printing Google Sheets files.
Course Content
- Introduction –> 6 lectures • 20min.
- Start It –> 8 lectures • 51min.
- Insert It –> 6 lectures • 46min.
- Organize It –> 6 lectures • 41min.
- Work with It –> 6 lectures • 42min.
- Graph It –> 4 lectures • 29min.
- Share It –> 4 lectures • 17min.
- Closing –> 1 lecture • 2min.
Requirements
**This course includes course instructor files and exercise files to work with and follow along.**
Discover how to use Google’s popular online spreadsheet application with this comprehensive beginner course for Google Sheets. This application is perfect for collaboration as it allows you and other users to work on the same spreadsheet at once and have all your changes saved in real-time. No more conflicting changes and lost work! Think of it as using Excel, only better.
In this Google Sheets for Beginners course, we start from the very beginning, where we teach you how to create a sheet from scratch. We’ll work through rows and columns, themes, formatting, and a handful of keyboard shortcuts. We’ll also cover inserting images, checkboxes, and comments as well as using Google Drawing.
This course also discusses data cleanup and data validation, including how to create dropdown menus. We then move on to basic formulas and functions, sorting and filtering, working with multiple sheets, adding graphs and charts, and sharing your sheet.
This is a beginner-level course designed for Google Sheets novices who would like to get started with spreadsheets and is suitable for both PC and Mac users. We’ve also included accessible exercise and instructor files the same Google Sheets files that the instructor used in the tutorial so you can follow along.
What you’ll learn from this course:
- Different ways of accessing Google Sheets
- Getting familiar with the Google Sheets interface
- Working with cells, rows, and columns, including group and merge
- PC and Mac keyboard shortcuts
- How to apply themes, formatting, and conditional formatting
- Inserting images, links, checkboxes, comments, and notes
- Making use of Google Drawing to insert videos and drawings
- Adding data validations and dropdown selections
- How to sort and filter data in Google Sheets
- An overview of basic formulas and functions
- How to use the Query function
- Working with multiple sheets
- Creating charts and graphs and learning different chart types
- Editing and customizing charts
- Sharing your sheet and collaborating with other users
- Publishing, downloading, and printing Google Sheets files
This course includes:
- 4 hours of video tutorials
- 38 individual video lectures
- Course and exercise files to follow along
- Certificate of completion