Our specialized training in Google Sheets, its interaction with other GSuite tools and Google Cloud Services, is always oriented to help our clients
get the best of these tools by identifying and taking advantage of unsolved operational obstacles, unexploited efficiencies and better business practices.
_____________________________________
For companies whose employees only need to know or expand their knowledge about some aspect specific of Google Sheets, and do not need to invest in the full course.
One or more individual modules to pick. (3 hours per module - up to 15 participants)
_____________________________________
For companies seeking that their collaborators know all relevant aspects of the tool with examples that take advantage of it in an integral manner.
Complete course: 5 modules. (15 hours - up to 15 participants)
_____________________________________
For companies who also seek consulting or specific analysis processes, such as migration from other platforms thereof, or development in Google Sheets.
Complete Course: 5 modules (15 hours - up to 15 participants) + 15 hours of specific workshops by area or user to address a specific process or analysis. (up to 10 participants per subject)
The course is divided into five modules that can be taken separately or together:
1. Introduction: Review of basic concepts and general differences between Excel and GS: definitions, differences in file handling, differences in interfaces. Basic formulas and functions.
2. Basic formulas and functions. Validation, conditional formatting. Filters and order database.
3. Formulas and advanced features: IMPORTRANGE (), INDIRECT (), R1C1, using braces "{}". Share and protect.
4. Pivot Tables: Definition, structure, pivot table - oriented databases. Charts: Presentation, SPARKLINE (), Explore.
5. Google Apps Script (macros): Definition, use, construction and references.
We also offer the possibility to make workshops that can help specific groups with a specific task or implementation, for instance to migrate specific spreadsheets from other platforms to Google Sheets.