Google Sheets Introduction

Vaativuus
Arvostelut
420,00 
+ alv./VAT

Pahoittelemme mutta tiedossa ei ole seuraavia kurssipäiviä.
Ole hyvä ja ole yhteydessä myyntiin: 020 7776 670 tai myyntipalvelu@sovelto.fi

Overview

In this hands-on instructor led course, you will learn about the basics of the Google sheets app.

Following the course, delegates will be confident in navigating, creating and modifying a Google sheet. Delegates will also learn about basic formatting and create basic formulas and functions.

Objectives

  • Get started with Google sheets
  • Create a basic worksheet
  • Modify a Google sheet
  • Use formulas and functions
  • Format a Google worksheet
  • Manage worksheets
  • Set up printing options

Outline

Module 1: Getting started with Google Sheets
  • Introduction to Google Chrome / Google Drive
  • Google Sheets and the Environment
  • Navigate and Select Data
  • Create a Basic Spreadsheet
  • Open, Save and Close a Google Sheet
Module 2: Modifying a Google Sheet
  • Cut, Copy and Paste Commands
  • AutoFill Options
  • Insert and Delete Options
  • Column Width and Row Height
  • Find and Replace
  • Undo / Redo
Module 3: Using Formulas and Functions
  • Create Relative Formulas
  • AutoCalculate
  • Insert Functions
  • Use AutoSum
  • Copy Formulas
  • Create Absolute Formulas
Module 4: Formatting a Google Sheet
  • Font Formatting Options
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting
Module 5: Managing Google Sheets
  • Manage Worksheets
  • View different Google Sheets and Files
  • Freeze Panes and Split
  • Navigate around different Sheets within Google Chrome and Drive
  • Print Google Sheets and Change Print Options

Prerequisites

  • Use a mouse
  • Type and use a keyboard
  • Experience in web browsing
  • Work with windows – minimise, maximise, open and close
  • Basic skills with Microsoft Office applications, or equivalent, are recommended, but not mandatory
  • Basic knowledge of Google drive and what it does is recommended, although not necessary

 

Paikkoja jäljellä:
Ei paikkarajoitusta
420,00  + alv./VAT