Google Sheets Basic - course RUB 12,990. from Specialist, training 16 ac. h., Date: August 29, 2022.
Miscellaneous / / December 03, 2023
Finding the right spreadsheet software that can do the formatting, processing, consolidation, analysis and visualization of data is the most important step for both specialists and organizations. MS Office Excel held the leading position in this direction, but everything is changing and at the beginning of 2010 Google provided the opportunity storage and sharing of any type of files using the Google Docs service, including working with documents, presentations and tables. Google Sheets is an analogue of a special program that the user does not need to install on his computer, since he can use it online. The service allows you to create files, edit them and work on them together with your team, add data charts, use built-in formulas, pivot tables and special analytics tools Google. And all this is free!
You will learn:
Manage Google Sheets Files Efficiently
Set up security and file sharing
Edit, format, and check data
Carry out export-import operations with MS Excel
Perform calculations using built-in formulas
Create and customize pivot tables
Create charts and sparklines
You will know:
Basics of working with Google Sheets, data entry and editing
Data processing: sorting, filtering, checking and formatting
Features of sharing, exporting and importing data
Referencing and substitution functions, functions for working with dates, logical, text, rounding, summing and statistics with conditions
Pivot Table Basics
Diagramming Basics
Module 1. Fundamentals of work (4 ac. h.)
Interface. Toolbar.
Working with sheet elements, data formatting.
History of changes in Google Sheets.
Features of collaboration, data protection.
Export data to MS Excel.
Module 2. Working with formulas (8 ac. h.)
Types of links. IMPORTRANGE function
Name ranges
Addition and counting functions
Logic functions
Text functions
Functions for working with dates
Referencing and Substitution Functions
Filtering functions: FILTER, SORT, SORTN, UNIQUE
Module 3. Data processing (4 ac. h.)
Data processing: filtering, sorting
Data checking
Conditional Formatting
Removing duplicates
Diagrams: Basics
Pivot tables