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 Google Workspace
- Advantages of cloud-based spreadsheet solutions
- Accessing Google Sheets via web browser
- Familiarizing with the Google Sheets interface
- Creating new spreadsheets:
- Starting from a blank sheet
- Utilizing templates
- Importing existing files
- Navigating sheets, rows, columns, and cells
- Managing multiple worksheets
2. Managing Data in Google Sheets
- Inputting and modifying data
- Handling various data types:
- Text
- Numbers
- Dates
- Currency
- Percentages
- Importing data from external sources
- Copying, moving, and structuring data
- Sorting and filtering information
- Creating filter views
- Eliminating duplicates
- Locating and substituting data
- Implementing data validation and dropdown lists
3. Formatting Google Sheets Spreadsheets
- Applying standard formatting
- Styling cells, rows, and columns
- Configuring number formats
- Implementing conditional formatting
- Utilizing themes and styles
- Designing professional spreadsheet layouts
- Fixing rows and columns in view
- Safeguarding ranges and sheets
- Optimizing spreadsheets for printing and distribution
4. Formulas and Functions Fundamentals
- Comprehending formulas in Google Sheets
- Performing basic calculations
- Applying cell references:
- Relative references
- Absolute references
- Mixed references
- Utilizing common functions:
- SUM
- AVERAGE
- COUNT
- MIN and MAX
- IF statements
- Employing text functions
- Using date and time functions
- Managing errors in formulas
5. Advanced Functions and Data Analysis
- Applying logical functions
- Using lookup functions:
- VLOOKUP
- XLOOKUP
- INDEX and MATCH
- Performing conditional calculations:
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- Working with arrays
- Utilizing named ranges
- Building dynamic calculations
- Analyzing structured datasets
6. Creating Charts and Visualizing Data
- Selecting appropriate chart types
- Generating charts in Google Sheets
- Customizing chart aesthetics
- Working with specific chart types:
- Column charts
- Bar charts
- Line charts
- Pie charts
- Scatter charts
- Inserting labels and annotations
- Building dashboards using charts
- Visually presenting spreadsheet insights
7. Sharing and Collaborating in Google Sheets
- Sharing spreadsheets with individuals and groups
- Understanding permission levels:
- Viewer
- Commenter
- Editor
- Configuring access settings
- Engaging in real-time collaboration
- Utilizing comments and mentions
- Assigning action items
- Monitoring changes
- Accessing version history and restoring previous versions
8. Advanced Collaboration and Productivity Features
- Leveraging Google Workspace integrations
- Linking data across spreadsheets
- Integrating Google Forms with Sheets
- Streamlining workflows with simple automation tools
- Setting up notifications and alerts
- Adopting best practices for team-based spreadsheet management
9. Business Challenge Workshop
- Developing a business spreadsheet based on a real-world scenario
- Importing and cleaning business data
- Applying formulas and functions
- Generating charts and summaries
- Sharing the spreadsheet with collaborators
- Applying protection and collaboration settings
- Presenting results and insights
10. Summary and Best Practices
- Reviewing key Google Sheets features
- Best practices for spreadsheet organization
- Techniques for ensuring data accuracy and quality
- Optimizing collaboration workflows
- Recommended resources for continued learning
Requirements
No prior experience required.
Target 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.
