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 through 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 different 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 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
- Customizing 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 organization best practices
- Data accuracy and quality techniques
- Efficient collaboration workflows
- Recommended resources for continued learning
Requirements
None.
7 Hours
Testimonials (2)
The final day which is the Machine Learning Topic
John Erick Baltazar - Globe Telecom
Course - Google BigQuery
It was a really good training course, well prepared and explained by the trainer with great hands on experience on GCP.
