Google Sheets Masterclass: The Power Of Excel And Analysis

Unleash the Power of Google Sheets: Master Data Analysis, Visualization, and Collaboration

What you’ll learn
Develop real-life spreadsheet challenges with ease
Master Pivot tables, eye-catching charts and sparklines to create impressive Google spreadsheets
Create interactive & visually effective progress charts and dashboards in Sheets
Learn hidden Google Sheets features that even the Experts don’t know
Import & append data from other Google Spreadsheets across the world
Learn advanced functions like QUERY, IMPORTHTML, IMPORTXML and more
Secrets to properly use tricky features like Conditional formatting
Write BigQuery and Query langue for Big Data sets to get the dynamic results as quickly
Apply VLOOKUP, and XLOOPUP formulas to get quick lookup results from your business needs
Learn how to collaborate with teams and work in globally protected scenarios

Requirements
No prior spreadsheet knowledge is needed.
A free Google account (you can also set one up during the course)

Description
Unlock the full potential of Google Sheets with our comprehensive Google Sheets Masterclass. Whether you’re a beginner or an intermediate user, this course is designed to enhance your spreadsheet skills and empower you to tackle complex data analysis, create dynamic reports, and streamline your workflow like a pro.In this hands-on course, you’ll embark on a transformative learning journey, guided by expert instructors who will demystify the powerful features and functionalities of Google Sheets. You’ll gain a deep understanding of how to harness the full range of tools available, enabling you to leverage the platform’s capabilities to their fullest.Key Learning Objectives:Master the Fundamentals: Build a solid foundation by learning essential spreadsheet concepts, formatting techniques, and basic formulas and functions in Google Sheets.Advanced Formulas and Functions: Take your skills to the next level by exploring complex formulas, logical functions, statistical analysis, and data manipulation techniques.Data Analysis and Visualization: Discover how to transform raw data into meaningful insights using advanced data analysis tools, pivot tables, charts, and custom data visualization techniques.Collaboration and Automation: Learn how to collaborate effectively with others using real-time collaboration features, track changes, and automate repetitive tasks with scripts.Data Import and Integration: Explore methods for importing data from external sources, such as databases and APIs, and learn how to integrate Google Sheets with other Google Workspace applications.Data Protection and Security: Understand best practices for securing your data, setting permissions, and utilizing data validation to maintain data integrity.Workflow Optimization: Discover time-saving techniques, shortcuts, and add-ons that will streamline your workflow, boost productivity, and simplify complex tasks.Course Format:The Google Sheets Masterclass is delivered through a combination of interactive video lessons, practical exercises, and hands-on projects. You’ll have access to downloadable resources, and supplementary materials to reinforce your learning. Our online learning platform allows you to learn at your own pace, and you’ll have the opportunity to interact with instructors through discussion forums.Who Should Enroll:Anyone interested in mastering Google Sheets for personal or professional useProfessionals seeking to enhance their data analysis and spreadsheet management skillsSmall business owners and entrepreneurs who want to leverage Google Sheets for efficient data tracking, reporting, and business analysisStudents and academics looking to improve their research data management and analysis capabilitiesBy the end of this Google Sheets Masterclass, you’ll have the confidence and expertise to unlock the true potential of Google Sheets, enabling you to efficiently organize, analyze, and visualize data, collaborate seamlessly, and make data-driven decisions with ease. Enroll now and elevate your spreadsheet skills to new heights!

Overview
Section 1: Getting started

Lecture 1 Introduction

Lecture 2 Getting started on Windows, macOS, Android, and IOS

Lecture 3 How to ask great questions

Lecture 4 FAQ’s

Section 2: Google Sheets Basic

Lecture 5 Sheets Basics to start

Lecture 6 Cells, Rows, and Columns

Lecture 7 Productivity Tips and File Sharing

Lecture 8 Menu and Toolbar options

Lecture 9 Save and print in Sheets

Lecture 10 Language and Spreadsheet settings

Lecture 11 Version recovery and edit History

Section 3: Data Types and Formulas

Lecture 12 Data Types

Lecture 13 Data Entry

Lecture 14 Autofill in sheets

Lecture 15 Data handling basics (copy, cut and paste)

Lecture 16 Common functionalities in sheets

Lecture 17 Regular Functions in Google Sheets (sum, average, counta and countunique)

Lecture 18 Relative Vs. Absolute referencing

Section 4: Data Formatting and Useful tools

Lecture 19 Useful tools and Report design

Lecture 20 Split Text into columns

Lecture 21 Conditional formatting

Lecture 22 Create Drop-down lists from data

Lecture 23 Data Validations

Lecture 24 Importing TXT data files into Google Sheets

Lecture 25 Importing .CSV data files into Google Sheets

Lecture 26 Getting Data from Other Google Sheets

Section 5: Reports: Filtering, Sorting, and Cleaning Data

Lecture 27 Sort Features

Lecture 28 Filter and Filter view in Sheets

Lecture 29 Filtered Results-(SubTotal)

Lecture 30 Remove Duplicates

Lecture 31 Trim White Spaces

Lecture 32 Find and Replace Data

Section 6: Google Sheets: Essential Functions to Analyze Data

Lecture 33 Unique and Sort Functions

Lecture 34 SUM(IFS) applying on (COUNT,MIN, MAX)

Lecture 35 Logical Functions

Lecture 36 IF Function (IF, Then)

Lecture 37 Nested IF and IFS Functions

Lecture 38 Named Ranges

Lecture 39 Rounding Values

Section 7: Google Sheets: Lookup Functions

Lecture 40 VLOOKUP Function

Lecture 41 HLOOKUP Function

Lecture 42 HLOOKUP + Match formula

Section 8: XLOOKUP and #NA

Lecture 43 XLOOKUP Function

Lecture 44 Handling #NA and Approximates match in XLOOKUP

Section 9: Text, Date, and Time Functions

Lecture 45 Basic Text Functions

Lecture 46 Split and Join Data from multiple columns

Lecture 47 Search and SUBSTITUTE

Lecture 48 Date Time Functions

Lecture 49 Time Calculations(worked hours)

Section 10: Collaborate, Publish, and Protect

Lecture 50 Collaboration and Sharing files

Lecture 51 Publishing Sheet or chart to Link in a web page

Lecture 52 Publishing Sheet or chart to Embedding in a web page

Lecture 53 Email Google Sheets or chart

Lecture 54 Prepare for Print or PDF with page breaks

Lecture 55 Protect a sheet or range

Lecture 56 Use Google Forms to collect real-time data

Lecture 57 Exercise and Solution for PDF layout

Section 11: Google Sheets: Charts

Lecture 58 Chart Basics – Column and Line Charts

Lecture 59 Aggregating Data in Charts – Bar and Pie Charts

Lecture 60 Combo charts

Lecture 61 Gauge chart

Lecture 62 Table chart

Lecture 63 Scorecard chart for KPI Dashboards

Lecture 64 Adding Slicers to charts

Lecture 65 Sparklines chart

Lecture 66 Sparklines for Stock and Currency

Lecture 67 Geo charts

Section 12: Pivot Tables in Google Sheets

Lecture 68 Explore Pivot Features in Google Sheets

Lecture 69 Pivot Table Basics in Google Sheets

Lecture 70 Use Filters and Slicers for Dynamic Pivot Tables

Lecture 71 Grouping items and dates(Month,Year)

Lecture 72 Custom Formulas in Pivot Tables

Section 13: Advanced Google Sheets Functions and Formulas

Lecture 73 INDEX MATCH for complex lookups

Lecture 74 ARRAYFORMULA function

Lecture 75 Create your own Arrays and Make totals

Lecture 76 INDIRECT Function Lookup

Lecture 77 Create Random Data and Text

Lecture 78 SEQUENCE Function

Section 14: The QUERY Functions

Lecture 79 QUERY Function Basics

Lecture 80 QUERY Function using Select and Where

Lecture 81 QUERY Function for Aggregation

Lecture 82 Group By Multiple Columns

Lecture 83 Transform Distinct Values using Pivot(Query Function)

Lecture 84 Aggregates and Sorting using Order by clause

Lecture 85 QUERY Function for Dynamic Totals

Lecture 86 QUERY Function to Combine Data from Multiple Sheets

Lecture 87 QUERY Function with IMPORTRANGE to Combine External Sheets

Section 15: Google Sheets: Import Data from Web

Lecture 88 Import Tables from the Web(IMPORTHTML)

Lecture 89 Import any structured data from Web(IMPORTXML)

Section 16: Google Sheets: QR Code and Images

Lecture 90 Insert Image on Google Sheets

Lecture 91 Generate QR Code on Required data

Anyone interested in mastering Google Sheets for personal or professional use,Professionals seeking to enhance their data analysis and spreadsheet management skills,Small business owners and entrepreneurs who want to leverage Google Sheets for efficient data tracking, reporting, and business analysis,Students and academics looking to improve their research data management and analysis capabilities,By the end of this Google Sheets Masterclass, you’ll have the confidence and expertise to unlock the true potential of Google Sheets, enabling you to efficiently organize, analyze, and visualize data, collaborate seamlessly, and make data-driven decisions with ease.