Learn Google Sheets interactively using openly shared data!
Learn to become a Google Sheets master. Data used is shared, you are encouraged to follow along!
Created by Erik Rood
30-Day Money-Back Guarantee
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)
Requirements
- You will need to have a Google account to follow along
- Brush through the lectures before signing up, and if you're already a Google Sheets master (i.e. you are proficient with pivots, index/match, lookups, importing ranges) then this course may not be for you
Description
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 :)
Who this course is for:
- This course is for all levels, I'll cover the entry level stuff up front and progress down in difficulty, so those who are more advanced can skip to lectures of interest
- Anyone who is looking at being an analyst or simply wants to improve their skill with Google Sheets or Excel
Course content
7 sections • 20 lectures • 1h 42m total length
- Preview03:22
- 00:02Dataset location (download the data covered in the course and follow along!)
Instructor
Analyst
![Erik Rood](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.9 Instructor Rating
- 229 Reviews
- 2,044 Students
- 4 Courses