Course Outline

Module 1: Advanced Google Docs and Sheets

• Mastering document formatting, templates, and collaborative features in Google Docs
• Applying advanced formulas, pivot tables, and data visualization in Google Sheets
• Automating workflows by linking Google Docs and Sheets
• Integrating add-ons for enhanced functionality across projects
• Case Study: How a project team used Google Docs and Sheets to streamline reporting and analysis

Module 2: Efficient Email Management with Gmail

• Organizing emails with filters, labels, and folders for efficient inbox management
• Setting up and managing email automation with filters and templates
• Utilizing advanced Gmail features such as priority inbox and tasks integration
• Managing multiple accounts and delegating email access
• Case Study: A customer support team’s use of Gmail automation for faster responses

Module 3: Mastering Google Drive and Shared Drives

• Organizing files systematically with folders, naming conventions, and metadata
• Collaborating efficiently using shared drives for team projects
• Managing advanced file sharing, permission levels, and version control
• Integrating Google Drive with third-party apps for enhanced productivity
• Case Study: A marketing team optimizing content collaboration with shared drives

Module 4: Advanced Scheduling with Google Calendar

• Managing complex schedules and recurring events in Google Calendar
• Creating and sharing multiple calendars for project coordination
• Using reminders, notifications, and time-blocking techniques for efficiency
• Integrating Google Calendar with other Google Workspace tools and devices
• Case Study: A sales team using advanced scheduling to coordinate meetings across time zones

Module 5: Professional Video Conferencing with Google Meet

• Setting up and managing virtual meetings, webinars, and breakout rooms
• Utilizing advanced features like polls, Q&A, and recording options
• Best practices for effective virtual communication and engagement
• Integrating Google Meet with Google Calendar and other apps
• Case Study: A training department delivering remote workshops using Google Meet tools