IIRF Online > Office Productivity > Google > Google Sheets > The Complete Google Sheets Course: Beginner to Advanced!
The Complete Google Sheets Course: Beginner to Advanced! by Udemy
A crash course in basic to advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too!
Course Highlights
- Create beautiful spreadsheets with amazing formatting tricks
- Learn to manipulate text in formulas
- Connect multiple Google Sheets together using a single formula
- Analyze data sets with ease using complex functions & formulas
- Learn to build incredible data visualizations using charts
- Feel completely comfortable in a spreadsheet environment
- Learn formulas that work in both Google sheets & Excel!
Skills you will learn!
Curriculum
8 Topics
Introduction: MANDATORY PLEASE READ
Pre-Work: Creating a Google Drive Account
Pre-Work: Creating a copy of my Spreadsheet Templates!
Spreadsheet Basics! What are they and how do they work?
Toolbar Walkthrough
Data Types in a Spreadsheet
Navigating Spreadsheets with Shortcuts!
Simple Formatting Tricks - Beautify your Spreadsheets!
4 Topics
Get Familiar with SUM COUNT AVERAGE & MORE!
More Simple Functions: COUNTA MIN & MAX
Intro to Activity: Your First Day at the Dumpling Stand
Solution to Activity: Your First Day at the Dumpling Stand
6 Topics
The IF Statement
AND/OR Statements
Nesting IF Statements & the IFS Statement
Solution to Activity & Crash Course in Conditional Formatting!
Conditional Arithmetic Functions (ie. SUM + IF)
HW Problem Solution & Wrap Up
10 Topics
Introduction to Raw data and the new Section Format
Crash Course in Pivot Tables Part I
Crash Course in Pivot Tables Part II
Intro to Activity: Building a Pivot Table for the Dumpling Business
Sorting & Filtering Part I
Sorting & Filtering Part II
Sorting & Filtering Part III
NOTE: There is a small error in the next lecture!
Solution to Activity: Sorting & Filtering!
Wrapping Up: Cool Applications of Sort & Filter
4 Topics
Intro to Charts & Graphs
Creating Charts in Google Sheets
Intro to Activity: Creating AMAZING Visuals
Solution to Activity: Creating AMAZING Visuals
5 Topics
What is Data Validation?
Data Validation: Hands on Activities
Creating Basic Dynamic Models
Intro to Activity: Beginner Data Validation & Intermediate Modeling
Solution to Activity: Beginner Data Validation & Intermediate Modeling
4 Topics
Every error you need to know and how to fix 'em
The IFERROR formula. A machine to keep your spreadsheets clean!
Named Ranges - Prehabbing before you mess up your formulas!
Activity with Solutions - Another Day at the Dumpling Stand!
4 Topics
Let's get into the VLOOKUP Function! Also HLOOKUP...I guess
Activity: Housing Info with VLOOKUP & HLOOKUP
The BEST Lookup Formula! (INDEX(MATCH()MATCH()))
Activity: Finding Information with VLOOKUP & INDEX(MATCHMATCH())
4 Topics
Introduction to Text Functions: Adding words together and changing their case!
Using LEFT RIGHT LEN and more to extract characters from cells!
Activity: Extracting First & Last Names from a cell!
TRIM & Final Activity with Solutions!
4 Topics
Simple but essential date & time functions: TODAY & NOW!
Date Functions Continued! EDATE EOMONTH and MORE!
Exercise Solution: The Countdown Clock!
Synthesizing Sections: An Interactive Calendar
4 Topics
Randomizing using RAND & RANDBETWEEN!
Rounding Out the Numbers with ROUND ROUNDUP and ROUNDDOWN!
Activity Intro: Build a Meal Randomizer!
Activity Solutions: Build a Meal Randomizer!
3 Topics
Introduction to GOOGLEFINANCE: Get Stock Information INSTANTLY!
Introduction to GOOGLETRANSLATE: Become a Polyglot!
Activity: Creating the Stock Picker & Translator!
6 Topics
Pull Spreadsheets together from ALL OVER the Google sheets universe!
CRASH Course in SQL! Introduction to SQL jargon and logic!
Building QUERY() in your Spreadsheet!
Mixing QUERY() with IMPORTRANGE(): Achieve Greatness.
QUERY() with IMPORTRANGE() Activity: Apply EVERYTHING to Analyze some Data!
The Final Lecture: Create Cell References within QUERY()!
The Complete Google Sheets Course: Beginner to Advanced!
Related Google Sheets Courses
Thank You!
Your review has been submitted successfully.