From managing spreadsheets to using formulas, this Google Sheets course covers it all. Get hands-on and level up your skills! Read more.
Passionate tech instructor with experience of educating students and professionals in the ever-evolving world of technology.
Buy this course for $199 $10
and keep lifetime access.
Access all courses in our library for only $9/month with All Access Pass
About This Course
Who this course is for:
- Beginners with no prior experience in Google Sheets
- Individuals looking to improve their data management skills
- Professionals seeking to enhance their spreadsheet proficiency for personal or work use
- Students or job seekers aiming to learn a powerful cloud-based spreadsheet tool
What you’ll learn:Â
- Creating and Managing Spreadsheets: Learn how to set up and organize spreadsheets efficiently.
- Importing Data: Master the process of importing data from various sources into Google Sheets.
- Basic Formulas and Functions: Build proficiency in using basic formulas to perform calculations and analyze data.
- Sorting and Filtering Data: Explore techniques for sorting and filtering data to uncover valuable insights.
- Formatting Spreadsheets: Learn how to format cells, rows, and columns for improved clarity and visual appeal.
- Collaboration Features: Discover how to share and collaborate on spreadsheets in real-time, boosting teamwork and productivity.
Requirements:Â
- Gmail account
- A computer or device with internet access
- Basic computer skills, including browsing the web and typing on a keyboard
This beginner-friendly Google Sheets course online offers hands-on activities and practical exercises to help learners not only understand theoretical concepts but also put them into practical use effectively in real-world situations.
Ready to become a lifelong learner? My courses are designed to inspire and educate.
Our Promise to You
By the end of this google sheets course, participants will have the skills needed to confidently and efficiently use Google Sheets in both personal and professional settings.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today!
Course Curriculum
Section 1 - Google Sheet | |||
Introduction And Accessing Google Sheet | 00:00:00 | ||
Navigating In Cells And Menu | 00:00:00 | ||
Keyboard Shortcut | 00:00:00 | ||
Editing Cell Content | 00:00:00 | ||
Templates | 00:00:00 | ||
Using Explore | 00:00:00 | ||
Opening And Saving Sheets | 00:00:00 | ||
Using Google Sheet With Google Drive | 00:00:00 | ||
Showing And Using The Formula Bar And Gridlines | 00:00:00 | ||
Using Autofill To Copy Formula | 00:00:00 | ||
Using Autofill To Create Redundant Data | 00:00:00 | ||
Simple Formulas | 00:00:00 | ||
Formulas With Absolute References | 00:00:00 | ||
Cut, Copy, Paste | 00:00:00 | ||
Inserting Rows And Columns | 00:00:00 | ||
Wrapping Text, Rotating And Aligning Cells | 00:00:00 | ||
Cell Formatting | 00:00:00 | ||
Hiding Rows And Columns | 00:00:00 | ||
Freeze Panes And Full Screen View | 00:00:00 | ||
Spell Check And Printing | 00:00:00 | ||
Sharing And Emailing Sheets | 00:00:00 | ||
Publishing To Web | 00:00:00 | ||
List, Format And Sort | 00:00:00 | ||
Multi-Column Sort | 00:00:00 | ||
Filters | 00:00:00 | ||
Conditional Filters And Filtered Views | 00:00:00 | ||
Creating Charts | 00:00:00 | ||
Editing Charts | 00:00:00 | ||
Removing And Deleting Chart Data | 00:00:00 | ||
Sparklines | 00:00:00 | ||
Formatting With Alternating Row Colors | 00:00:00 | ||
Pivot Tables | 00:00:00 | ||
Pivot Charts | 00:00:00 | ||
Named Ranges | 00:00:00 | ||
If Functions | 00:00:00 | ||
Nested Functions | 00:00:00 | ||
VLOOKUP | 00:00:00 | ||
SUMIFS | 00:00:00 | ||
AVERAGEIFS | 00:00:00 | ||
IFERROR | 00:00:00 | ||
Left And Right | 00:00:00 | ||
Concatenate | 00:00:00 | ||
Sharing Files | 00:00:00 | ||
Real – Time Authoring | 00:00:00 | ||
Google Sheets Add-Ons | 00:00:00 | ||
Introduction To Google Apps Scripts | 00:00:00 |
About This Course
Who this course is for:
- Beginners with no prior experience in Google Sheets
- Individuals looking to improve their data management skills
- Professionals seeking to enhance their spreadsheet proficiency for personal or work use
- Students or job seekers aiming to learn a powerful cloud-based spreadsheet tool
What you’ll learn:Â
- Creating and Managing Spreadsheets: Learn how to set up and organize spreadsheets efficiently.
- Importing Data: Master the process of importing data from various sources into Google Sheets.
- Basic Formulas and Functions: Build proficiency in using basic formulas to perform calculations and analyze data.
- Sorting and Filtering Data: Explore techniques for sorting and filtering data to uncover valuable insights.
- Formatting Spreadsheets: Learn how to format cells, rows, and columns for improved clarity and visual appeal.
- Collaboration Features: Discover how to share and collaborate on spreadsheets in real-time, boosting teamwork and productivity.
Requirements:Â
- Gmail account
- A computer or device with internet access
- Basic computer skills, including browsing the web and typing on a keyboard
This beginner-friendly Google Sheets course online offers hands-on activities and practical exercises to help learners not only understand theoretical concepts but also put them into practical use effectively in real-world situations.
Ready to become a lifelong learner? My courses are designed to inspire and educate.
Our Promise to You
By the end of this google sheets course, participants will have the skills needed to confidently and efficiently use Google Sheets in both personal and professional settings.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today!
Course Curriculum
Section 1 - Google Sheet | |||
Introduction And Accessing Google Sheet | 00:00:00 | ||
Navigating In Cells And Menu | 00:00:00 | ||
Keyboard Shortcut | 00:00:00 | ||
Editing Cell Content | 00:00:00 | ||
Templates | 00:00:00 | ||
Using Explore | 00:00:00 | ||
Opening And Saving Sheets | 00:00:00 | ||
Using Google Sheet With Google Drive | 00:00:00 | ||
Showing And Using The Formula Bar And Gridlines | 00:00:00 | ||
Using Autofill To Copy Formula | 00:00:00 | ||
Using Autofill To Create Redundant Data | 00:00:00 | ||
Simple Formulas | 00:00:00 | ||
Formulas With Absolute References | 00:00:00 | ||
Cut, Copy, Paste | 00:00:00 | ||
Inserting Rows And Columns | 00:00:00 | ||
Wrapping Text, Rotating And Aligning Cells | 00:00:00 | ||
Cell Formatting | 00:00:00 | ||
Hiding Rows And Columns | 00:00:00 | ||
Freeze Panes And Full Screen View | 00:00:00 | ||
Spell Check And Printing | 00:00:00 | ||
Sharing And Emailing Sheets | 00:00:00 | ||
Publishing To Web | 00:00:00 | ||
List, Format And Sort | 00:00:00 | ||
Multi-Column Sort | 00:00:00 | ||
Filters | 00:00:00 | ||
Conditional Filters And Filtered Views | 00:00:00 | ||
Creating Charts | 00:00:00 | ||
Editing Charts | 00:00:00 | ||
Removing And Deleting Chart Data | 00:00:00 | ||
Sparklines | 00:00:00 | ||
Formatting With Alternating Row Colors | 00:00:00 | ||
Pivot Tables | 00:00:00 | ||
Pivot Charts | 00:00:00 | ||
Named Ranges | 00:00:00 | ||
If Functions | 00:00:00 | ||
Nested Functions | 00:00:00 | ||
VLOOKUP | 00:00:00 | ||
SUMIFS | 00:00:00 | ||
AVERAGEIFS | 00:00:00 | ||
IFERROR | 00:00:00 | ||
Left And Right | 00:00:00 | ||
Concatenate | 00:00:00 | ||
Sharing Files | 00:00:00 | ||
Real – Time Authoring | 00:00:00 | ||
Google Sheets Add-Ons | 00:00:00 | ||
Introduction To Google Apps Scripts | 00:00:00 |