This comprehensive introduction covers the entire Google Workspace ecosystem, equipping you with practical knowledge to effectively share and collaborate on spreadsheets, documents, presentations, and video meetings. Participants will gain hands-on familiarity with Google Drive's file management capabilities and explore how to leverage Google Meet for seamless online communication and screen sharing. The course introduces key applications, including Drive, Sheets, Slides, Forms, and Meet.
Ideal Course Participants:
This course serves professionals seeking a quick orientation to Google Workspace applications, cloud-based file storage and collaboration features, and modern video conferencing tools. It is particularly valuable for individuals transitioning from Microsoft Office environments to Google's integrated platform.
Required Background Knowledge:
Participants should have basic email experience and familiarity with creating and editing documents. Previous experience with Microsoft Office applications is beneficial but not required for success in this course.
Comprehensive Course Structure:
Navigating and Managing Google Drive
- Logging into Google Apps and account management
- Using the Google Apps Menu for efficient navigation
- Interpreting the Google Drive display screen and layout
- Customizing Google Drive display settings and preferences
- Creating new files directly from Drive
- Making duplicate copies of existing files
- Organizing files by moving them to the Trash
- Uploading files from your computer
- Creating and organizing folder structures
- Uploading entire folder hierarchies
- Finding files using the search functionality
- Adding shortcuts to frequently used files
- Utilizing Drive priority and workspace organization features
- Adjusting Google Drive settings for your workflow
Collaborative Features in Google Drive
- Sharing files and folders with specific people
- Creating shareable links to files and folders
- Publishing documents and content to the web
Essential Features Across Google Applications
- Opening and launching Google applications
- Navigating menus and using the toolbar
- Accessing help resources within applications
- Creating new documents and files
- Renaming files for organization
- Sending files via email as attachments
- Converting files to Microsoft Office formats
- Opening Microsoft Office files within Google Apps
- Managing document versions and revision history
Google Sheets for Spreadsheet Management
- Understanding the Sheets interface and layout
- Building formulas for calculations
- Working with built-in functions
- Accessing the comprehensive Google Sheets functions reference
- Formatting numbers for clarity and consistency
- Previewing and printing spreadsheets
- Creating charts to visualize data
- Using the Chart Editor for setup configuration
- Customizing charts with Chart Editor options
- Building and analyzing pivot tables
- Creating and referencing named ranges
- Protecting sheets and specific cell ranges
Google Docs for Document Creation
- Navigating the Google Docs interface
- Changing view modes for document editing
- Embedding images within documents
- Adding page numbers and headers/footers
- Using styles for consistent formatting
- Organizing content with the document outline
- Using Suggesting Mode for collaborative feedback
- Adding and managing comments within documents
Google Slides for Presentations
- Understanding the Google Slides interface and design elements
- Adjusting presentation view modes
- Adding and formatting text within slides
- Inserting images and visual content
- Adding, removing, and rearranging slides
- Applying themes for professional design
- Adding slide transitions and animations
- Presenting slideshows to audiences
- Using Presenter View and audience interaction tools
Google Forms for Data Collection
- Understanding the Google Forms interface
- Creating forms and surveys
- Adding various question types
- Distributing forms to respondents
- Connecting forms to spreadsheets for response collection
- Analyzing form response data
Google Meet for Video Communication
- Scheduling meetings from Google Calendar
- Joining scheduled video meetings
- Navigating the Google Meet interface
- Sharing your screen during meetings
- Managing participants and meeting settings
- Configuring audio and video quality
- Starting meetings from Gmail accounts
- Initiating meetings from Google Meet directly
