Google Sheets Foundation

Google Sheets Foundation

Summary

Location

Location

Malaysia

Duration

Duration

1 Day
Format

Format

Public Class

Public Class

Google Sheets Training: Unlocking Your Spreadsheet Potential

Are you ready to supercharge your spreadsheet skills? Look no further than our ‘Google Sheets Foundation’ course. This comprehensive training program is designed for Clerks, Officers, Executives, Supervisors, Administrators, and Managers at all levels who want to harness the full power of Google Sheets.

Mastering the Essentials

In this engaging course, you’ll gain a systematic understanding of Google Sheets and its myriad benefits. Starting with the basics, you’ll dive into the Google Sheets interface, learning to navigate with ease. You’ll discover how to create, manage, and format spreadsheets, enabling you to handle data efficiently. We’ll unravel the magic of formulas and functions, empowering you to perform complex calculations effortlessly.

A Career Boost

By the end of the ‘Google Sheets Foundation’ course, you’ll be well-equipped to tackle the real-world demands of modern businesses. From organizing data to making informed decisions, you’ll have the skills to excel in your career. So, if you’re looking to enhance your spreadsheet proficiency and stay ahead in the corporate world, this training is your gateway to success. Enroll today and embark on your journey to become a Google Sheets pro.

With ‘Google Sheets Training,’ the possibilities are limitless. Don’t just work with data—master it.

Course Details

Course Code: GSSF-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 Microsoft Excel.

Prerequisites

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

  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to configure the desktop
  • Able to use the Control Panel
  • Able to move and re-size Application Windows
  • Able to switch between task applications

Methodology

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

Course Objectives

  • Give participant a systematic understanding of a spreadsheet ad its benefits
  • Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment

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

  • Getting Started with Google Sheets, Identify the Elements and Interface
  • Performing Calculation, Basic Formula and Functions
  • Modify worksheet & Formatting Worksheet
  • Printing and managing large workbook

Outlines

  • Topic A – Identify the Elements of Google Sheet
    • What is Google Sheet
    • What is Google Sheet
    • Accessing Google Sheets with Your Account
    • The Google Sheet Interface
    • Navigation Options
  • Topic B Creating a New Blank Workbook
    • Create a file
    • Save a file
    • View a file
    • Rename a file
    • Make a copy of a file
    • Download a copy of a file
    •  
  • Topic A: Manage Sheet
    • Add & Rename sheet
    • Copy & Rename sheet
    • Move sheets order
    • Delete a sheet
  • Topic B: Getting Data into Cell
    • Enter and edit data
    • Fonts Format o Font type
      • Font size
      • Font color
      • Bold & Italic
      • Strikethrough
    • Cell Format
      • Border Options
      • Fill Options
      • Horizontal alignment
      • Vertical alignment
    • Data type
      • Number Formats
      • Date Format
      • Currency Format
    • Create series
      • Create series if number
      • Create series of dates
      • Create series of text
      • Copy, paste and move cell
    • Text Wrapping
    • Text Rotation
    • Merge cells
  • Topic C: Manage Rows & Column
    • Insert row or column
    • Delete row or column
    • Resize row or column
    • Copy and paste row & column
  • Topic A: Manipulate Sheet
    • Undo & Redo
    • Hide row and column
    • Hide sheet
    • Freeze row and column
  • Topic B – Search and Replace Data
    • The Find Command
    • The Replace Command
    • Search Range
    • Search options
  • Topic C – Spell Check a Worksheet
    • Spell check
    • Personal Dictionary
  • Topic A: Create Formulas in a Worksheet
    • The Formula Bar
    • Common Mathematical Operators to create formula
  • Topic B: Insert Functions in a Worksheet
    • Summary Function
      • SUM
      • AVERAGE
      • COUNT
      • MIN
      • MAX
  • Topic A: Define Page Setup
    • Print Range
    • Paper Size
    • Page orientation
    • Scale
    • Margin
    • Header & Footer
    • Page order
    • Page alignment

Trainers

Reviews

Interested In

Google Sheets Foundation

Starting From
RM500
Intake Date
26 APR 2024
,
26 JUNE 2024
,
28 AUG 2024
,
28 OCT 2024
,
27 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 Foundation
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. *