
Access the orientation video and explore the view resources section for offline tools, crosswords, flashcards, PDFs, and other study aids that support your Google Office learning.
Learn how to create, edit, and share documents in Google Docs, the fully online word processor. Discover using templates from the document template gallery and uploading documents to start quickly.
Upload and convert files to the Google Docs format from your computer, choosing single files or folders, while managing storage and monitoring upload progress.
Explore the Google Docs interface, from header controls to the collaboration pane. Learn to create, open, and upload documents, name them, and share with others.
Learn to enter and edit text in Google Docs, using insertion point and text selection, cut, copy, and paste, with undo and redo, page setup, and saving documents.
Learn how to apply text alignment in Google Docs, including left, right, center, and justified options, and ensure consistent justification across your document.
Master cut, copy, and paste in Google documents using keyboard shortcuts and the web clipboard to move or duplicate content.
Learn to set up Google documents with page orientation, paper size, page color, and margins from the file menu’s page setup, then apply changes with OK.
Discover how Google Docs saves automatically every three seconds, shows 'all changes saved,' and how to save, copy, paste, and download using keyboard shortcuts to speed editing.
Learn to apply basic text formatting in Google Docs via the formatting toolbar or format menu, including bold, font size, color, and keyboard shortcuts.
Discover font formatting in Google Docs, learn that you cannot add custom fonts, apply multiple formatting options to a single selection, and use Ariel Black to enhance your document.
Learn to adjust line spacing, insert page breaks and horizontal lines, and apply basic paragraph formatting for a professional, well-flowing Google Docs document.
Learn to use the Google Docs ruler to set indents and margins, add and delete tabs, work with lists and paragraph styles, and insert headers and footers.
Master advanced formatting in Google Docs by adjusting indents and tabs directly on the ruler, including dragging indent and tab stops, and setting margins without going into page setup.
Learn to insert and customize headers and footers in Google documents, adding elements like date, title, or copyright across pages, with alignment and formatting tips for professionalism.
Learn to customize documents by inserting and resizing images in Google Docs, choosing upload or other sources, and controlling placement either inline with text or as a fixed position.
Learn to insert and customize hyperlinks in Google Docs, including web addresses, emails, and bookmarks, via the insert menu or right-click, and edit display text.
Master the Google Docs drawing wizard to create, customize, and insert drawings with shapes, text boxes, colors, and borders. Learn to position, rotate, and manage drawings across documents.
Learn to insert and customize tables in Google Docs for quick comparisons, including creating a 3 by 3 table, labeling columns, and applying bold headers and italics.
Learn to customize Google Docs tables by inserting and deleting rows or columns, and using table properties to set borders, cell padding, alignment, minimum heights, and background colors.
Learn to insert and delete rows and columns in a Google Docs table by placing insertion point and choosing insert row above or below, or delete row, column, or table.
Adjust row heights and column widths in Google Docs by dragging, causing content to wrap when columns narrow. Learn why spreadsheets handle complex tables, while Google Docs supports simple comparisons.
Learn how Google Docs proofing works with the built-in spell checker, enable spelling suggestions from the view menu, review misspellings with right-click suggestions, and manage dictionary entries and auto-corrections.
Explore how to use Google Docs find and replace to correct misspellings, locate instances, replace them one by one or replace all, then close the tool.
Explore word usage tools in Google Office: use word count to analyze documents and pages, and use define to look up word meanings with the Google dictionary.
Use Google Documents' translate tool to convert a document into a chosen language from many language options, and rely on the simple, familiar proofing features to ensure quality.
Master time-saving keyboard shortcuts, autocomplete, and auto correct in Google documents to boost efficiency; navigate and select text with home, end, page up/down, and ctrl+home/ctrl+end, and use shift combos.
Explore auto complete and auto correct in Google Documents to save time by updating the dictionary and correcting spellings. Configure automatic substitution in preferences to replace short sequences with phrases.
Learn to navigate long Google Docs by using the find feature, inserting bookmarks, and building a table of contents from paragraph styles and headings.
Learn to navigate long Google Docs by adding bookmarks and inserting a table of contents, which links to bookmarks for quick jumps and updates when you click the update button.
Print and distribute Google Docs by using the file menu or print icon, add page numbers from insert, and preview with left options before printing to PDF.
Download your document in pdf, odt, rtf, text, word, or html to import into other apps or publish as web page, and make a copy if you need a template.
Explore revision history in Google Docs, which stores versions from newest to oldest, shows who changed what and when, and lets you restore or view changes for precise collaboration.
Learn how Google Documents enables real-time, single-document collaboration with revision history and a comments stream. Manage sharing with add users, define access rights, and edit, comment, or view permissions.
Learn to distribute documents by emailing collaborators directly from Google Docs, selecting recipients, composing a subject and message, and optionally pasting the document or sending a copy to yourself.
Learn how to customize notification settings for document collaboration by enabling alerts and selecting options for all comments, replies to your own comments, threads you’ve commented on, and mentions.
Publish your Google documents with a few clicks by selecting the published web option and starting publishing; share via link, embed code, or email.
Create, upload, and present Google Presentations, a light online alternative to PowerPoint in the Google Docs suite. Use templates from the gallery and upload from your local machine.
Upload presentation by clicking the upload button and selecting a file. Choose processing options, including conversion to Google Docs or text extraction for a presentation, and monitor progress and storage.
Master presentation fundamentals with best practices for layout and navigation. Apply the 10-20-30 rule, one font style, and simple animations to keep audiences focused on your story in Google Slides.
Learn to add slides in google presentations using slide menu or insert menu; duplicate, import slides, or use formatting toolbar to create a title and body layout with control m.
Import slides from another presentation using the import slides wizard, via insert or file menu. Choose from Google Docs presentations or uploads, select slides, and keep the original theme.
Explore slide layout options to structure content in your presentations, including title and body placeholders, two-column layouts, title-only slides, caption layouts, and blank canvases.
Learn to navigate and arrange slides by numbering in the navigation pane, and move slides with drag-and-drop, right-click, or slide menu commands to control your presentation flow.
Apply slide themes quickly by opening the theme dialog box and selecting a biz theme to style slides; templates offer predesigned themes, but uploaded slides may lose color or images.
Save changes automatically and track revision history with Google Docs. Learn save options like make a copy and download as, and basics like creating slides and applying a theme.
Learn to insert and format text boxes in Google Slides, including placeholders and layouts. Keep text large and simple, with font sizes around 30–50 points for effective slides.
Format text boxes in Google Docs using the formatting toolbar or format menu to adjust font type, size (no custom size), bold, italic, underline, color, alignment, and justification.
Learn to format text with bulleted and numbered lists in Google Slides, adjust indentation with tab, and switch list types. Note the limited customization compared with other presentation tools.
Create and resize text boxes in Google Docs and slides, align with snap-to guides, and customize background and border colors. Insert boxes, adjust fonts, and format lists.
Learn to create and customize shapes in Google Slides, including basic shapes, arrows, and callouts, with color, size, and rotation controls. Add text inside shapes and adjust arrow bend.
Learn to use the line tool in Google presentations to draw lines, arcs, curved lines, and polyline shapes, connect lines to shapes so they move together, and customize arrowhead styles.
Copy, paste, and arrange drawing objects in Google Docs, Sheets, and Slides using copy methods and the Web clipboard. Rename shapes and align them on the slide.
Align shapes to the left edges with snap to guides or by selecting all three and using align left, then group objects to move or center them on the slide.
Insert images via four options—local file, URL, Google image search, or Picasa Web album—while ensuring rights and sizes (PMG, JPEG or GIF, under 2000 px and 2 MB).
Learn to insert an image from a URL in Google Slides by copying the image URL from a public page and pasting it into the insert image dialog.
Learn two ways to set slide backgrounds in Google Slides: use the slide background dialog box to apply a color or image to all slides, or insert an image directly.
Insert videos into Google Presentations by linking a YouTube video or a published video via its web address, then resize and present from the current slide.
Insert a table in Google Slides, define rows and columns, and populate it with data such as car makes, models, and costs, then format for a clear comparison.
Learn to customize tables by selecting cells or rows, bold headers in Verdana, apply interior and exterior borders, and use dark gray line colors and blue fill to highlight content.
Place your insertion point in a table cell to insert or delete a row or column, then use the paint format tool to copy formatting and match text.
Resize column width and row height by dragging borders; columns can be narrower than text, but rows cannot. Design in PowerPoint and import as an image into Google presentations.
Animate slide content using the animations pane to add emphasis, then apply transitions like fade, slide from right or left, or flip, and preview the result.
Animate text and objects on your slide by selecting an element, adding animation, and choosing effects like appear, fly in, or zoom; set timing with on click or after previous.
Learn to animate slide elements in Google Slides by applying appear effects to images, controlling order and layering, and grouping objects for simultaneous animation using with previous or after previous.
Explore how to share and collaborate on a single Google presentation file, add speaker notes, review revision history, and download, print, or publish the slides.
Download your document in formats like png, jpeg, svg, ppta, pdf, and text, then share or distribute by making copies or notifying collaborators when a copy is created.
Explore Google Docs revision history to view and restore past versions. Access the file menu to preview edits, see editors, and revert changes without losing earlier versions.
Master print options for Google Slides, including print preview, layout choices, notes per slide, hide background, export to pdf, and set color, range, and copies.
By default, keep your presentation private; share it with editors or viewers via the share settings dialog from the file menu or share button, and set edit or view rights.
Collaborate with teammates to prepare and present a Google Slides deck, navigate slides with viewer controls, and use speaker notes and the timer to deliver a polished presentation.
Publish Google presentations to the web, share via links or embeds, and post to social media while controlling visibility, embed size, and automatic advancement.
Learn to create a new spreadsheet in Google Docs, explore the online interface, save and share work, and leverage collaboration features with charts and graphs to visualize data trends.
Explore the google spreadsheets interface by navigating the header, toolbars, and workspace; learn to open existing spreadsheets, rename documents, and manage sheets with the standard and formatting toolbars.
Open an existing spreadsheet from the document list pane on the Google Docs homepage and click it to open in a new tab or window. Begin editing the existing document.
Learn how to enter and select data in a new spreadsheet, including numeric, text, currency, and date values, and use the fill handle to copy data across cells.
Format data in Google Sheets by applying specific data types to cells, including currency, date, and text labels, via the formatting toolbar.
Edit and replace data in worksheets by typing directly, and copy, cut, and paste using multiple methods. Master drag-and-drop, the fill handle, and auto fit for efficient layout.
Learn to input and organize data in Google Sheets, create a monthly budget with labeled cells and headers, and apply formatting, borders, merge cells, and text color to clarify worksheets.
Create powerful formulas in Google Sheets using operators and cell references. Master the order of operations and how to copy formulas across a spreadsheet to automate calculations.
Explore how to use common functions in Google Sheets to analyze data, including sum, min, max, count, average, and product, with a budget spreadsheet example.
Explore conditional formatting and data validation in Google Sheets, applying rules to color-code negative values, enforce numeric inputs above zero, and provide helpful hover warnings for clean data entry.
Enhance spreadsheets by inserting images with the insert image wizard, using local uploads, URLs, Google images, or Picasso albums. Resize, place, and manage images using the image menu.
Enhance your spreadsheets by inserting drawings with the drawing wizard, adding shapes, text, and images to spruce up your data. Learn to format and resize drawings while preserving their integrity.
Create and customize forms in Google Sheets with the form wizard, add text, paragraph, and scale questions, mark required items, and publish or embed the live form for data collection.
Learn to enhance Google Sheets with gadgets using the add gadget wizard, set data ranges, axes, and legends for interactive charts.
Organize a Google spreadsheet by adding, renaming, reordering, and duplicating sheets with drag-and-drop and sheet tabs. Protect, hide, and manage collaboration with copy to, share, and edit rights.
Learn to freeze rows and columns to keep headers visible as you scroll, and use compact controls and full-screen view to optimize your spreadsheet display.
Sort data in Google Sheets using a to z or z to a, comparing sort sheet and sort range to preserve data integrity, and filter to display only Utah.
Create dynamic pivot table reports in Google Spreadsheets to interpret and organize data by columns, using drag-and-drop fields, automatic range selection, and filters for targeted views.
Learn to print and distribute Google Sheets by using the print settings to choose current sheet, all sheets, or a selection, convert to PDF via the browser print preview.
Download or export your spreadsheets in formats like csv, html, text, excel, OpenOffice, or pdf, and also make copies from the file menu to create duplicates.
Explore revision history in Google spreadsheets to view and restore earlier versions of your spreadsheet, track changes during collaboration, and access version history from the file menu.
Learn how Google Sheets shares a single document in real time, enabling collaboration with edit or view permissions and options to notify collaborators or export as PDF or Excel.
Define and manage notification rules in Google Sheets to receive alerts on changes, whether across the whole sheet or specific ranges, with daily or immediate options.
Publish Google spreadsheets to the web with a shareable URL, choose all or individual sheets, customize the view, stop publishing anytime, and enjoy real-time collaboration and cloud access.
Welcome to Getting Started with Google Office: Docs, Sheets, Slides from LearnSmart.
Master Strategies for Effectively Utilizing the Google Drive Applications
At the end of this course, you will be able to confidently create, edit, and share presentations, documents, and spreadsheets!
This course is a bundle of the following LearnSmart courses, and includes comprehensive information for the following topics:
Recommendations:
Learn from others! Here are some reviews from the participants enrolled in this course (Click on reviews to see full list of reviews)