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 and the Google Workspace ecosystem
- Advantages of cloud-based spreadsheet platforms
- Accessing Google Sheets via web browsers
- Navigating the Google Sheets user interface
- Creating new spreadsheets:
- Starting with blank sheets
- Utilising templates
- Importing pre-existing files
- Managing sheets, rows, columns, and individual cells
- Handling multiple worksheets
2. Data Management in Google Sheets
- Inputting and modifying data entries
- Working with various data types:
- Text
- Numerical values
- Dates
- Currency
- Percentages
- Importing data from external sources
- Copying, moving, and organising data structures
- Sorting and filtering information
- Creating filter views
- Eliminating duplicate entries
- Locating and replacing specific data points
- Data validation and dropdown menu implementation
3. Formatting Spreadsheets in Google Sheets
- Applying basic formatting standards
- Styling cells, rows, and columns
- Configuring number formats
- Implementing conditional formatting rules
- Utilising themes and style presets
- Designing professional spreadsheet layouts
- Freezing specific rows and columns
- Securing ranges and individual sheets
- Preparing spreadsheets for print and digital distribution
4. Fundamentals of Formulas and Functions
- Comprehending formula logic in Google Sheets
- Performing basic calculations
- Utilising cell references:
- Relative references
- Absolute references
- Mixed references
- Applying common functions:
- SUM
- AVERAGE
- COUNT
- MIN and MAX
- Conditional IF statements
- Employing text manipulation functions
- Handling date and time calculations
- Managing formula errors
5. Advanced Functions and Data Analysis
- Complex logical functions
- Lookup operations:
- VLOOKUP
- XLOOKUP
- INDEX and MATCH combinations
- Conditional aggregation:
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- Working with array formulas
- Implementing named ranges
- Building dynamic calculations
- Anlysing structured datasets
6. Chart Creation and Data Visualisation
- Selecting appropriate chart types
- Generating charts within Google Sheets
- Customising chart aesthetics and settings
- Working with specific chart formats:
- Column charts
- Bar charts
- Line charts
- Pie charts
- Scatter charts
- Adding data labels and annotations
- Constructing dashboards using chart elements
- Visually presenting spreadsheet insights
7. Sharing and Collaboration in Google Sheets
- Sharing spreadsheets with specific individuals or groups
- Understanding permission tiers:
- Viewer access
- Commenter access
- Editor access
- Managing access controls
- Engaging in real-time collaboration
- Utilising comments and user mentions
- Assigning actionable tasks
- Monitoring change logs
- Accessing version history and restoring previous states
8. Advanced Collaboration and Productivity Tools
- Integrating with other Google Workspace applications
- Linking data across multiple spreadsheets
- Combining Google Forms with Sheets for data collection
- Automating workflows using simple utility tools
- Configuring notifications and alert systems
- Best practices for managing team-based spreadsheets
9. Business Case Workshop
- Building a business spreadsheet from a real-world scenario
- Importing and cleaning business data
- Applying relevant formulas and functions
- Generating charts and summary reports
- Sharing the final spreadsheet with collaborators
- Applying protection and collaboration settings
- Presenting final results and key insights
10. Conclusion and Best Practices
- Review of essential Google Sheets capabilities
- Best practices for spreadsheet organisation
- Techniques for ensuring data accuracy and quality
- Optimising collaboration workflows
- Recommended resources for further development
Requirements
No prior experience is required.
Intended Audience
- Team leaders, managers, HR Business Partners, project managers, and mentors.
Testimonials (2)
Reports structuring, analysis, presentation, flexibility, editable...
PASCALE EL YAMMOUNY - Ora Invest
Course - Claude for Executive Leadership: Strategy, Decision-Making and Competitive Advantage
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.
