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 within the Google Workspace ecosystem
- Advantages of cloud-based spreadsheet solutions
- Accessing Google Sheets via web browsers
- Familiarizing with the Google Sheets interface
- Setting up new spreadsheets:
- Blank sheets
- Utilizing templates
- Importing existing files
- Navigating rows, columns, cells, and worksheets
- Managing multiple worksheets within a file
2. Managing Data in Google Sheets
- Entering and editing data efficiently
- Handling various data types:
- Text
- Numeric values
- Dates
- Currency
- Percentages
- Importing data from external sources
- Copying, moving, and organizing data structures
- Sorting and filtering information
- Creating and utilizing filter views
- Identifying and removing duplicate entries
- Searching and replacing data
- Implementing data validation and dropdown lists
3. Formatting Google Sheets Spreadsheets
- Applying basic formatting rules
- Styling cells, rows, and columns
- Understanding number formatting options
- Implementing conditional formatting
- Leveraging themes and styles
- Designing professional spreadsheet layouts
- Freezing headers and columns for better navigation
- Securing specific ranges and sheets
- Preparing spreadsheets for printing and distribution
4. Fundamentals of Formulas and Functions
- Understanding the basics of formulas in Google Sheets
- Building basic calculations
- Utilizing cell references:
- Relative references
- Absolute references
- Mixed references
- Employing common functions:
- SUM
- AVERAGE
- COUNT
- MIN and MAX
- IF statements
- Using text manipulation functions
- Working with date and time functions
- Troubleshooting formula errors
5. Advanced Functions and Data Analysis
- Mastery of logical functions
- Lookup capabilities:
- VLOOKUP
- XLOOKUP
- INDEX and MATCH
- Performing conditional calculations:
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- Working with array formulas
- Defining and using named ranges
- Building dynamic calculations
- Analyzing structured datasets
6. Creating Charts and Visualizing Data
- Selecting appropriate chart types for your data
- Generating charts within Google Sheets
- Customizing chart aesthetics
- Creating specific chart formats:
- Column charts
- Bar charts
- Line charts
- Pie charts
- Scatter charts
- Adding labels and annotations for clarity
- Building dashboards using integrated charts
- Visually presenting spreadsheet insights
7. Sharing and Collaborating in Google Sheets
- Sharing spreadsheets with specific individuals or groups
- Understanding permission levels:
- Viewer access
- Commenter access
- Editor access
- Managing access settings effectively
- Collaborating in real-time
- Utilizing comments and @mentions
- Assigning actionable tasks
- Monitoring change history
- Accessing version history and restoring previous iterations
8. Advanced Collaboration and Productivity Features
- Leveraging Google Workspace integrations
- Linking data across multiple spreadsheets
- Integrating Google Forms with Sheets
- Automating workflows using simple tools
- Setting up notifications and alerts
- Adopting best practices for team-based spreadsheet management
9. Business Challenge Workshop
- Developing a business spreadsheet based on real-world scenarios
- Importing and cleaning operational data
- Applying relevant formulas and functions
- Generating charts and summary reports
- Sharing the document with stakeholders
- Implementing protection and collaboration settings
- Presenting results and actionable insights
10. Summary and Best Practices
- Review of essential Google Sheets features
- Best practices for organizing spreadsheets
- Techniques for ensuring data accuracy and quality
- Efficient workflows for team collaboration
- Recommended resources for ongoing learning
Requirements
No prior experience required.
Target Audience
- Team leaders, managers, HR Business Partners, project managers, and mentors.
7 Hours
Testimonials (2)
training and feedback
Jochen Jung - Bachem
Course - DZM – delegating tasks and motivating employees
Promoting the interaction between people.
