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 utilizing cloud-based spreadsheet solutions
- Accessing Google Sheets via a web browser
- Navigating the Google Sheets user interface
- Initiating new spreadsheets:
- Blank documents
- Pre-built templates
- Importing existing files
- Navigating sheets, rows, columns, and cells
- Managing multiple worksheets simultaneously
2. Managing Data in Google Sheets
- Entering and editing data efficiently
- Handling various data types:
- Text
- Numerical values
- Dates
- Currency
- Percentages
- Importing data from external sources
- Copying, relocating, and organizing data sets
- Sorting and filtering information
- Establishing filter views
- Identifying and removing duplicate entries
- Searching for and replacing specific data
- Implementing data validation and dropdown lists
3. Formatting Google Sheets Spreadsheets
- Applying basic formatting options
- Formatting individual cells, rows, and columns
- Utilizing number formatting options
- Employing conditional formatting rules
- Using themes and styles for consistency
- Designing professional spreadsheet layouts
- Freezing rows and columns for better navigation
- Protecting specific ranges and entire sheets
- Preparing spreadsheets for print distribution and sharing
4. Formulas and Functions Fundamentals
- Grasping the concept of formulas in Google Sheets
- Constructing basic calculations
- Utilizing cell references:
- Relative references
- Absolute references
- Mixed references
- Working with common functions:
- SUM
- AVERAGE
- COUNT
- MIN and MAX
- IF statements
- Leveraging text manipulation functions
- Utilizing date and time functions
- Handling errors within formulas
5. Advanced Functions and Data Analysis
- Employing logical functions
- Using lookup functions:
- VLOOKUP
- XLOOKUP
- INDEX and MATCH
- Performing conditional calculations:
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- Working with array formulas
- Defining and using named ranges
- Creating dynamic calculation models
- Analyzing structured datasets effectively
6. Creating Charts and Visualizing Data
- Selecting the appropriate chart type for your data
- Generating charts within Google Sheets
- Customizing chart aesthetics and appearance
- Working with various chart types:
- Column charts
- Bar charts
- Line charts
- Pie charts
- Scatter charts
- Adding labels and annotations for clarity
- Constructing dashboards using chart elements
- Presenting spreadsheet insights through visual representations
7. Sharing and Collaborating in Google Sheets
- Distributing spreadsheets to individuals and groups
- Understanding permission levels:
- Viewer
- Commenter
- Editor
- Managing access settings securely
- Collaborating in real-time with team members
- Utilizing comments and @mentions for communication
- Assigning action items within the sheet
- Tracking changes made by collaborators
- Accessing version history and restoring previous iterations
8. Advanced Collaboration and Productivity Features
- Integrating with other Google Workspace applications
- Linking data across multiple spreadsheets
- Utilizing Google Forms in conjunction with Sheets
- Automating workflows using built-in tools
- Configuring notifications and alerts
- Adopting best practices for team-based spreadsheet management
9. Business Challenge Workshop
- Developing a business-oriented spreadsheet based on real-world scenarios
- Importing and cleansing business data
- Applying relevant formulas and functions
- Generating charts and executive summaries
- Distributing the spreadsheet to collaborators
- 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 education
Requirements
No prerequisites are required.
Target Audience
- Team leads, 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.
