Google Sheets Advanced

Google Sheets Advanced

Summary

Location

Location

Malaysia

Duration

Duration

1 Day
Format

Format

Public Class

Public Class

Enhance Your Career with Google Sheets Training

Are you ready to take your career to the next level? Look no further than our ‘Google Sheets Advanced’ course. This training is your gateway to mastering Google Sheets, a vital tool for clerks, officers, executives, supervisors, administrators, and managers across all levels. With our immersive program, we provide hands-on experience, interactive lectures, and practical exercises, ensuring you not only understand but also excel in Google Sheets.

Unleash the Power of Google Sheets

In today’s data-driven world, the ability to efficiently organize, analyze, and compile data is a game-changer. Our course equips you with the skills to create subtotals, use Pivot Tables, harness lookup functions, and much more. Imagine being able to navigate large spreadsheets effortlessly, link data seamlessly, and protect your work with confidence. These are the skills that can set you apart in your career, making you an invaluable asset in the fast-paced corporate landscape.

Elevate Your Potential

The ‘Google Sheets Advanced’ course is not just about learning; it’s about transforming your career. By delving deep into the intricacies of Google Sheets, you gain the confidence to handle complex data and provide insights that drive decision-making. Whether you’re a professional seeking growth or an enthusiast eager to expand your skill set, this training is your ticket to a more fulfilling and successful future. So, why wait? Join us, embrace the power of Google Sheets, and elevate your potential today!

Course Details

Course Code: GSSA-1; Instructor-led

Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Google Sheet.

Prerequisites

Basic knowledge of Google Sheet is essential with the following pre-requisites:

  • Have attended Google Sheet – Foundation & Intermediate Level; OR
  • Able to switch between task applications
  • Able to create simple to complex formulas and functions
  • Able to validate data in a Worksheet
  • Able to apply Filter data using Auto & Advanced Filters
  • Able to clean Duplicate Records

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Objectives

Upon completion of this program, participants should be able to:

  • Create Subtotal Using the Subtotal Function
  • Analyze data Using Pivot Tables
  • Use lookup Function
  • Combining & Consolidating Data
  • Summarizing & Analyzing with Pivot Table and Pivot Charts

Outlines

  • Topic A: Grouping Data
    • Grouping Data
    • Displaying and Collapsing Levels
  • Topic A: Using the LOOKUP Function
    • Using VLOOKUP to Find Data
    • Using HLOOKUP to Find Data

 

  • Topic B: Alternative LOOKUP Function
    • Using the INDEX Function
    • Using the MATCH Function
    • Combining the MATCH and INDEX functions

 

  • Topic C: Split Data
    • Split text to columns
  • Topic A: Create a PivotTable
    • Create PivotTable Dialog Box
    • PivotTable Fields Pane
    • Summarize Data in a PivotTable
    • Show Values as Functionality of a PivotTable
  • Topic B: Filter Data by Using Slicer
    • Insert Slicers Dialog Box
  • Topic C: Analyzing Data with PivotChart
    • Creating PivotChart
    • Editing a PivotChart
  • Topic A: Linking Sheet
    • Inserting links
    • Editing links
    • Using links
    • Remove the link
  • Topic B: Protecting sheet and range
    • Protecting Range
    • Protecting sheet
    • Set Permission

Trainers

Reviews

Interested In

Google Sheets Advanced

Starting From
RM500
Intake Date
30 APR 2024
,
28 JUNE 2024
,
30 AUG 2024
,
30 OCT 2024
,
3 DEC 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: Google Sheets Advanced
Duration: 1 Day
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *