Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Google Google Sheets

Google Sheets - The Comprehensive Masterclass

Learn Google Sheets in 2020! Solve Complex Data Analysis Problems. Become an Expert: Learn Pivot Tables, QUERY & more
Bestseller
Rating: 4.7 out of 54.7 (917 ratings)
4,696 students
Created by Leila Gharani
Last updated 3/2021
English
English [Auto]
30-Day Money-Back Guarantee

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
  • Automate your work with Macros & Google Apps Script
Curated for the Udemy for Business collection

Requirements

  • A free Google account (you can also set one up during the course)
  • No prior spreadsheet knowledge is needed.
  • Willingness to learn. Let's do this!

Description

This is the only Google Sheets course you’ll ever going to need: Because it’s going to teach you everything you need to know. From data collection, automation, to proper data analysis and visualization.

What will happen by the end of the course:

  1. You'll be a confident spreadsheet user

  2. You'll be the one that brings solutions to the table instead of problems

  3. You can tackle complex data analysis with ease

  4. You'll create interactive and compelling dashboards in Google Spreadsheets

  5. You'll know the right way to approach a problem

What you'll learn to get there:

  • 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

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.

I promise, we'll have fun!

Why Learn Google Sheets?

The way we’re using spreadsheets is changing. More of our work and collaboration is done through online channels, our spreadsheets are also moving online. Google Sheets is an online spreadsheet program that offers solutions many companies need right now.

In the past the main requirement companies had was for professionals to have solid knowledge in Microsoft Excel. Now they are looking for more.

As a business professional it's important to master the important applications. You don't need to know them all. Just the important ones.

And something else you may not know ...

You can apply MOST of the knowledge you learn in this Google Sheets course to Microsoft Excel as well!

There are many helpful and time-saving Google Sheets formulas and features. We tend to forget what these are if we don't use them. This course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.


Why Take This Specific Google Sheets Course?

This Comprehensive Google Sheets Masterclass is simply like no other Google spreadsheet course out there. I don’t say that lightly.

This course will get you confident and comfortable designing simple to complex spreadsheets. You'll go beyond Sheets basics. As you go through the course, you'll be able to apply what you learnt immediately to your job.

You'll master new formulas and learn new function so you can find better ways to setup your existing spreadsheets. Management loves efficiency.

In this course you'll solve dozens of practical real-world examples. They'll help you think outside the box so you can work smarter not harder.

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.

Featured review

Jim Greene
Jim Greene
78 courses
12 reviews
Rating: 5.0 out of 54 months ago
This is a terrific course. So many topics covered well. I thought I had a good understanding from years of using Excel and this course taught me so many practical tips for using Google Sheets. Well done! Thank you, Leila.

Course content

20 sections • 133 lectures • 14h 25m total length

  • Preview03:45
  • GET ALL COURSE FILES HERE
    01:02
  • Preview03:54

  • Preview03:20

  • Preview07:14
  • Cells, Rows & Columns
    08:34
  • Productivity Tips & File Sharing (Pro Tip)
    07:25
  • Useful Menu & Toolbar Options
    09:47
  • Language & Spreadsheet Settings (Important)
    04:58
  • Version Recovery & Edit History
    03:34
  • Activity: 5 Minute Timer
    00:30
  • Quiz: Test Your Knowledge - Getting Started
    5 questions

  • Data Entry, Data Types & Autofill in Google Sheets
    09:27
  • Common Formulas in Google Sheets
    09:44
  • Important Functions in Google Sheets (Sum, Count, Counta, CountUnique)
    09:47
  • Relative Vs. Absolute Referencing
    06:45
  • Challenge: Find the Mistake! Data Doesn't Add Up!
    03:09
  • Key Takeaways: The Basics
    00:29

  • Useful Features for Report Design
    11:57
  • Useful Shortcuts (Pro Tips)
    11:47
  • Conditional Formatting (Steer Attention to What Matters)
    09:42
  • Challenge: Conditional Formatting with Checkboxes and Emails
    04:03
  • Data Validation & Drop-down Lists
    11:46
  • Working with Excel & CSV Files (& Importing Data)
    09:11
  • Getting Data from Other Google Sheets (ImportRange)
    08:21
  • Best Practice in Designing Functional Spreadsheets (Pro Tips)
    06:56
  • Test Your Knowledge - Useful Features
    6 questions
  • Key Takeaways: Best Practice & Useful Features
    00:37

  • Sort Feature & What You Shouldn't Do
    08:29
  • Preview08:44
  • Calculations on Filered Results - SubTotal (Pro Tip)
    04:44
  • Challenge: Delete Empty Rows in Data
    05:12
  • Split Text, Remove Duplicates and Trim Spaces
    05:21
  • Find & Replace Values (Pro Tip)
    09:45
  • Challenge: Which Items Does Each Customer Order?
    04:29
  • Key Takeaways: Data Cleaning & Management Tools
    00:44

  • Important: How to Properly Read & Understand Functions
    08:54
  • Unique & Sort Functions
    08:59
  • SUM(IFS) by Criteria (also COUNT, AVERAGE, MAX, MIN)
    12:22
  • Challenge: Summarize by Criteria & COUNTUNIQUE(IFS)
    10:05
  • Rounding Values (the Right Way)
    06:22
  • Logical & Information Functions (TRUE & FALSE)
    08:40
  • IF Function (IF, Then)
    10:27
  • Nested IF & IFS Functions (Pro Tip)
    09:05
  • Error Types & How to Handle Errors
    07:26
  • Named Ranges (Pro Tip)
    06:29
  • Challenge: Average Sales between Selected Dates
    07:49
  • Key Takeaways: Essential Functions to Summarize
    00:50

  • Overview of Helpful Lookup Functions
    01:52
  • VLOOKUP and HLOOKUP
    09:02
  • Approximate Match Lookup (Replacement for IFS - Pro Tip)
    05:41
  • FILTER Function to Return Multiple Match Results
    10:16
  • Lookup Pictures & Images (Pro Tip)
    09:27
  • SortN for Ranking (account for ties)
    08:07
  • Challenge: Find the Mistakes in the Formulas & Correct Them
    06:24
  • Key Takeaways: Lookup & Filter Functions
    00:06

  • Useful & Easy Text Functions
    08:17
  • Search & Substitute Text (Pro Tip)
    10:08
  • Split & Join Values to / from Multiple Columns
    05:46
  • Challenge: Sort Multiple Words Inside a Cell
    03:49
  • Essential Date Functions
    10:26
  • Time Calculations (Calculating Hours Worked)
    06:55
  • Test Your Knowledge - Text & Date Functions
    5 questions
  • Key Takeaways: Useful Text Functions
    00:31

  • Detect Language and Translate Your Spreadsheets
    05:43
  • Image Function (Pro Tip: Create QR Codes)
    06:40
  • Import Tables From the Web (IMPORTHTML)
    05:23
  • Import Any Data from the Web (IMPORTXML)
    11:37
  • Stock & Currency Data with GOOGLEFINANCE
    09:09
  • Challenge: Did You Invest in the Right Stock?
    06:15
  • Key Takeaways: Google Functions & More Resources
    00:11

Instructor

Leila Gharani
Microsoft MVP, Bestselling Instructor
Leila Gharani
  • 4.7 Instructor Rating
  • 58,680 Reviews
  • 191,178 Students
  • 9 Courses

Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, accelerate their careers and achieve more in less time.

Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes.

Since 5 years, Leila runs her own site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques to large corporations. She also teaches at the University of Applied Sciences in Upper Austria.

Her courses include examples based on her experience as well as  the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions.

She places great value on keeping her courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.

Leila's passion is learning, sharing and solving difficult data analysis problems.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.