Master MS Word Excel PowerPoint and Google Doc Google Sheets

Name: Master MS Word Excel PowerPoint and Google Doc Google Sheets
Rating: 4.1 (40 reviews)

Learn MS Word Excel PowerPoint with Google Docs/Sheets for job readiness, business tasks, and efficient digital workflow

Created bySustoab Soren

Last updated 11/2025

English

English [Auto],

What you'll learn

Master core and advanced features of MS Word for reports, formatting, editing, and professional document creation
Build strong MS Excel skills: formulas, functions, data entry, charts, tables, and data analysis techniques
Design modern, business-ready presentations using MS PowerPoint
Use Google Docs for online documentation, formatting, collaboration, comments, and real-time editing
Analyze and organize data in Google Sheets using formulas, filters, charts, and spreadsheet automation
Apply professional formatting and layout techniques for resumes, letters, business reports, and forms
Improve workplace efficiency with time-saving tools, shortcuts, templates, and productivity workflows
Manage files, cloud storage, sharing permissions, and online collaboration
Perform real office tasks including data entry, reporting, documentation, and presentation design
Build confidence in using both Microsoft Office and Google Workspace for daily professional use

Course content

5 sections • 29 lectures • 6h 6m total length

Introduction6:46
Master skills across Word, Excel, PowerPoint, Google Docs, and Google Sheets. Learn basics to real-world tasks, Word formatting, mailmerge, Excel formulas and pivot tables, PowerPoint design, and Google collaboration.
Introduction to Word9:46
Explore the Microsoft Word interface, learn to create, open, and save documents, and boost productivity with essential keyboard shortcuts and the quick access toolbar.
Text and Paragraph Formatting11:33
Learn to format text and paragraphs in Microsoft Word using font formatting, line spacing, alignments, bullets and numbering, borders, and shading for clean, professional documents.
Page Layout and Design8:53
Learn to configure page setups in Word, adjusting margins, orientations, and columns to create professional layouts. Apply page and section breaks to control pagination and formatting.
Working with Tables and Objects15:29
Learn to insert and format tables in Microsoft Word, and add image shapes, SmartArt, and charts to create professional, visually engaging documents.
Editing and Proofing Tools9:35
Master word processing efficiency with editing and proofing tools, learn find and replace, spelling and grammar checks, word counts, and track changes and comments for collaborative, polished documents.
Styles, Themes, and Templates8:30
Create and apply custom styles, use built-in themes, and design reusable templates in Microsoft Word to keep documents consistent, professional, and visually appealing.
Advanced Document Automation18:26
Harness advanced document automation with mail merge, personalized letters, and CV creation from Excel data; build professional reports with tables of contents, indexes, citations, footnotes, endnotes, and protection.

Introduction to Excel10:45
Explore how Excel organizes workbooks and worksheets, enters and formats data, and uses cell referencing to drive calculations. Learn how relative, absolute, and mixed references behave when copying formulas.
Basic Formulas and Functions7:29
Master essential Excel formulas such as sum, average, count, max, and min, and apply autofill, flashfill, and number formatting to analyze sales data.
Data Management10:46
Learn essential Excel data management skills, including sorting, filtering, data validations with drop-down lists, and cleaning techniques like removing duplicates and error checking.
Intermediate Formulas15:45
Master Excel intermediate formulas by applying logical functions such as if and or, text functions such as left, right, and mid, trim, and concat, and date and time functions.
Lookup and Reference Functions10:33
Master essential excel lookup, vertical and horizontal references, including vlookup, index, match, and xlookup, with practical examples.
Charts and Data Visualization8:58
Explore creating and formatting bar, line, and pie charts in Excel, add data labels and trend lines, and visualize monthly sales data for clear insights.
Pivot Tables and Dashboards17:17
Turn raw data into flexible reports using pivot tables and pivot charts, group dates by month and year, and use slicers and timelines to build an interactive dashboard of summaries.
Advanced Excel Tools21:01
Explore excel tools, power query for cleaning, and what-if analysis with goal seek and scenario manager, protect sheets, and build pivot charts and dashboards in Google Sheets with slicers.

Introduction to PowerPoint8:31
Open PowerPoint and build a clean slide deck by using slides, layouts, placeholders, themes, templates, and design ideas to create visually consistent presentations.
Working with Content16:32
Learn to create visually engaging PowerPoint slides by inserting and formatting text, images, tables, icons, charts, and smart graphics to clearly communicate your message.
Transitions and Animations9:50
Apply slide transitions and object-based animations in PowerPoint, preview effects, and fine-tune timings, durations, and order to create engaging, professional slide flow.
Interactive and Professional Presentations16:01
Master PowerPoint by turning slides into interactive, hyperlink-rich presentations with action buttons, multimedia, and embedded audio and video. Refine timing, presenter view, and export options for professional sharing.

Getting Started with Google Docs8:52
Learn the basics of Google Docs, including cloud storage with Google Drive, autosave, offline work, revision history, and how to create, save, and organize your documents and folders.
Document Formatting and Layout12:50
Learn to format text, adjust paragraph spacing, and insert tables and images in Google Docs. Fine-tune page layout settings to create professional, clean, visually appealing documents.
Collaboration Tools11:19
Explore Google Docs collaboration tools, including comments, suggesting mode, and real-time edits, while managing sharing permissions for viewers, commenters, and editors.
Productivity Tools12:22
Harness voice typing, extensions, and exports in Google Docs to draft faster and deliver professional documents, then collaborate in real time with sharing, commenting, and editing permissions.

Introduction to Google Sheets25:57
Explore the Google Sheets interface, enter and format data, and perform simple calculations, then collaborate in real time with sharing, comments, and version history.
Basic Formulas and Functions (2)7:27
Learn essential Google Sheets formulas such as sum, average, count, max, and min. Apply autofill and number formatting, including currency, to calculate total sales from quantity and unit price.
Data Organization and Validation11:57
Master data organization and validation in Google Sheets by sorting, filtering, applying conditional formatting, and creating drop-down lists and numeric restrictions to keep inventories clean and accurate.
Charts and Reporting10:19
Create and customize Google Sheets charts, including line charts, with automatic updates as data changes. Learn to link charts to Google Docs and Google Slides for dynamic reports.
File Management23:22
Import CSV and Excel files into Google Sheets, publish to the web, manage versions and permissions, and build online attendance and shared expense trackers with auto calculations.

Requirements

No Experience Required

Description

Master the essential digital skills needed in every modern workplace with this complete training on MS Word, MS Excel, MS PowerPoint, Google Docs, and Google Sheets. This all-in-one Microsoft Office Masterclass and Google Workspace Training takes you from beginner to advanced with clear, practical, real-world lessons.

Whether you need strong office productivity skills, document formatting, spreadsheet data analysis, presentation design, or professional documentation, this course will guide you step by step using real business examples. You will learn how to create polished documents, analyze and visualize data, prepare business reports, build powerful presentations, and manage workflows efficiently using both Microsoft Office and Google Workspace tools.

Designed for students, job seekers, office professionals, freelancers, business owners, and anyone needing practical data entry & reporting and business productivity tools, this course covers everything required to work confidently in any professional environment.

What You Will Learn

Master MS Word tools for professional document creation, editing, layout, and formatting
Build strong MS Excel skills for data entry, formulas, functions, charts, tables, and data analysis
Create clean and modern presentations using MS PowerPoint with smart design principles
Work confidently with Google Docs: formatting, collaboration, document styling, and workflows
Analyze data and build smart spreadsheets in Google Sheets using formulas, charts, and automation
Improve overall office productivity using both Microsoft Office and Google Workspace
Learn real-world business tasks: reporting, documentation, presentations, and productivity workflows
Understand file management, sharing, cloud storage, and online collaboration
Apply professional formatting techniques for resumes, reports, and business documentation
Use shortcuts, automation basics, templates, and productivity hacks for daily work

Who This Course Is For

Anyone wanting to learn Word, Excel, and PowerPoint and Google Workspace

After Completing the Course, You Will Be Able To

Create professional documents, reports, resumes, and forms with MS Word and Google Docs
Build, analyze, and visualize data using spreadsheets in MS Excel and Google Sheets
Design polished and engaging presentations using MS PowerPoint
Perform real workplace tasks with accuracy, confidence, and speed
Use both Microsoft Office and Google Workspace for business communication and collaboration
Apply productivity techniques for faster, more efficient workflows
Handle data entry, reporting, and documentation tasks for office and business roles
Work confidently in corporate, academic, or freelance environments

This course is designed to give you real, usable skills that instantly improve your productivity, confidence, and career opportunities. By mastering MS Word, MS Excel, MS PowerPoint, Google Docs, and Google Sheets, you will be prepared for any job that requires strong office and digital communication skills. Enroll now and build the professional foundation you need to succeed in today’s competitive workplace.

Who this course is for:

Anyone who want a complete introduction to Microsoft Office and Google Workspace

Master MS Word Excel PowerPoint and Google Doc Google Sheets

What you'll learn

Explore related topics

Course content

Word8 lectures • 1hr 29min

Excel8 lectures • 1hr 43min

PowerPoint4 lectures • 51min

Google Docs4 lectures • 45min

Google Sheet5 lectures • 1hr 19min

Requirements

Description

Who this course is for: