Free Advanced Google Sheets Course

438 Learners

Course Overview

The Advanced Google Sheets Course covers both fundamental and advanced topics and is designed for users of all levels. This course introduces learners with Advanced formulas and functions in Google sheets for gaining collaborative and organizing skills for both professional and personal use.

Skills Covered

  • Advanced formulas and functions
  • Data validation and conditional formatting
  • Integrating Google Sheets with other Google Apps
  • Data visualization with charts and graphs
  • Pivot tables Macros and Scripts
  • Advanced formulas and functions
  • Data visualization with charts and graphs
  • Data validation and conditional formatting
  • Pivot tables Macros and Scripts
  • Integrating Google Sheets with other Google Apps
  • Advanced formulas and functions
  • Data visualization with charts and graphs
  • Data validation and conditional formatting
  • Pivot tables Macros and Scripts
  • Integrating Google Sheets with other Google Apps

Benefits

Salary

  • Designation
  • Annual Salary
  • Hiring Companies
  • Annual Salary
    $49,206Min
    $77,024Average
    $120,567Max
    Source: Glassdoor
    Hiring Companies
    Accenture
    Deloitte
    Source: Indeed

Course Curriculum

Course Content

  • Google Sheets - Advanced Topics

    Preview
    • Introduction

      03:46Preview
      • 0.00 Introduction
        02:29
      • 0.01 Agenda
        01:17
    • Module 1 : Advanced formatting in a Google Sheet

      03:54Preview
      • 1.01 Advanced formatting in a Google Sheet
        01:53
      • 1.02 Conditional formatting
        01:48
      • 1.03 Activity 1
        00:13
      • 1.04 Knowledge check
    • Module 2 Advanced formulas and functions

      10:39
      • 2.01 Advanced formulas and functions
        02:45
      • 2.02 Using IF and IFS to analyze data
        04:07
      • 2.03 Activity 2
        00:11
      • 2.04 Data validation and named ranges
        03:25
      • 2.05 Activity 3
        00:11
      • 2.06 Knowledge check
    • Module 3 : Analyze and report

      16:38Preview
      • 3.01 Analyze and report
        01:17
      • 3.02 Exploring charts
        02:49
      • 3.03 Activity 4
        00:06
      • 3.04 Pivot tables
        00:47
      • 3.05 Create a pivot table
        03:37
      • 3.06 Activity 5
        00:08
      • 3.07 Integration and publishing in Google Sheets
        03:54
      • 3.08 Activity 6
        00:09
      • 3.09 Macros
        02:35
      • 3.10 Apply a macro
        01:16
      • 3.11 Knowledge check
    • Module 4 : Populate data using a Google Form

      09:08
      • 4.01 Populate data using a Google Form
        03:47
      • 4.02 Activity 7
        00:05
      • 4.03 Form settings and sharing a Google Form
        03:39
      • 4.04 Activity 8
        00:12
      • 4.05 Managing feedback
        01:25
      • 4.06 Knowledge check
    • Module 5 : Business challenge

      02:50Preview
      • 5.01 Business challenge overview
        01:25
      • 5.02 Activity 9
        00:02
      • 5.03 Course summary
        01:23

Why Join this Program

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts
  • Acknowledgement
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, OPM3 and the PMI ATP seal are the registered marks of the Project Management Institute, Inc.