I Heart Google Sheets: Training for Skills Employers Want

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3.5 Hours | 809 MB

Genre: eLearning | Language: English

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