What you’ll learn
-
Solve real-life spreadsheet challenges with ease
-
Create interactive & visually effective dashboards in Sheets
-
Learn hacks and hidden Google Sheets features that even the Experts don’t know
-
Import & append data from other Google Spreadsheets
-
Learn advanced functions like QUERY, IMPORTHTML, IMPORTXML and more
-
Master Pivot tables, charts and sparklines to create impressive Google spreadsheets
-
Secrets to properly use tricky features like Conditional formatting
- Properly input and collect data and navigate large Google spreadsheets
- Best practice and useful (& sometimes hidden) Sheets features
- Sort, Filter, create Filter views and clean data in Google spreadsheets
- Lookup functions in Google Sheets such as VLOOKUP, INDEX & MATCH, FILTER & SORTN.
- Essential Summarization Functions like SUM, COUNT, SUMIFS, COUNTIFS etc.
- Branching functions like Google Sheets IF and IFS functions.
- Combining data from other Google Sheets with IMPORTRANGE
- QUERY Function to create ANY analysis you want (You’ll learn the key to getting this right)
- Pivot tables, Charts & Slicers in Google Sheets to present your data
- How to automate your work with macros & Google Apps Script
-
Automate your work with Macros & Google Apps Script
How you will learn:
- Lots of challenges & exercises
- Practice activities where you need to find the mistakes
- Quizzes
- You get access to ALL the files I use. The START files so you can follow along with me and the SOLUTION files in case you get stuck.
- If you’re a current spreadsheet user take the pre-assessment quiz to discover your weak spots.
Who this course is for:
- Business professionals looking to expand their skills.
- Absolute beginners who want a structured, engaging, fun and practical Google Sheets course.
- Spreadsheet users who want to discover & showcase new tips and tricks at work.
- Students who want to make sure they have the right level of knowledge to succeed at their next job.
- Data analysts looking to discover new tools to help them do more in less time.
Deal Score-2
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.