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 Google Workspace
- Benefits of cloud-based spreadsheet solutions
- Accessing Google Sheets via a web browser
- Navigating the Google Sheets interface
- Creating new spreadsheets:
- Blank sheets
- Templates
- Importing existing files
- Navigating sheets, rows, columns, and cells
- Managing multiple worksheets
2. Managing Data in Google Sheets
- Entering and editing data
- Working with various data types:
- Text
- Numbers
- Dates
- Currency
- Percentages
- Importing data from external sources
- Copying, moving, and organizing data
- Sorting and filtering information
- Creating filter views
- Removing duplicate entries
- Finding and replacing data
- Data validation and dropdown lists
3. Formatting Google Sheets Spreadsheets
- Applying basic formatting
- Formatting cells, rows, and columns
- Number formatting options
- Conditional formatting
- Using themes and styles
- Designing professional spreadsheet layouts
- Freezing rows and columns
- Protecting ranges and sheets
- Preparing spreadsheets for printing and sharing
4. Fundamentals of Formulas and Functions
- Understanding formulas in Google Sheets
- Creating basic calculations
- Using cell references:
- Relative references
- Absolute references
- Mixed references
- Working with common functions:
- SUM
- AVERAGE
- COUNT
- MIN and MAX
- IF statements
- Utilizing text functions
- Working with date and time functions
- Error handling in 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
- Using named ranges
- Creating dynamic calculations
- Analyzing structured datasets
6. Creating Charts and Visualizing Data
- Selecting appropriate chart types
- Creating charts in Google Sheets
- Customizing chart appearance
- Working with:
- Column charts
- Bar charts
- Line charts
- Pie charts
- Scatter charts
- Adding labels and annotations
- Building dashboards using charts
- Presenting spreadsheet insights visually
7. Sharing and Collaborating in Google Sheets
- Sharing spreadsheets with individuals and groups
- Understanding permission levels:
- Viewer
- Commenter
- Editor
- Managing access settings
- Collaborating in real time
- Using comments and mentions
- Assigning action items
- Tracking changes
- Version history and restoring previous versions
8. Advanced Collaboration and Productivity Features
- Leveraging Google Workspace integrations
- Linking data between spreadsheets
- Integrating Google Forms with Sheets
- Automating workflows with simple tools
- Using notifications and alerts
- Best practices for team-based spreadsheet management
9. Business Challenge Workshop
- Developing a business spreadsheet based on 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
- Spreadsheet organization best practices
- Data accuracy and quality techniques
- Efficient collaboration workflows
- Recommended resources for continued learning
Requirements
None
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.
