Last updated 5/2019MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 833.98 MB | Duration: 3h 0m

Help keep life's details organized and make sense out of chaotic events.

What you'll learn
AT HOME: Ever wanted to build your own easy, yet powerful home budget Or keep track of your kids' school/athletic progress IN BUSINESS: Track income/expenses, create robust data visualization to track trends and make better business decisions, and more!
Requirements
A working computer and a free Google account. That's it! We'll start with the very basics and go super advanced!
Description
Google Sheets, the free and powerful spreadsheet program offered through Google, gives anybody the ability to organize information and distill telling insights from otherwise disparate data.
This course is designed for everyone, regardless if you're a spreadsheet master or never even opened the program. We'll cover every topic; numbers, formatting, organization, automation, sorting, filtering and MUCH more.
Perfect for keeping track of personal events, like budgeting, party RSVPs or your kids' school growth, or business applications like income tracking, etc.
Taught by an engaging American English speaker who learned Google Sheets for keeping track of his own businesses, this course is designed to get you up to speed and computing like a pro in Google Sheets in no !

Overview

Section 1: Nice To Meet You!

Lecture 1 Meet The Course Creator!

Section 2: Introduction

Lecture 2 Opening A Google Account & How To Use It

Lecture 3 Simple Walkthrough of Google Sheets

Lecture 4 Housekeeping: Keeping Google Sheets Organized in Google Drive

Lecture 5 Understanding Rows, Columns & Cells

Section 3: Bner Formatting

Lecture 6 Formatting Text in Your Sheet

Lecture 7 Text Wrapping

Lecture 8 OOPS! Fixing Mistakes in Your Sheets

Lecture 9 Chag Row & Column Sizes

Lecture 10 Meg Cells (2 -> 1)

Lecture 11 Format Painter

Lecture 12 (Breaking Down) Borders

Lecture 13 Chag Cell Colors

Lecture 14 The Alternating Colors Tool

Lecture 15 Freezing Rows & Columns

Section 4: Working With Information: Basics

Lecture 16 Working With Numbers, 1...2...3

Lecture 17 Basic Formulas

Lecture 18 Sorting Information in Your Sheets

Lecture 19 Filtering Information in Your Sheets

Lecture 20 The Magic Blue Dot in The Bottom Right Corner

Lecture 21 BONUS Auto-Sum & Average Bonus Tool

Lecture 22 Intro to Data Validation

Section 5: Essential Formatting & Analysis Tricks

Lecture 23 Creating Dropdown Lists Using Data Validation

Lecture 24 Intro to Conditional Formatting

Lecture 25 Paste Special

Lecture 26 Inserting Images

Section 6: Intermediate Google Sheets

Lecture 27 Creating Multi-Tab Formulas

Lecture 28 Count & CountA Functions

Lecture 29 Rounding Function

Lecture 30 SumIf, CountIf Function

Lecture 31 Split Text To Columns

Lecture 32 Concatenate Function Intro

Lecture 33 Concatenate Alternatives

Lecture 34 VLookup

Lecture 35 Visualizing Data Using Graphs & Charts

Lecture 36 Pivot Tables

Section 7: Real Life Applications of Google Sheets

Lecture 37 EXERCISE: Let's Build a Home or Work Budget

Individuals, couples, small business owners...anyone who wants an easy way to keep powerful control over their complex daily lives!

HomePage:

https://www.udemy.com/course/best-google-sheets-course/