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.
- Benefits of cloud-based spreadsheet solutions.
- Accessing Google Sheets via a web browser.
- Understanding the Google Sheets interface.
- Creating new spreadsheets:
- Blank spreadsheets.
- 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 organising data.
- Sorting and filtering information.
- Creating filter views.
- Removing duplicates.
- 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.
- Creating professional spreadsheet layouts.
- Freezing rows and columns.
- Protecting ranges and sheets.
- Preparing spreadsheets for printing and sharing.
4. Formulas and Functions Fundamentals
- 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.
- Using 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
- Choosing the right chart type.
- Creating charts in Google Sheets.
- Customising chart appearance.
- Working with:
- Column charts.
- Bar charts.
- Line charts.
- Pie charts.
- Scatter charts.
- Adding labels and annotations.
- Creating 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
- Working with Google Workspace integrations.
- Linking data between spreadsheets.
- Using Google Forms with Sheets.
- Automating workflows with simple tools.
- Using notifications and alerts.
- Best practices for team-based spreadsheet management.
9. Business Challenge Workshop
- Creating a business 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.
- Spreadsheet organisation best practices.
- Data accuracy and quality techniques.
- Efficient collaboration workflows.
- Recommended resources for continued learning.
Requirements
None required.
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.
