30 Days Challenge - Google Sheet

Richiedi informazioni

Rilasciato da Randstad HR Solutions s.r.l.

Società di consulenza del gruppo Randstad Italia specializzata nell'ambito dei servizi formativi.

Descrizione:

The training lasts 30 days. Participants will be invited to a Google Classroom where each day a video tutorial is posted. These explainer videos cover one specific topic and are filled with tips and tricks to become truly productive with G Suite.

Competenze:

At the end of the course the user will be able to speed up their activities in a Google Sheet thanks to the understanding of the tool and to apply basic formulas (IF, COUNT, SORT, FILTER, VLOOKUP), Pivot, filter view, data validation, more complex formulas (IMPORTRANGE, QUERY), MACROS and to make the best use graphics and interaction with Workspace Apps such as Docs and Slides.

Competenze trasversali:

• Problem solving

• Lavorare in autonomia

• Flessibilità e adattamento

Fonte competenze trasversali:

• Indagine Unioncamere Excelsior, “Il lavoro dopo gli studi” (2024)

Abilità:

- Basic Calculation
- Spreedsheet & Print Settings
- Cell Formatting
- Format Numbers
- Version History & Cell History
- Filters & Filter viess
- Alternating colors
- Conditional Formatting
- Count Formulas
- Freez or group rows & columns
- Data Validation
- Link to specific data
- Named Ranges
- Transpose Data
- Protect Sheet & Ranges
- IF Formula
- Pivot Table
- Sort & Filter Formulas
- Charts
- Slicers
- Sparklines
- Macros
- Importrange
- Query
- Notification Rules
- Shortcuts
- Themes & Templates
- Explore