Google Sheets - The Comprehensive Masterclass

Descripción

Google Sheets is where modern spreadsheet work happens. This course takes you from basics to advanced in one complete path. Whether you're new to Google Sheets or coming from Excel, this masterclass covers everything you need to work confidently with data: essential functions, data analysis, lookup formulas, the QUERY function, pivot tables, charts, automation with macros, and Google-specific features you won't find in any other spreadsheet tool. By the end you'll be the person on your team who knows how to solve data problems quickly and build reports people actually use. What you'll be able to do after this course: • Navigate, format, and manage large Google Sheets files efficiently • Clean and transform data using sort, filter, split, trim, and find and replace • Use essential functions: SUM, SUMIFS, COUNTIFS, IF, IFS, and AVERAGEIFS • Look up data with VLOOKUP, INDEX MATCH, FILTER, and SORTN • Write QUERY function formulas to create any analysis you need, including aggregations, pivot columns, and dynamic filters • Pull live data into your spreadsheets with GOOGLEFINANCE, IMPORTHTML, IMPORTXML, and IMPORTRANGE • Build interactive dashboards with pivot tables, charts, slicers, and sparklines • Set up dependent dropdown lists, advanced conditional formatting, and data validation with formulas • Automate repetitive tasks with macros and Google Apps Script • Apply array formulas, SEQUENCE, INDIRECT, and INDEX MATCH for advanced data challenges Why this course covers ground others don't: Most Google Sheets courses skip the QUERY function or treat it as a footnote. This course dedicates a full section to it, covering syntax, aggregations, dynamic cell references, date handling, and combining data across files with IMPORTRANGE. Once you know QUERY, you can replace dozens of complex formula combinations with a single line. The course also covers Google-specific features that have no Excel equivalent: live stock and currency data with GOOGLEFINANCE, web scraping with IMPORTHTML and IMPORTXML, language detection and translation, and QR code generation. These are practical tools that can change how you work. What's inside: • 20 sections from essentials to advanced • Challenges and find-the-mistake exercises in every section • Practice workbooks with start files and solution files for every lesson • Pre-assessment quiz to identify your weak spots before you begin • Quizzes throughout to test your understanding as you go • Full section on Google Apps Script and macros for automation Who this works for: Complete beginners and Excel users moving to Google Sheets are both well served by the Essentials sections. If you already know the basics, skip straight to Advanced Data Analysis, the QUERY function, or Apps Script. Note: Most concepts taught in this course also apply directly to Microsoft Excel. Taught by Leila Gharani, Microsoft MVP and trusted by 515,000+ students on Udemy. Enroll now and start with the pre-assessment quiz to see exactly where to begin.

Lo que aprenderás

• Write QUERY function formulas to filter, aggregate, sort, and combine data across multiple sheets and files
• Build interactive dashboards in Google Sheets using pivot tables, charts, slicers, and sparklines
• Use Google-specific functions including GOOGLEFINANCE, IMPORTHTML, IMPORTXML, and IMPORTRANGE to connect live data
• Apply advanced conditional formatting with formulas and set up dependent dropdown lists
• Look up and retrieve data using VLOOKUP, INDEX MATCH, and the FILTER function
• Clean and transform messy data using sort, filter views, split, trim, and find and replace
• Automate repetitive tasks in Google Sheets using macros and Google Apps Script
• Use array formulas, SEQUENCE, and INDIRECT for advanced data analysis challenges

Requisitos

• A free Google account is all you need to get started. You can create one during the course if you don't have one yet.
• No prior spreadsheet experience required. The course starts from the basics and builds to advanced.
• Excel users are welcome. Most concepts and functions covered apply directly to Microsoft Excel as well.