
Discover how Google apps enable private and professional collaboration through email, chat, and video conferencing, plus calendar, drive, and documents, with tips, quizzes, and offline access via Chrome.
Learn to compose an email in Gmail by clicking compose and entering recipients with address book auto-complete. Format text with bold, font size, colors, bullets, and remove formatting as needed.
Learn to insert images and attach files in Gmail, using select photos, drag and drop, or the paperclip, and manage in-message visibility, with multi-select and removal tips.
Organize your Gmail inbox with preset categories, starring messages, and archiving, while managing drafts, sent, spam, and trash and restoring items from all mail.
Learn how to categorize Gmail messages with labels, create and color-code labels, and assign multiple labels to a single message for efficient email organization.
Learn to organize your inbox with Gmail filters by creating rules that label messages and skip the inbox based on sender, subject, attachments, or size.
Explore Gmail's conversations view, which groups messages into a single thread with a summary line and message count, and learn to hide quoted parts and switch off the view.
Learn how Gmail search scans emails and attachments to find information with keywords, use advanced search to narrow results, and leverage autocomplete for addresses from your address book.
Learn to work with Gmail offline by installing Chrome and the Gmail offline extension, enabling you to compose and edit emails while disconnected and send them when online.
Learn how to enable Gmail's undo send, set a cancellation period, and recall a sent email to add a missing attachment before resending.
Manage your Gmail address book by adding contacts, creating groups, and saving details like phone numbers; identify duplicates, merge them, and import or export contacts from Outlook.
Explore Google Hangouts for chat and video calls in Chrome, Firefox, and Safari. Learn to host up to 10 participants, switch to audio, and add landlines for nonaccount users.
Learn to start a chat or video call directly from Gmail, and switch between chats. Adjust microphone, speakers, and video quality to ensure a smooth call.
Create and edit events in Google Calendar, setting time ranges, titles, and details, including all-day and repeating options, with locations, reminders, and inviting participants.
Respond to calendar invitations by confirming or rejecting, and adding a comment. View participant calendars, use find a time to check schedule, and, if authorized, move event and save changes.
Find a time to locate a common date and time, then share your calendar in Google Apps for work with colleagues and set visibility from availability only to full details.
Add calendars from others by searching for shared calendars, subscribe to public calendars like world holidays and Chicago White Sox schedules, and customize colors while toggling visibility.
Explore Google Drive as online storage for documents, photos, and videos, accessible from any device with internet; learn saving attachments, attaching from Drive to emails, and navigating folders.
Upload files and folders to Google Drive by new upload, drag and drop, or folder creation, then organize with subfolders and list view or date sort.
Learn how to set up Google Drive desktop synchronization, linking a local folder to Google Drive so files auto-sync between your computer and online storage.
Explore how Google Drive syncs deletions between your local folder and the cloud, moving files to trash, and learn to restore from trash and resync them.
Master Drive organization by creating folders, moving files, and starring items for quick access. Use the recent view and keyword search with file type filters to locate documents fast.
Discover how Google apps for beginners lets you create text documents, spreadsheets, and presentations online, with real-time collaboration, version history, and easy file conversion to and from Microsoft Office.
Learn to create and format text in Google Docs, including naming documents, building meeting minutes with bullets and tables, applying bold, colors, alignment, and auto-save.
Explore Google Docs spellcheck, personal dictionary tweaks, translation, word lookup, footnotes, image search, and customizable text substitutions to streamline writing.
Learn to insert images into Google documents from local files, Google Drive, Picasa albums, webcam capture, or image URLs, and align them with text using line, wrap, or top/bottom options.
Learn to convert Google Docs to Microsoft Word and back, and swap Google Sheets with Excel and Google Slides with PowerPoint.
Learn how to collaborate in Google Docs by sharing with others, setting view, comment, or edit permissions, and working in real time with chat and comments.
Learn how to add and manage interactive comments in Google Docs, including selecting text, sharing with collaborators, replying asynchronously, editing resolved comments, and focusing on conversations with many comments.
Enable offline work in Google Chrome to continue editing documents when disconnected. Changes sync to Google Drive when back online, and you can work on your local Google Drive folder.
Explore how Google docs uses revision history to track changes with color-coded user edits and how to restore a past version to continue editing.
Learn to edit sales rows and columns in Google Sheets, apply conditional formatting and data validation, and use functions, while collaborating via sharing, comments, chat, and revision history.
Learn to create and format a Google Sheet in Google Drive, including setting up rows and columns, bold headers with borders, and currency and percentage formats.
Apply conditional formatting in sheets to color a range by value, using rules such as greater than or equal to 2.50 in red and less than 250 in green.
Master data validation in sheets to restrict entries to a specific value or list of elements, such as 5, 10, or 15 pieces, with rejection or warning on invalid input.
Manage multiple worksheets: duplicate the current sheet to copy values, formatting, and functions. Rename and color sheets for clarity, protect edits, and add new empty worksheets with the plus symbol.
Create a chart from the first two rows in Google Sheets, choose a pie chart, adjust the legend and colors, enable 3D view, and publish a shareable link.
Learn to use sheets functions and formulas for calculations, including sum, average, min, max, and text operations like the left function.
Learn to define a theme and layout, populate slides with text, images, or videos, and apply transitions, animations, and printing options, including collaboration and offline work in Chrome.
Explore how to set themes and layouts in Google Slides, import themes from other presentations, and adjust title pages, two-column layouts, and text positioning to customize your slides.
Learn to add text, images, and videos to slides in Google Apps for Beginners. Format text and insert visuals.
Learn to add slide transitions with adjustable speed across all slides, then create in-slide animations, line-by-line reveals, a rounded rectangle with orange border, an arrow, and text animated together.
Start the presentation in full screen, navigate slides with the mouse wheel or arrow keys, and use the bottom menu to jump to specific slides; press escape to exit.
Learn the basics of Google apps, including email, image attachments with labels, chats, Hangouts with screen sharing, Drive uploads, calendar events, and Docs, Sheets, and Slides with revision history.
Google Apps is a suite of apps which offers a free alternative to Microsoft Office or Microsoft Office 365, respectively. Each Google Apps corresponds to a product you might already know:
The course is addressed to everyone who is new to Google Apps, or to Google Apps for Work which is a corporate version of Google Apps.
Especially if you used to work with Microsoft Office or Outlook this course might help you to overcome your initial difficulties. I will show you all essential DO's and DONT's.
The course is divided into 47 short lectures - each of them providing all necessary information about a topic but not wasting time in repetitions. My motivation for the course was to pass on my own experiences I had when being new to Google Apps.
I want you to save time and avoid fears of contact which I had myself. Further, I will pass on some tips and tricks which took me some time to discover but which provide very useful shortcuts for your daily work.
When I worked for a multinational company we have switched from Microsoft Exchange to Google Apps and I trained quite a few colleagues in how to use Google Apps. I have got to know all stumbling blocks but also all the great advantages which Google Apps will bring to you.
This course will guide you step by step through the single apps and explain how they interact with each other.
Now enjoy and have fun!