Working with Google Drive Interface

• Search Functionality
• Document Preview and comments
• Managing File Version for non Google Document Type
• Add File to Multiple Folder
• Priority & Workspace

Google Drive Key Functionality

• Getting File/Folder into Google Drive
• Sharing Drive File/Folder
  • Advanced Sharing Setting (Expiration Date)
  • Track View History using Activity Dashboard

Working with Google Sheets

• Create new Google Sheets
  • Import and convert, Sharing, Page setup
• Collaboration & Document history
• Working with rows, columns and cells
• Data Filtering
  • Create Filter View
• Working with Data
  • Explore, Splitting data into columns
  • Adding and editing named ranges
  • Protecting sheets and ranges
• Functions (Formulas)
  • Conditional Formatting
  • Data Consolidation from Multiple Sheets
  • Web Function: IMPORTRANGE
  • Math Function: IF, SUMIF, COUNTIF
  • Filter Function: UNIQUE, FILTER

Working with Google Forms

• Create New Form
• Add & Edit Question
• Sections Setup
  • Add, Move & Merge Section
• Sending Form and Collecting Responses
  • Ways to send the form, Pre-filled form
  • Spreadsheet responses & Pausing responses

Working with Google Docs

• Document Setup
• Collaboration & Version History
• Insert Menu
  • Page Break / Section Break
  • Images, Table, Table of Content & Chart
• Format Menu
  • Column
  • Header / Footer
  • Paint Format

Working with Google Slides

• Document Setup
• Collaboration & Version History
• Basic Editing
  • Changing slide layout and backgrounds
  • Inserting slide numbers
  • Theme - Custom, Change & Import
  • Edit Master Slide
• Working with Text
  • Font styles & Text Boxes
  • Alignment and spacing
  • Lists and indentation
  • Paint format & Links
• Working with Objects
  • Working with shapes & tables
  • Using lines and connectors
  • Adding images & videos

Working with Template Gallery

• Create Document Template
• Submit to Template Gallery
• Edit Document Template Types of Report
• Create New Document From Template Gallery