Microsoft Office And Google Workspace Masterclass

Microsoft Word Excel PowerPoint and Google Docs Sheets Slides Ideal for Beginners Professionals Students Job Seekers

What you'll learn

How to use Microsoft Word and Google Docs to create and format professional documents

How to organize data, use formulas, and create charts in Excel and Google Sheets

How to build clean, engaging presentations in PowerPoint and Google Slides

Best practices for formatting, layout, templates, and sharing files

Key differences and similarities between Microsoft Office and Google Workspace tools

How to collaborate in real time using cloud-based features

How to work efficiently whether you're online, offline, or on the go

Requirements

Microsoft Word, Excel, PowerPoint

Google Account

Description

Microsoft Word, Excel, PowerPoint and Google Docs, Sheets, Slides — master the essential digital tools used in modern workplaces, schools, and remote environments with this all-in-one course designed for beginners, professionals, students, and job seekers.In today’s competitive world, being proficient in both Microsoft Office and Google Workspace is more than a helpful skill — it’s a necessity. This course gives you practical, hands-on training in creating professional documents, organized spreadsheets, and engaging presentations using both platforms.Whether you're starting from scratch or looking to improve your existing skills, this course will help you become confident and efficient in handling everyday office tasks.What You’ll LearnHow to create, format, and edit documents in Microsoft Word and Google DocsHow to use spreadsheets, formulas, and charts in Microsoft Excel and Google SheetsHow to design professional presentations in Microsoft PowerPoint and Google SlidesKey similarities and differences between Microsoft Office and Google WorkspaceHow to collaborate in real-time using Google’s cloud-based toolsTips for boosting productivity, organizing your work, and sharing files securelyWho This Course Is ForAnyone who wants to work smarter and more efficiently using today’s top office toolsTools CoveredMicrosoft Word, Excel, PowerPointGoogle Docs, Sheets, SlidesNo Prior Experience Needed. This course is beginner-friendly and guides you through each tool with clear explanations, real-world examples, and downloadable practice files. You’ll gain practical skills that you can apply immediately in school, the workplace, or your personal projects.By the end of the course, you’ll be confident using both Microsoft Office and Google Workspace — and ready to handle any office task with ease.

Overview

Section 1: Microsoft Office and Google Workspace

Lecture 1 Introduction

Lecture 2 Introduction to Word interface

Lecture 3 Creating, saving, and opening documents

Lecture 4 Basic text formatting font, size, color, alignment

Lecture 5 Paragraph formatting line spacing, indentation

Lecture 6 Bullets and numbering

Lecture 7 Page setup margins, orientation, size

Lecture 8 Headers, footers, and page numbers

Lecture 9 Inserting and formatting tables

Lecture 10 Adding and formatting images

Lecture 11 Using shapes and SmartArt

Lecture 12 Styles and themes

Lecture 13 Templates for documents

Lecture 14 Track changes and comments

Lecture 15 Spell check and grammar check

Lecture 16 Mail merge

Lecture 17 Table of contents and references

Lecture 18 Footnotes and endnotes

Lecture 19 Hyperlinks and bookmarks

Lecture 20 Collaboration and sharing

Lecture 21 AI-assisted grammar and content generation

Lecture 22 Introduction to Excel interface

Lecture 23 Creating, saving, and opening spreadsheets

Lecture 24 Basic cell formatting font, color, alignment

Lecture 25 Row and column adjustments

Lecture 26 Simple formulas SUM, AVERAGE, COUNT

Lecture 27 Intermediate formulas IF, AND, OR

Lecture 28 Lookup formulas VLOOKUP, HLOOKUP, INDEX, MATCH

Lecture 29 Conditional formatting

Lecture 30 Sorting and filtering data

Lecture 31 Creating tables

Lecture 32 Charts column, bar, line, pie

Lecture 33 PivotTables and PivotCharts

Lecture 34 Data validation

Lecture 35 Protecting sheets and workbooks

Lecture 36 Macros and automation

Lecture 37 Collaboration and sharing

Lecture 38 AI-assisted formulas and insights

Lecture 39 Using AI to analyze data

Lecture 40 Dashboard creation

Lecture 41 Practical Excel project

Lecture 42 Introduction to PowerPoint interface

Lecture 43 Creating and saving presentations

Lecture 44 Slide layouts and themes

Lecture 45 Adding and formatting text

Lecture 46 Adding and formatting images

Lecture 47 Adding shapes and SmartArt

Lecture 48 Slide transitions

Lecture 49 Animations for text and objects

Lecture 50 Multimedia integration (audiovideo)

Lecture 51 Slide master and templates

Lecture 52 Collaboration and sharing presentations

Lecture 53 AI-assisted slide design

Lecture 54 AI-generated content for slides

Lecture 55 Creating a complete presentation using AI

Lecture 56 Introduction to Google Docs

Lecture 57 Creating and saving documents

Lecture 58 Basic text formatting and paragraph settings

Lecture 59 Inserting tables and images

Lecture 60 Collaboration and sharing

Lecture 61 Version history and suggestions

Lecture 62 AI-assisted grammar and summaries

Lecture 63 Introduction to Google Sheets

Lecture 64 Creating and saving spreadsheets

Lecture 65 Basic formulas SUM, AVERAGE, COUNT

Lecture 66 Sorting, filtering, and conditional formatting

Lecture 67 Charts and graphs

Lecture 68 Collaboration and sharing

Lecture 69 Using AI for formulas and insights

Lecture 70 Introduction to Google Slides

Lecture 71 Creating slides and applying themes

Lecture 72 Adding text, images, and shapes

Lecture 73 Slide transitions and basic animations

Lecture 74 Collaboration and sharing

Lecture 75 AI-assisted slide suggestions

Anyone who wants to gain confidence using both Microsoft and Google platforms