Google Workspace - Sheets Essentials Training in New Zealand

  • Delivery Method: Online Instructor-Led / Classroom Based / Onsite
  • Participation Model: Public Training / Private / In-House Training
  • Duration: 1 Day
  • Level: Fundamentals
  • Price: From NZD 1,600 +TAX
  • Upcoming Date:
  • UK & New Zealand Based Global Training Provider

This instructor-led, hands-on course is designed for users who want to build a solid foundation in Google Sheets.

Throughout the programme, participants become familiar with the Google Sheets interface, create new spreadsheets, modify existing data, and apply basic formatting. They also learn how to build simple formulas and use common functions for everyday spreadsheet tasks.

By the end of the course, learners will be able to navigate Google Sheets confidently, enter and edit data, perform basic calculations, manage worksheets, and prepare spreadsheets for printing.


Prerequisites

Participants should be able to:

  • Use a mouse,
  • Type and work with a keyboard,
  • Use a web browser,
  • Open, close, minimise, and maximise windows.

Previous experience with Microsoft Office or similar applications can be useful but is not required. Basic familiarity with Google Drive may also make the course easier to follow.

For remote delivery, an additional screen is recommended so participants can view the training materials while completing practical activities.

Who Should Attend

This course is particularly suitable for:

  • New Google Sheets users,
  • Learners who want to develop basic spreadsheet creation and editing skills,
  • Users beginning to work with Google Workspace,
  • Professionals who need to enter, format, and calculate data using Google Sheets.

The course is designed for Google Workspace users and practical activities can be completed using Google Chrome.

What You Will Learn

By the end of this course, participants will be able to:

  • Access Google Sheets and navigate the main interface,
  • Create a basic worksheet,
  • Enter and modify spreadsheet data,
  • Use common commands including Cut, Copy, Paste, Find, and Replace,
  • Create Relative and Absolute Formulas,
  • Use basic Google Sheets Functions,
  • Apply cell, font, and number formatting,
  • Manage worksheets,
  • Use Freeze Panes,
  • Configure printing and Print Preview options.

Training Outline

Module 1: Getting Started with Google Sheets

  • Introduction to Google Chrome and Google Drive
  • Exploring the Google Sheets environment
  • Working with Google Chrome
  • Signing in to Google Workspace
  • Accessing Google Sheets
  • Navigating within worksheets
  • Selecting cells and cell ranges
  • Opening a Google Workbook
  • Saving files
  • Closing a workbook

Module 2: Modifying a Google Sheet

  • Using Cut, Copy, and Paste
  • Moving and duplicating data
  • AutoFill Options
  • Find and Replace
  • Spell Check
  • Undo and Redo
  • Inserting Rows and Columns
  • Deleting data and cells
  • Adjusting Column Width
  • Changing Row Height
  • Hiding Rows and Columns
  • Using Hide and Unhide options

Module 3: Using Formulas and Functions

  • Introduction to formulas in Google Sheets
  • Creating Relative Formulas
  • Performing calculations with cell references
  • Inserting Google Functions
  • Copying formulas to other cells
  • Understanding Absolute References
  • Creating Absolute Formulas
  • Comparing Relative and Absolute reference use cases

Module 4: Formatting a Google Sheet

  • Font Formatting
  • Changing font and text size
  • Applying Bold, Italic, and other basic text formats
  • Adding Borders to cells
  • Applying Cell Colours
  • Cell Alignment
  • Horizontal and Vertical Alignment
  • Number Formatting
  • Working with number, currency, percentage, and date formats

Module 5: Managing Google Sheets

  • Managing Sheets within a workbook
  • Adding new Sheets
  • Renaming Sheets
  • Reordering and moving Sheets
  • Deleting unnecessary Sheets
  • Using Freeze Panes
  • Freezing Rows and Columns
  • Navigating larger worksheets more efficiently

Module 6: Printing Google Sheets

  • Printing Options
  • Selecting the area to print
  • Page Orientation
  • Margin settings
  • Print Preview
  • Reviewing a worksheet before printing
  • Preparing spreadsheet layout for print


Hands-On Learning

Participants complete practical exercises throughout the course using Google Sheets. Core tasks such as entering data, creating formulas, applying formatting, managing worksheets, and preparing spreadsheets for printing are reinforced through guided activities.

This practical approach helps learners become confident using Google Sheets independently for everyday work.

Why Choose Us

Experience Google Workspace - Sheets Essentials in New Zealand through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

  • Delivery Method: Online Instructor-Led
  • Participation Model: Public / Private (In-house)
  • Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
  • Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
  • Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
  • Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
  • Worldwide Access: Join our live virtual classrooms from New Zealand or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Google Workspace - Sheets Essentials through face-to-face Classroom Based training in New Zealand. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

  • Delivery Method: Classroom Based
  • Participation Model: Public / Private (In-house)
  • Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
  • Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
  • Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
  • Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Google Workspace - Sheets Essentials in New Zealand as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

  • Delivery Method: Onsite
  • Participation Model: Private (In-house)
  • Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
  • Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
  • Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
  • Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
  • Worldwide Onsite Delivery: Arrange the training in New Zealand or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.


Contact us for more detail about our trainings and for all other enquiries!

Google Workspace - Sheets Essentials Training Course in New Zealand Schedule

Join our public courses in our New Zealand facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
11 October 2026 (1 Day)
Auckland, Wellington, Christchurch
NZD 1,600 +TAX
17 October 2026 (1 Day)
Auckland, Wellington, Christchurch
NZD 1,600 +TAX
25 October 2026 (1 Day)
Auckland, Wellington, Christchurch
NZD 1,600 +TAX
02 November 2026 (1 Day)
Auckland, Wellington, Christchurch
NZD 1,600 +TAX
07 November 2026 (1 Day)
Auckland, Wellington, Christchurch
NZD 1,600 +TAX
14 November 2026 (1 Day)
Auckland, Wellington, Christchurch
NZD 1,600 +TAX
17 November 2026 (1 Day)
Auckland, Wellington, Christchurch
NZD 1,600 +TAX
21 November 2026 (1 Day)
Auckland, Wellington, Christchurch
NZD 1,600 +TAX

Other trainings and courses related to the Google Workspace - Sheets Essentials

New Zealand, with vibrant and rapidly growing tech communities in Auckland, Wellington, and Christchurch, is carving out a global niche in innovative software solutions and specialized niche technology markets. The nation’s commitment to digital readiness is backed by the research excellence of the University of Auckland and Victoria University of Wellington, focusing on areas like Creative-tech, Agritech, and Health-tech innovation. New Zealand offers a unique and forward-thinking environment for digital learning, where agility and creative problem-solving are highly valued in the professional landscape. Our IT education services in New Zealand focus on high-demand skills such as Web Development, Agile Project Management, and Information Security. We provide the tools and expertise necessary for Kiwi professionals to lead technological change in an economy that prioritizes sustainability, innovation, and global connectivity.

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.