Google Spreadsheet – data and calculation analysis, data compilation, and file sharing

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

Confident spreadsheet workflow - You will learn the Google Sheets interface and find the right tools faster, so you can create files, navigate the workspace smoothly, and start working without confusion.

Better data editing - You will learn how to edit cells properly, format data, and add, move, or remove rows and columns, so you can build clear, well-structured spreadsheets with less effort.

Clear tables and layout - You will master resizing, hiding, merging, and locking sheet elements, making it easier for you to design readable tables and protect important sections from accidental changes.

Faster data analysis - You will learn how to sort and filter data and use core functions and formulas, helping you draw conclusions from tables faster and reduce repetitive manual work.

Charts for presenting results - You will learn how to create charts and adjust their appearance, so you can present numbers in a simpler way and prepare materials that are easier for others to understand.

Efficient file management - You will explore saving, copying, exporting, and printing options in Google Sheets, so you can prepare files for further work, sharing, or archiving in the format you need.

Online data import skills - You will learn how to pull data from websites, detect language, translate text, and insert images from URLs, allowing you to build sheets faster using web-based content.

Secure teamwork in Sheets - You will learn how to protect sheets and share files and folders, so you can organize collaboration more effectively and keep important data safer from unwanted edits.

Training programme

1. Introduction and information about spreadsheets

comparison of the Google Docs spreadsheet with MS Excel,
advantages of using the Google Docs spreadsheet,
spreadsheet workspace.

2. Creating a new spreadsheet

3. Learning to modify cell contents, add and delete rows and columns

formatting data in a cell,
editing one or multiple cells,
adding, moving and deleting rows, columns and cells,
changing row and column sizes,
locking and unlocking,
hiding and merging.

4. Sorting and filtering data in tables, using basic functions and formulas

number and custom formatting,
filtering and sorting,
use of built-in functions.

5. Creating graphical data summaries

inserting a chart,
adjusting the chart appearance.

6. Overview of options for saving, exporting and printing files

displaying the selected file,
renaming,
saving the changes made,
creating a copy of the file,
downloading,
creating templates.

7. Downloading data from websites – importing data from the web

8. Language detection and text translation

9. Adding images to spreadsheets by inserting them using URLs

10. Protecting sheets to safeguard data

11. Sharing files and folders – collaborating with others

What are the prerequisites for participating in the training?

Basic computer skills - You should be comfortable using a computer, keyboard, and mouse, and know how to open programs, work with files, and switch between windows during everyday tasks.

Web browser use - You should know how to use a web browser, open websites, sign in to online services, and work with multiple tabs, because the training focuses on a web-based tool.

Basic file handling - You should understand what files and folders are, know how to save a document, rename it, and find it later, so you can complete the exercises smoothly during training.

Basic table awareness - It will help if you already understand simple table concepts such as rows, columns, and cells, so you can follow the exercises more easily from the very start of training.