Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
1. Introduction to Google Sheets
- Overview of Google Sheets and the Google Workspace ecosystem
- Advantages of cloud-based spreadsheet solutions
- Navigating Google Sheets via a web browser
- Familiarisation with the Google Sheets interface
- Initiating new spreadsheets:
- Blank documents
- Pre-defined templates
- Importing existing files
- Navigating sheets, rows, columns, and cells
- Managing multiple worksheets simultaneously
2. Data Management in Google Sheets
- Entering and editing data
- Handling various data types:
- Text
- Numerical values
- Dates
- Currency
- Percentages
- Importing data from external sources
- Copying, moving, and organising data
- Sorting and filtering information
- Establishing filter views
- Eliminating duplicate entries
- Locating and replacing data
- Data validation techniques and dropdown lists
3. Formatting Google Sheets Spreadsheets
- Applying fundamental formatting
- Formatting cells, rows, and columns
- Number formatting options
- Conditional formatting rules
- Utilising themes and styles
- Designing professional spreadsheet layouts
- Freezing rows and columns for visibility
- Protecting ranges and entire sheets
- Preparing spreadsheets for printing and distribution
4. Fundamentals of Formulas and Functions
- Understanding formulas within Google Sheets
- Constructing basic calculations
- Utilising cell references:
- Relative references
- Absolute references
- Mixed references
- Working with common functions:
- SUM
- AVERAGE
- COUNT
- MIN and MAX
- IF statements
- Employing text functions
- Handling date and time functions
- Error handling within formulas
5. Advanced Functions and Data Analysis
- Logical functions
- Lookup functions:
- VLOOKUP
- XLOOKUP
- INDEX and MATCH
- Conditional calculations:
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- Working with arrays
- Utilising named ranges
- Constructing dynamic calculations
- Analyzing structured datasets
6. Creating Charts and Visualizing Data
- Selecting the appropriate chart type
- Generating charts within Google Sheets
- Customising chart aesthetics
- Working with:
- Column charts
- Bar charts
- Line charts
- Pie charts
- Scatter charts
- Adding labels and annotations
- Building dashboards using charts
- Visually presenting spreadsheet insights
7. Sharing and Collaborating in Google Sheets
- Sharing spreadsheets with individuals and groups
- Understanding permission levels:
- Viewer
- Commenter
- Editor
- Managing access settings
- Engaging in real-time collaboration
- Utilising comments and mentions
- Assigning action items
- Tracking changes
- Utilising version history to restore previous versions
8. Advanced Collaboration and Productivity Features
- Leveraging Google Workspace integrations
- Linking data between different spreadsheets
- Integrating Google Forms with Sheets
- Automating workflows using simple tools
- Utilising notifications and alerts
- Adhering to best practices for team-based spreadsheet management
9. Business Challenge Workshop
- Constructing a business-focused spreadsheet from a real-world scenario
- Importing and cleaning business data
- Applying formulas and functions
- Creating charts and summaries
- Sharing the spreadsheet with collaborators
- Applying protection and collaboration settings
- Presenting results and insights
10. Summary and Best Practices
- Review of key Google Sheets features
- Best practices for spreadsheet organisation
- Techniques for ensuring data accuracy and quality
- Efficient collaboration workflows
- Recommended resources for continued learning
Requirements
None
Audience
- Team leaders, managers, HR Business Partners, project managers, and mentors.
7 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 1300 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
training and feedback
Jochen Jung - Bachem
Course - DZM – delegating tasks and motivating employees
Promoting the interaction between people.
