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.
Duration 7 hours
Course Outline
1. Introduction to Google Sheets
- Overview of Google Sheets within the Google Workspace ecosystem
- Advantages of cloud-based spreadsheet solutions for public sector operations
- Accessing Google Sheets via web browsers for government workflows
- Understanding the interface and user experience of Google Sheets
- Creating new spreadsheets for administrative tasks:
- Creating blank workbooks
- Utilizing standard templates
- Importing existing data files
- Navigating the structure of sheets, rows, columns, and cells
- Managing multiple worksheets for complex projects
2. Managing Data in Google Sheets
- Inputting and modifying data entries
- Handling various data types:
- Text strings
- Numerical values
- Date and time stamps
- Currency formats
- Percentage calculations
- Ingesting data from external sources for analysis
- Copying, relocating, and structuring data sets
- Sorting and filtering records for review
- Establishing filter views for specific tasks
- Eliminating duplicate records
- Executing find and replace operations
- Implementing data validation and dropdown lists
3. Formatting Google Sheets Spreadsheets
- Applying standard formatting rules
- Formatting individual cells, rows, and columns
- Configuring number display options
- Implementing conditional formatting rules
- Applying themes and style guides
- Designing professional layouts for government reports
- Freezing rows and columns for ease of navigation
- Securing specific ranges and worksheets
- Preparing documents for printing and distribution
4. Formulas and Functions Fundamentals
- Understanding formula structure in Google Sheets
- Performing basic arithmetic calculations
- Utilizing cell references:
- Relative reference logic
- Absolute reference anchoring
- Mixed reference applications
- Employing common functions for data processing:
- SUM for aggregation
- AVERAGE for central tendency
- COUNT for frequency analysis
- MIN and MAX for range determination
- IF statements for conditional logic
- Utilizing text manipulation functions
- Processing date and time data
- Managing errors within formulas
5. Advanced Functions and Data Analysis
- Applying logical reasoning functions
- Using lookup functions for data retrieval:
- VLOOKUP for vertical searches
- XLOOKUP for flexible lookups
- INDEX and MATCH for complex references
- Performing conditional aggregations:
- SUMIF for single-condition sums
- SUMIFS for multi-condition sums
- COUNTIF for single-condition counts
- COUNTIFS for multi-condition counts
- Processing array-based data structures
- Implementing named ranges for clarity
- Generating dynamic calculation models
- Analyzing large, structured datasets
6. Creating Charts and Visualizing Data
- Selecting appropriate chart types for data storytelling
- Generating charts within Google Sheets
- Customizing visual elements for clarity
- Utilizing specific chart formats:
- Column charts for comparisons
- Bar charts for categorical data
- Line charts for trends over time
- Pie charts for proportional analysis
- Scatter charts for correlation studies
- Incorporating labels and explanatory notes
- Constructing dashboards for performance monitoring
- Presenting analytical insights visually for stakeholders
7. Sharing and Collaborating in Google Sheets
- Distributing spreadsheets to individuals and departments
- Configuring permission levels for access control:
- Viewer access for read-only purposes
- Commenter access for feedback
- Editor access for modifications
- Administering access settings and security
- Engaging in real-time collaborative editing
- Utilizing comments and user mentions
- Assigning specific action items to staff
- Monitoring change logs for accountability
- Reviewing version history and restoring previous 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 routine workflows using simple tools
- Configuring notifications and alerts for updates
- Adhering to best practices for team-based data management
9. Business Challenge Workshop
- Developing a comprehensive spreadsheet for a real-world scenario
- Importing and cleansing operational data
- Applying complex formulas and functions
- Generating charts and executive summaries
- Distributing the spreadsheet to relevant collaborators
- Implementing protection and collaboration settings
- Presentation of results and strategic insights
10. Summary and Best Practices
- Review of essential Google Sheets capabilities
- Best practices for organizing spreadsheet resources
- Techniques for ensuring data accuracy and integrity
- Establishing efficient collaboration workflows
- Recommended resources for ongoing professional development
Requirements
None
Audience
- Team leaders, managers, HR Business Partners, project managers, mentors.
Testimonials (1)
Tips such as, asking my team What else can I say to you so you are successful. Be a better leader by learning to trust the team and hold them accountable.
