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
- Accessing Google Sheets via web browser
- Understanding the Google Sheets user interface
- Creating new spreadsheets:
- Starting with a blank sheet
- Using pre-designed templates
- Importing existing files
- Navigating through sheets, rows, columns, and cells
- Managing multiple worksheets within a spreadsheet
2. Managing Data in Google Sheets
- Inputting and editing data
- Handling various data types:
- Text
- Numbers
- Dates
- Currency
- Percentages
- Importing data from external sources
- Copying, moving, and structuring data
- Sorting and filtering information
- Creating filter views
- Eliminating duplicate entries
- Searching for and replacing specific data
- Applying data validation and dropdown lists
3. Formatting Google Sheets Spreadsheets
- Applying basic formatting styles
- Formatting cells, rows, and columns
- Configuring number formats
- Implementing conditional formatting rules
- Utilizing themes and styles
- Designing professional spreadsheet layouts
- Freezing rows and columns for better visibility
- Protecting specific ranges and sheets
- Preparing spreadsheets for printing and distribution
4. Formulas and Functions Fundamentals
- Understanding formulas in Google Sheets
- Constructing basic calculations
- Utilizing cell references:
- Relative references
- Absolute references
- Mixed references
- Applying common functions:
- SUM
- AVERAGE
- COUNT
- MIN and MAX
- IF statements
- Using text manipulation functions
- Working with date and time functions
- Handling errors 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
- Using named ranges
- Creating dynamic calculations
- Analyzing structured datasets
6. Creating Charts and Visualizing Data
- Selecting the most appropriate chart type
- Generating charts in Google Sheets
- Customizing chart aesthetics
- Utilizing various chart types:
- Column charts
- Bar charts
- Line charts
- Pie charts
- Scatter charts
- Adding labels and annotations
- Building dashboards using charts
- Presenting spreadsheet insights through visual means
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
- Reviewing version history and restoring previous states
8. Advanced Collaboration and Productivity Features
- Integrating with Google Workspace tools
- Linking data between multiple spreadsheets
- Using Google Forms to populate Sheets
- Automating workflows with simple tools
- Setting up notifications and alerts
- Best practices for team-based spreadsheet management
9. Business Challenge Workshop
- Developing a business spreadsheet from a real-world scenario
- Importing and cleansing business data
- Applying relevant formulas and functions
- Generating charts and summaries
- Sharing the spreadsheet with collaborators
- Configuring protection and collaboration settings
- Presenting results and key insights
10. Summary and Best Practices
- Review of essential Google Sheets features
- Best practices for spreadsheet organization
- Techniques for ensuring data accuracy and quality
- Efficient collaboration workflows
- Recommended resources for continued learning
Requirements
No prior requirements
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.
