The Complete Google Sheets Course: Beginner to Advanced!
- Descrição
- Currículo
- FAQ
- Revisões
In this course you will learn the fundamentals of Google Sheets (some of which translates to Microsoft Excel!). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like VLOOKUP, INDEX(MATCH()MATCH()), and IMPORTRANGE.
Never heard of those before? Don’t worry! I start from the beginning – so those terms will become clear when the time is right.
Along the way, you will develop an amazing spreadsheet toolkit. Wondering what tools will be in that toolkit? Check out the list below for some highlights of the course:
-
Learn the basics like how to create a Google Account and a Google Spreadsheet
-
Arithmetic Functions like SUM, COUNT, and AVERAGE
-
Shortcuts like filling formulas across THOUSANDS of cells
-
Advanced charts & Beautiful Visualizations
-
PIVOT TABLES – though I don’t particularly like them…
-
Advanced functions like INDEX MATCH MATCH and IMPORT RANGE
-
QUERY, the function that DOES IT ALL!
Ultimately, the point of this course is to get some awesome skills for professional or personal use. And – above all – have fun doing it!
My course isn’t like a lot of other online Excel or Google Sheet courses. Most of these courses force you to watch them build things and hope that you understand what they are doing. Instead of that old model, I’ve incorporated everything I’ve learned from my experience in the real professional world to make this the best online Google sheets course. The course includes:
-
Lectures
-
Activities
-
Projects
-
Exercises
-
Slides
-
Comprehensive Workbooks WITH Answer Keys
-
Extra Learning Resources
If you have any questions, please don’t hesitate to contact me. Sign up today and see how fun, exciting, and rewarding web development can be!
There are some updates to Google Sheets like Tables and others. We may be adding more content to the course to address these – stay tuned!
-
1Introduction: MANDATORY PLEASE READTexto
Students will be able to create a Google account & spreadsheet.
-
2Pre-Work: Creating a Google Drive AccountVídeo Aula
-
3Pre-Work: Creating a copy of my Spreadsheet Templates!Vídeo Aula
-
4Spreadsheet Basics! What are they and how do they work?Vídeo Aula
-
5Toolbar WalkthroughVídeo Aula
-
6Data Types in a SpreadsheetVídeo Aula
-
7Navigating Spreadsheets with Shortcuts!Vídeo Aula
-
8Simple Formatting Tricks - Beautify your Spreadsheets!Vídeo Aula
-
13The IF StatementVídeo Aula
-
14AND/OR StatementsVídeo Aula
-
15Nesting IF Statements & the IFS StatementVídeo Aula
-
16Solution to Activity & Crash Course in Conditional Formatting!Vídeo Aula
-
17Conditional Arithmetic Functions (ie. SUM + IF)Vídeo Aula
-
18HW Problem Solution & Wrap UpVídeo Aula
-
19Introduction to Raw data and the new Section FormatVídeo Aula
-
20Crash Course in Pivot Tables Part IVídeo Aula
-
21Crash Course in Pivot Tables Part IIVídeo Aula
-
22Intro to Activity: Building a Pivot Table for the Dumpling BusinessVídeo Aula
-
23Sorting & Filtering Part IVídeo Aula
-
24Sorting & Filtering Part IIVídeo Aula
-
25Sorting & Filtering Part IIIVídeo Aula
-
26NOTE: There is a small error in the next lecture!Texto
-
27Solution to Activity: Sorting & Filtering!Vídeo Aula
-
28Wrapping Up: Cool Applications of Sort & FilterVídeo Aula
-
33What is Data Validation?Vídeo Aula
-
34Data Validation: Hands on ActivitiesVídeo Aula
-
35Creating Basic Dynamic ModelsVídeo Aula
-
36Intro to Activity: Beginner Data Validation & Intermediate ModelingVídeo Aula
-
37Solution to Activity: Beginner Data Validation & Intermediate ModelingVídeo Aula
