This course will introduce you to the basic skills of working with Google Sheets.

Who is this course for: for beginners who are just getting to know spreadsheets.

Lecturer - Yevgeny Bezpaliy - Middle Tech PM at Choice31

Lesson 1. Getting to know the interface and workspace.
In the lesson we will analyze:
- what is a Google spreadsheet and how to create it
- basic settings: how to rename a spreadsheet, enter the first data, edit cells
- how to work with the menu and toolbar

Lesson 2. Collaborating in Google Sheets, how to download and print a spreadsheet.
In the second lesson, we will analyze:
- the subtleties of collaborating with other Google users
- how to view the history of changes to a spreadsheet or a separate cell
- how to work with the context menu of a sheet and multiple sheets: add, delete, copy a sheet
- how to download a document in the desired format
-how to copy and print a spreadsheet
- how to work offline and what opportunities this opens up

Lesson 3. Working with data in Google Sheets.
In this lesson, the lecturer will tell you:
- how to import files to Google Sheets in popular formats: xls, csv
- how to prepare data for processing: basic formatting tools, search and replace
- how to work with cells, rows and columns
- what are data formats and autofill content in cells
- how to make special inserts without formatting: only values, formulas, etc.