Microsoft Office and Google Workspace Masterclass

Explore Microsoft Word, Excel, PowerPoint, and Google Docs, Sheets, and Slides to master document formatting, data analysis, presentations, and real-time collaboration with AI-powered productivity tools.

Explore the Microsoft Word interface, including the ribbon, tabs, and quick access toolbar. Open a blank document, format text, and use the status toolbar to track words.

Create documents from templates or blank pages, like resumes and letters. Save with meaningful names, open existing files, and use ctrl+s to guard your progress.

Master basic text formatting in Word by adjusting font, size, color, and alignment. Apply fonts, sizes, colors, hyperlinks, and left, center, right, or justified alignment for clear documents.

Learn to adjust line spacing and indentation in Word with left indent, first line indent, and hanging indents for clean, professional documents.

Master bullets and numbering in Microsoft Word to organize content with unordered and ordered lists, customize styles, and create multi-level outlines for clear, professional documents.

Learn to set margins, orientation, and paper size in Word for polished print and pdf results. Apply presets, adjust custom margins, choose portrait or landscape, and select letter or A4.

Learn to add headers and footers in Word, customize with logos and page numbers, adjust formatting, start numbering on a specific page, and create consistent, professional documents.

Learn to insert and format tables in Microsoft Word, using grid selection, headers, borders, alignment, and table design and layout options.

Insert and format images in Microsoft Word using the insert tab, pictures, and text wrapping options. Resize with corner handles, apply brightness, borders, shadows, and crop to create engaging documents.

Learn to enhance documents in Word by inserting shapes and SmartArt to create diagrams, flowcharts, and organization charts, with tips on fills, outlines, colors, and 3D effects.

Explore styles and themes in Microsoft Word to create professional, consistent documents with headings automatically formatted and colors and fonts updated across the project.

Explore document templates in Microsoft Word to save time and maintain consistency. Customize templates by replacing placeholders, applying built-in styles, and creating professional reports, letters, and resumes.

Explore track changes and comments in Microsoft Word to reveal edits, preserve original text, and streamline collaboration through suggested edits, color-coded changes, and in-text feedback.

Polish your documents by using spell check and grammar check in Microsoft Word, catching typos with red wave underlines and grammar issues with blue underlines for emails, resumes, and reports.

Generate personalized letters, emails, labels, and certificates from a single template and a data source using mail merge in Word.

Learn to create and update a dynamic, clickable table of contents with heading styles to improve navigation in long documents, and manage citations with APA, MLA, or Chicago styles.

Insert and manage footnotes and endnotes in Word to add references and extra information at page bottoms or document ends, keeping your work clean and credible.

Learn to add hyperlinks and bookmarks in Word to navigate documents, link to websites, jump to sections or headings, and create interactive table of contents.

Learn how to share Word documents, invite collaborators via email or link, set edit or view permissions, and use real-time collaboration, comments, and track changes to streamline team workflows.

Explore AI-assisted grammar and content generation in Microsoft Word, using AI editors and Copilot to write faster, improve clarity, and produce polished, professional documents.

Explore the Excel interface, including the titles bar, ribbons, and formula bar. Navigate the worksheet grids, enter data, and practice basics like sums to see how cells and formulas work.

Create, save, and open spreadsheets in Excel with blank workbooks or templates, save with meaningful names, and access recent files or browse locations.

Explore basic Excel formatting by applying fonts, font sizes, bold and color to headers and data, add background fills, and adjust alignment to improve readability and emphasis.

Adjust row heights and column widths in Excel to keep data clean and readable. Use autofit and wrap text, plus home tab formats to set precise dimensions and alignment.

Explore sum, average, and count formulas in Excel to quickly analyze data using ranges like monthly sales, and learn to calculate totals, averages, and counts.

Master Excel intermediate formulas by using if, and, or to automate pass/fail decisions from student scores and attendance, including nested scenarios for grading and reporting.

Explore vlookup, hlookup, index and match to quickly pull salaries and other data from employee records or product lists, and see why index and match offer more flexibility.

Apply conditional formatting in Excel to highlight data automatically, using green for above 80, yellow for 60–79, red for below 60, and data bars for quick insights.

Sort and filter data in Excel to analyze sales by category and region, using ascending/descending orders and multi-level sorting, then filter by furniture or numeric criteria to reveal key insights.

Learn to create tables in Excel to organize data with automatic formatting, filters, and dynamic references, enabling quick search, summaries, and analysis as data expands.

Explore column, bar, line, and pie charts in Excel to visualize trends, compare sales and expenses, and show proportions with data labels.

Pivot tables and pivot charts in Excel let you summarize, analyze, and visualize large data sets by dragging fields to rows, columns, and values to reveal insights.

Master data validation in Excel to restrict entries with numbers, dates, and drop-down lists, provide input messages and error alerts, and standardize data for reporting in human resources and sales.

Protect sheets and workbooks in Excel to secure data and formulas while enabling collaboration. Lock cells, set protections, and safeguard workbook structure with passwords to maintain data integrity.

Master macros and automations in Excel to automatically record formatting tasks, apply currency formatting, conditional highlights, and generate reports with VBA for faster, more accurate data processing.

Explore how Excel enables teamwork through sharing and real-time co-authoring on cloud workbooks saved to OneDrive. Use comments, notes, and version histories to track edits and keep the team aligned.

Explore how Excel's AI-assisted formulas automate calculations and reveal insights from data, using natural language queries, data analysis tools, and forecasting to boost efficiency.

Discover how Excel's AI-powered Analyze Data feature summarizes data, detects patterns, and generates predictions from a retail dataset, enabling you to interpret insights and build charts and pivot tables.

Analyze real sales data by cleaning duplicates, calculating total revenue and average prices, and using filters, pivot tables, and charts to present a professional business report.

Explore the PowerPoint interface by navigating the ribbon, choosing templates or blank presentations, and using slide thumbnails, the slide workspace, notes, and zoom across normal, slide sorter, and reading views.

Create a new PowerPoint presentation from scratch, choosing blank or template designs, then save in multiple formats with meaningful names.

Master slide layouts and themes in PowerPoint to structure content and keep visuals consistent. Apply layouts such as title slides and title-and-content, then choose themes to unify fonts and colors.

Master adding and formatting text in PowerPoint using text boxes and placeholders, then apply fonts, sizes, colors, alignment, and bullets to create polished, readable slides with text effects.

Learn how to insert images from devices, stock images, and online pictures in PowerPoint, then format with borders, shadows, brightness, color, and artistic effects to enhance slide clarity and impact.

Learn to add shapes and SmartArt in PowerPoint to create engaging slides, organize information with diagrams and process flows, apply colors and SmartArt styles, and animate SmartArt for compelling presentations.

Learn to apply and customize slide transitions in PowerPoint, using morph transitions and other effects, adjust timings, and apply to multiple slides for a professional, smooth presentation.

Master animations for text and objects in PowerPoint, using entrance, emphasis, and exit effects with timing, delays, directions, and triggers to create dynamic, engaging slides.

Learn how to add and manage audio and video in PowerPoint, including background music, voiceover, video trimming, and playback options to create engaging, professional presentations.

Master slide masters and templates in PowerPoint to set fonts, colors, backgrounds, and a logo once, so every slide stays consistent and professional.

Collaborate in real-time on PowerPoint by sharing on OneDrive, enabling simultaneous editing and up-to-date versions, while comments and notes streamline feedback and teamwork.

Learn to use AI assisted slide design in PowerPoint with designer and Copilot to generate layouts and templates for professional slides quickly. Save hours and focus on refining your message.

Learn how AI-generated content speeds up creating engaging PowerPoint slides with text, images, and design ideas using Copilot, Designer, ChatGPT, DALL-E, and Canva AI.

Create AI-powered PowerPoint decks in minutes with Copilot and Microsoft 365, generating complete 5-slide presentations with layouts and visuals you can customize with data, color, logos, and charts.

Explore Google Docs, an online tool to create, edit, and store documents with auto-save to Google Drive. Collaborate in real time, access from any device, and use shared features.

Create and save documents in Google Docs, with automatic cloud saves to Google Drive, and rename files as you organize them into folders.

Master basic text formatting and paragraph settings in Google Docs, including bold, italics, underline, fonts, colors, highlights, alignment, line spacing, and indentation.

inserting tables and images in google docs, learn to create, resize, merge cells, adjust borders and colors, and insert images from multiple sources for clear, engaging documents.

Explore Google Docs collaboration and sharing to work in real time with teammates, control access with viewers, commenters, and editors, and share via links for faster, organized teamwork.

Master version history to track, review, and restore past work, and use suggestions to propose edits without overwriting teammates, keeping collaboration transparent and on the same page.

Discover how Google Docs' AI-assisted grammar suggestions and summary tools enhance writing clarity, readability, and efficiency by real-time grammar checks and quick outlines for long documents.

Explore Google Sheets, a cloud-based spreadsheet tool in Google Workspace, online and collaboration-focused. Discover cells, rows, real-time sharing, and cross-device access for budgeting and group projects.

Learn how to create and save spreadsheets in Google Sheets, rename untitled spreadsheets, auto-save in real time to Google Drive, and export to Excel or PDF for offline use.

Learn to use sum, average, and count formulas in Google Sheets to quickly calculate totals, average prices, and non-empty entries in a sales dataset.

Sort data to reveal top performers, filter to focus on specific subsets, and apply conditional formatting to visually highlight key sales figures in Google Sheets.

Explore how charts and graphs in Google Sheets transform monthly sales data into clear insights, using column, line, combo, and pie charts, with formatting and labeling for clarity.

Learn how Google Sheets enables real-time collaboration with sharing controls, permissions (viewers, commenters, editors), and in-app comments to streamline teamwork from anywhere.

Master using AI in Google Sheets to generate formulas and extract insights from data. See how this approach saves time, reduces errors, and makes spreadsheet work smarter.

Discover how Google Slides lets you create professional, cloud-based presentations with real-time collaboration, seamless integration with Docs, Sheets, and Drive, and a simple, beginner-friendly interface.

Create new slides and apply themes in Google Slides to establish a consistent, professional presentation. Use layouts, themes, and keyboard shortcuts to streamline design and unify fonts, colors, and backgrounds.

Master the basics of adding text, images, and shapes in Google Slides, including text boxes, image insertion from multiple sources, and customizable fill and border styles for engaging presentations.

Learn to apply slide transitions and basic animations in Google Slides to make presentations dynamic, using fades, slide from right, flips, and start options like on click or after previous.

Explore how Google Slides enables real-time collaboration with granular sharing controls, including viewer, commenter, and editor permissions, colored cursors, and comments to streamline teamwork.

Discover AI-assisted slide suggestions in Google Slides that auto-generate slides, layouts, content, and images from topics like marketing trends 2025, aiding faster, polished presentations.