Google Sheets Masterclass The Power Of Excel And Analysis

Free Download Google Sheets Masterclass The Power Of Excel And Analysis
Published 6/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.22 GB | Duration: 7h 18m
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.
Homepage

www.udemy.com/course/google-sheets-masterclass-the-power-of-excel-and-analysis/