Google Sheets - The Comprehensive Masterclass
- Offered byUDEMY
Google Sheets - The Comprehensive Masterclass at UDEMY Overview
Duration | 14 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
Google Sheets - The Comprehensive Masterclass at UDEMY Highlights
- Earn a certificate upon completion
- 30-Day Money-Back Guarantee
- Get Full lifetime access
Google Sheets - The Comprehensive Masterclass at UDEMY Course details
- 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
- 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
- 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
- This course will get you confident and comfortable designing simple to complex spreadsheets
- You'll master new formulas and learn new function so you can find better ways to setup your existing spreadsheets
Google Sheets - The Comprehensive Masterclass at UDEMY Curriculum
Welcome to your google sheet course
Getting started right with google sheets
Cells, Rows & Columns
Productivity Tips & File Sharing (Pro Tip)
Useful Menu & Toolbar Options
Language & Spreadsheet Settings (Important)
Version Recovery & Edit History
Activity: 5 Minute Timer
Quiz: Test Your Knowledge - Getting Started
Data Entry & Basic Formulas
Data Entry, Data Types & Autofill in Google Sheets
Common Formulas in Google Sheets
Important Functions in Google Sheets (Sum, Count, Counta, CountUnique)
Relative Vs. Absolute Referencing
Challenge: Find the Mistake! Data Doesn't Add Up!
Key Takeaways: The Basics
Best Practice & Useful Features
Useful Features for Report Design
Useful Shortcuts (Pro Tips)
Conditional Formatting (Steer Attention to What Matters)
Challenge: Conditional Formatting with Checkboxes and Emails
Data Validation & Drop-down Lists
Working with Excel & CSV Files (& Importing Data)
Getting Data from Other Google Sheets (ImportRange)
Best Practice in Designing Functional Spreadsheets (Pro Tips)
Test Your Knowledge - Useful Features
Key Takeaways: Best Practice & Useful Features
Sorting Filtering and Cleaning Data
Sort Feature & What You Shouldn't Do
Calculations on Filtered Results - SubTotal (Pro Tip)
Challenge: Delete Empty Rows in Data
Split Text, Remove Duplicates and Trim Spaces
Find & Replace Values (Pro Tip)
Challenge: Which Items Does Each Customer Order?
Key Takeaways: Data Cleaning & Management Tools
Essentials sheets functions to Analyze & Summarize
Important: How to Properly Read & Understand Functions
Unique & Sort Functions
SUM(IFS) by Criteria (also COUNT, AVERAGE, MAX, MIN)
Challenge: Summarize by Criteria & COUNTUNIQUE(IFS)
Rounding Values (the Right Way)
Logical & Information Functions (TRUE & FALSE)
IF Function (IF, Then)
Nested IF & IFS Functions (Pro Tip)
Error Types & How to Handle Errors
Named Ranges (Pro Tip)
Challenge: Average Sales between Selected Dates
Key Takeaways: Essential Functions to Summarize
Google Sheets - The Comprehensive Masterclass at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?