Google Sheets Masterclass: The Power of Excel and Analysis

Focused View

Metla Sudha Sekhar

7:18:12

75 View

1 - Getting started

1 - Introduction.mp4

03:43

2 - Getting started on Windows macOS Android and IOS.mp4

01:07

3 - How to ask great questions.mp4

01:27

4 - FAQs.mp4

01:13

2 - Google Sheets Basic

5 - Sheets Basics to start.mp4

12:54

6 - Cells Rows and Columns.mp4

08:40

7 - Productivity Tips and File Sharing.mp4

08:48

8 - Menu and Toolbar options.mp4

08:18

9 - Save and print in Sheets.mp4

03:21

10 - Language and Spreadsheet settings.mp4

08:40

11 - Version recovery and edit History.mp4

03:12

3 - Data Types and Formulas

12 - Data Types.mp4

07:07

13 - Data Entry.mp4

06:04

14 - Autofill in sheets.mp4

03:43

15 - Data handling basics copy cut and paste.mp4

03:49

16 - Common functionalities in sheets.mp4

05:18

17 - Regular Functions in Google Sheets sum average counta and countunique.mp4

11:43

18 - Relative Vs Absolute referencing.mp4

06:10

4 - Data Formatting and Useful tools

19 - Useful tools and Report design.mp4

02:32

20 - Split Text into columns.mp4

03:46

21 - Conditional formatting.mp4

04:01

22 - Create Dropdown lists from data.mp4

05:15

23 - Data Validations.mp4

05:19

24 - Importing TXT data files into Google Sheets.mp4

07:51

25 - Importing CSV data files into Google Sheets.mp4

04:53

26 - Getting Data from Other Google Sheets.mp4

03:47

5 - Reports Filtering Sorting and Cleaning Data

27 - Sort Features.mp4

03:04

28 - Filter and Filter view in Sheets.mp4

04:37

29 - Filtered ResultsSubTotal.mp4

04:12

30 - Remove Duplicates.mp4

03:51

31 - Trim White Spaces.mp4

04:17

32 - Find and Replace Data.mp4

04:34

6 - Google Sheets Essential Functions to Analyze Data

33 - Unique and Sort Functions.mp4

04:46

34 - SUMIFS applying on COUNTMIN MAX.mp4

13:36

35 - Logical Functions.mp4

07:08

36 - IF Function IF Then.mp4

03:43

37 - Nested IF and IFS Functions.mp4

10:37

38 - Named Ranges.mp4

02:59

39 - Rounding Values.mp4

03:56

7 - Google Sheets Lookup Functions

40 - VLOOKUP Function.mp4

06:13

41 - HLOOKUP Function.mp4

03:53

42 - HLOOKUP Match formula.mp4

06:10

8 - XLOOKUP and NA

43 - XLOOKUP Function.mp4

04:26

44 - Handling NA and Approximates match in XLOOKUP.mp4

05:44

9 - Text Date and Time Functions

45 - Basic Text Functions.mp4

06:00

46 - Split and Join Data from multiple columns.mp4

03:56

47 - Search and SUBSTITUTE.mp4

06:01

48 - Date Time Functions.mp4

05:48

49 - Time Calculationsworked hours.mp4

03:47

10 - Collaborate Publish and Protect

50 - Collaboration and Sharing files.mp4

06:11

51 - Publishing Sheet or chart to Link in a web page.mp4

04:08

52 - Publishing Sheet or chart to Embedding in a web page.mp4

04:48

53 - Email Google Sheets or chart.mp4

02:52

54 - Prepare for Print or PDF with page breaks.mp4

04:46

55 - Protect a sheet or range.mp4

03:57

56 - Use Google Forms to collect realtime data.mp4

06:06

57 - Exercise and Solution for PDF layout.mp4

03:43

11 - Google Sheets Charts

58 - Chart Basics Column and Line Charts.mp4

03:46

59 - Aggregating Data in Charts Bar and Pie Charts.mp4

05:21

60 - Combo charts.mp4

03:05

61 - Gauge chart.mp4

05:59

62 - Table chart.mp4

03:12

63 - Scorecard chart for KPI Dashboards.mp4

02:17

64 - Adding Slicers to charts.mp4

03:36

65 - Sparklines chart.mp4

05:13

66 - Sparklines for Stock and Currency.mp4

04:14

67 - Geo charts.mp4

02:56

12 - Pivot Tables in Google Sheets

68 - Explore Pivot Features in Google Sheets.mp4

04:36

69 - Pivot Table Basics in Google Sheets.mp4

02:54

70 - Use Filters and Slicers for Dynamic Pivot Tables.mp4

03:49

71 - Grouping items and datesMonthYear.mp4

03:52

72 - Custom Formulas in Pivot Tables.mp4

02:50

13 - Advanced Google Sheets Functions and Formulas

73 - INDEX MATCH for complex lookups.mp4

03:53

74 - ARRAYFORMULA function.mp4

04:38

75 - Create your own Arrays and Make totals.mp4

02:30

76 - INDIRECT Function Lookup.mp4

03:05

77 - Create Random Data and Text.mp4

01:48

78 - SEQUENCE Function.mp4

03:40

14 - The QUERY Functions

79 - QUERY Function Basics.mp4

05:19

80 - QUERY Function using Select and Where.mp4

08:29

81 - QUERY Function for Aggregation.mp4

03:35

82 - Group By Multiple Columns.mp4

04:58

83 - Transform Distinct Values using PivotQuery Function.mp4

02:43

84 - Aggregates and Sorting using Order by clause.mp4

03:46

85 - QUERY Function for Dynamic Totals.mp4

05:37

86 - QUERY Function to Combine Data from Multiple Sheets.mp4

03:31

87 - QUERY Function with IMPORTRANGE to Combine External Sheets.mp4

04:28

15 - Google Sheets Import Data from Web

88 - Import Tables from the WebIMPORTHTML.mp4

04:19

89 - Import any structured data from WebIMPORTXML.mp4

02:18

16 - Google Sheets QR Code and Images

90 - Insert Image on Google Sheets.mp4

03:52

91 - Generate QR Code on Required data.mp4

05:33

Description

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

Who is this for?

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.

What You Need to Know?

No prior spreadsheet knowledge is needed.

A free Google account (you can also set one up during the course)

More details

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 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.

Enroll now and elevate your spreadsheet skills to new heights!

Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Analysis

Google Sheets

Metla Sudha Sekhar

Instructor's Courses

Mr. Sudha Sekhar, He is a Teacher and an IT Specialist, and also passionate to teach every single real-time step that leads students as well as professionals to become successful and the vision to impart Good Quality Software Education to all I.T to aspirants make a strong bridge the gap between the software companies requirements and the beginners. He is Professional about web development and technologies:* Programming: Python, C# Asp.Net and PHP more..* UI/UX : HTML, CSS, Bootstrap, JavaScript, AJAX and more...* Database : MS-SQL, MySQL, PostgreSQL, MongoDB, MariaDB and more...* Operating Systems / Servers: Administration of LINUX, Ubuntu, CentOS, Windows and more...Start solving your challenge now | Enroll today and learn real world practical example courses.He is passionate about:* Teaching students the correct way.* Making things simple and easy to understand.* Providing the best audio and video qualities to my courses.* Real-time Examples who will understand real-time skills easily.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.