Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 42 Minute(s)
Language
English
Taught by
E R
Rating
Course Overview
Learn to become a Google Sheets master. Data used is shared, you are encouraged to follow along!
Save time at your job and build marketable skills by mastering Google Sheets. This course takes you from beginner level to intermediate/advanced (think industry analyst level). You'll learn how to:
- Create, name, share sheets
- Format sheets, best practices
- Conditional formatting
- Filter and sort data
- Use TEXT functions to clean/manipulate data
- CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE
- Use basic math functions, including
- SUM
- AVERAGE
- COUNT
- MIN
- MAX
- ROUND
- More advanced math functions
- SUMIFS
- COUNTIFS
- AVERAGEIFS
- Create and customize charts
- Pivot tables
- Lookups
- VLOOKUP, INDEX/MATCH
- Use logical functions such as IF, OR, AND
- Use INDIRECT and pair with INDEX/MATCH
- Link data together from multiple spreadsheets using IMPORTRANGE
This course will give you you everything you need to know about Google Spreadsheets, an increasingly important tool and rapidly growing in the enterprise sector.
Additionally, this course will provide you with the example sheets covered, so you can follow along! How fun :)
Course Content
- 7 section(s)
- 20 lecture(s)
- Section 1 Introduction
- Section 2 The Basics
- Section 3 Sort, Filter, and Clean Data (beginner level)
- Section 4 Charts, charts, and more charts! (beginner, but good refresher for most)
- Section 5 Pivots, lookups, logicals (faster-paced, higher-level topics)
- Section 6 My favorite keyboard shortcuts/time savors (extra)
- Section 7 Bonus lectures!
What You’ll Learn
- Use Google Spreadsheets at an intermediate/advanced level
- Format data, create charts and tables
- Quickly manipulate and clean data to uncover trends and communicate actionable insights
- Link data across multiple interdependent Google Sheets using ImportRange
- Display stock price information and set up a portfolio tracker
- Much, much more (think helpful tips + shortcuts + best practices)
Skills covered in this course
Reviews
-
GGerald Schaufler
sound quality could be better
-
JJohn Cousins
Helpful and mostly clear. The examples to work with were helpful. I think more written materials and data examples that better show the utility of each function would help make this better.
-
BBill Hengen
This is a really good introduction to google sheets. Covers all of the basic stuff to get you up and running... Well done!
-
DDavid Lewis
Great course, gave me a great starting point to start producing some complex reports for work.
