World’s #1 Online Bootcamp

Course Overview

NA

Skills Covered

  • 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
  • Data analyst
    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:39Preview
      • 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:08Preview
      • 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

Contact Us

1-844-532-7688

( Toll Free )

Why Online Bootcamp

  • 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

Related Programs

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.