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 adopting cloud-based spreadsheet platforms
- Accessing Google Sheets via web browser interfaces
- Navigating the Google Sheets user interface
- Initiating new workbooks:
- Blank templates
- Pre-configured templates
- Importing external file formats
- Navigating worksheets, rows, columns, and individual cells
- Managing multiple worksheets within a single workbook
2. Managing Data in Google Sheets
- Data entry and editing procedures
- Handling various data types:
- Text values
- Numeric values
- Date values
- Currency formats
- Percentage formats
- Importing data from external repositories
- Duplicate, move, and organize data entries
- Sorting and filtering datasets
- Creating custom filter views
- Identifying and removing duplicate entries
- Search and replace operations
- Implementing data validation and dropdown menus for government
3. Formatting Google Sheets Spreadsheets
- Applying standard formatting rules
- Formatting cells, rows, and columns
- Numeric formatting options
- Conditional formatting protocols
- Utilizing themes and styles
- Designing professional spreadsheet layouts for official use
- Freezing header rows and columns
- Securing specific ranges and sheets
- Preparing documents for print distribution and external sharing
4. Formulas and Functions Fundamentals
- Understanding the role of formulas in Google Sheets
- Constructing basic arithmetic calculations
- Utilizing cell references:
- Relative references
- Absolute references
- Mixed references
- Implementing common functions:
- SUM
- AVERAGE
- COUNT
- MIN and MAX
- IF logical statements
- Utilizing text manipulation functions
- Working with date and time functions
- Troubleshooting formula errors
5. Advanced Functions and Data Analysis
- Logical functions for complex decision-making
- Lookup functions:
- VLOOKUP
- XLOOKUP
- INDEX and MATCH
- Conditional aggregation:
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- Working with array operations
- Defining and using named ranges
- Constructing dynamic calculation models
- Analyzing structured datasets for government reporting
6. Creating Charts and Visualizing Data
- Selecting appropriate chart types for data representation
- Generating charts in Google Sheets
- Customizing chart aesthetics and elements
- Utilizing specific chart formats:
- Column charts
- Bar charts
- Line charts
- Pie charts
- Scatter plots
- Adding labels and annotations for clarity
- Building dashboards using chart components
- Visually presenting spreadsheet insights to stakeholders
7. Sharing and Collaborating in Google Sheets
- Distributing spreadsheets to individuals and groups
- Understanding permission levels:
- Viewer access
- Commenter access
- Editor access
- Managing access settings and security protocols
- Real-time collaboration techniques
- Utilizing comments and @mentions for communication
- Assigning action items to team members
- Monitoring change history
- Accessing version history and restoring previous document states
8. Advanced Collaboration and Productivity Features
- Leveraging Google Workspace integrations
- Linking data across multiple spreadsheets
- Integrating Google Forms with Sheets for data collection
- Automating workflows using available tools
- Configuring notifications and alerts
- Adhering to best practices for team-based spreadsheet management
9. Business Challenge Workshop
- Developing a business spreadsheet solution from real-world scenarios
- Importing and cleaning operational data
- Applying appropriate formulas and functions
- Creating charts and executive summaries
- Distributing the completed spreadsheet to collaborators
- Implementing protection measures and collaboration settings
- Presenting analytical results and insights to decision-makers
10. Summary and Best Practices
- Review of key Google Sheets capabilities relevant for government
- Best practices for organizing spreadsheets effectively
- Techniques for ensuring data accuracy and quality
- Efficient workflows for collaborative projects
- Recommended resources for ongoing professional development
Requirements
N/A
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.