O
0
Last updated 5/2019
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 833.98 MB | Duration: 3h 0m
Help keep life's details organized and make sense out of chaotic events.
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: 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 time!
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: Beginner Formatting
Lecture 6 Formatting Text in Your Sheet
Lecture 7 Text Wrapping
Lecture 8 OOPS! Fixing Mistakes in Your Sheets
Lecture 9 Changing Row & Column Sizes
Lecture 10 Merging Cells (2 -> 1)
Lecture 11 Format Painter
Lecture 12 (Breaking Down) Borders
Lecture 13 Changing 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!
Download link
rapidgator.net:
You must reply in thread to view hidden text.
uploadgig.com:
You must reply in thread to view hidden text.
nitroflare.com:
You must reply in thread to view hidden text.
1dl.net:
You must reply in thread to view hidden text.
