Comprehensive Beginner's Course to Google Sheets, a Powerful Online Cloud Alternative to Microsoft Excel

Google Sheet is an extremely powerful alternative to Microsoft's Excel spreadsheet software. Jon will teach you step-by-step how to create a basic spreadsheet and analyze the. This course covers all the essentials that will help you manipulate and analyze large sets of data. Of course, you will learn the fundamentals such as the basic calculations, formulas, creating charts, and tips & tricks that will get you started quickly.

By the end of this introductory course, you will feel confident maneuvering around Google Sheets and gain instincts to use it effectively for data analysis, and ultimately adding value to your company or to your own personal life.

In this course you will learn how to:

Effectively and efficiently navigate around Google Sheets
Enter and edit data in Google Sheets
Adjust the way data and information are displayed in Google Sheets
Write formulas quickly and easily
Leverage data with Vlookup, Hlookup, Index, and Pivot Tables
Use relative, absolute, and mixed references in Google Sheets
Create powerful calculations with Google Sheets functions
Visually represent your data with charts and graphs in Google Sheets
Use data tools like sorting, filtering, and filter views
Utilize freeze panes in Google Sheets
Format worksheets in Google Sheets for impact and appeal
Learn shortcuts, tips, and tricks
Learn how to use commenting and sharing in Google Sheets