Intitiation Google Sheet

The objectives:

Understand the basics of Google Sheets and its user interface.
Create, modify and format spreadsheets for different types of data.
Master the functions and formulas commonly used to perform calculations.
Use data organization tools such as filters, sorts and groupings.
Collaborate effectively with other users by sharing and working simultaneously on spreadsheets.
Visualize and present data in graphical and tabular form for better understanding.

Requisites:

None.

For whom:

This training is for anyone who wants to develop their business.

Methods used:

Assessment:

Assessment of skills acquired during training via a questionnaire and role-playing exercises.

Access time:

From the first registrant, training can be provided within 1 month of signing the agreement.

Accessibility:

This course is accessible to people with reduced mobility. For any other situation, please contact us to study the possibilities of adapting the training.

Introduction to Google Sheets

Discovering the Google Sheets user interface.
Creating a new document and navigating the various options.
Managing worksheets and tabs.

Creating and formatting data

Entering and editing data in cells.
Formatting cells, columns and rows.
Using predefined styles and customizing formats.

Using formulas and functions

Introduction to basic formulas for simple calculations.
Using built-in functions.
Creating customized formulas to meet specific needs.

Organizing and manipulating data

Using filters to sort and filter data.
Grouping data using columns or rows.
Using pivot tables for data analysis.

Collaboration and sharing

Share spreadsheets with other users.
Work simultaneously on a spreadsheet with collaborators.
Use comments and editing permissions.

Viewing data

Create graphs to visually represent data.
Customize graphs with formatting options.
Use tables to summarize and present data.