Microsoft Office Masterclass 2025 — From Beginner To Pro

Master Microsoft Word, PowerPoint & Excel: From absolute beginner to confident pro in Microsoft Office.

What you'll learn

Create professional-looking documents in Microsoft Word

Format text, paragraphs, lists, and pages like a pro

Insert tables, charts, images, shapes, icons, and SmartArt

Apply themes, borders, watermarks, and page layouts

Design visually stunning PowerPoint presentations

Work with slides, layouts, animations, and transitions

Insert and edit videos, audio, and images in PowerPoint

Use drawing tools, annotations, and presentation tricks

Create and format spreadsheets in Excel

Work with rows, columns, cells, and ranges

Apply formulas for calculations and automation

Master essential Excel functions (SUM, IF, VLOOKUP, etc.)

Create and customize charts for visual data analysis

Use PivotTables for advanced reporting

Protect, save, and export documents, slides, and spreadsheets

And much more…

Requirements

A computer with internet access

Microsoft Office (Word, PowerPoint, Excel) — any recent version works

Willingness to practice along with the lessons

No prior experience required — we start from scratch

Description

The Microsoft Office Masterclass is your all-in-one training to become a true master of Word, PowerPoint, and Excel — the three most essential tools in today’s professional world.Whether you’re a student, entrepreneur, office worker, or career professional, Microsoft Office is the universal language of productivity. This course is designed to take you from zero to expert, covering everything from the absolute basics to advanced, time-saving features that even many experienced users don’t know.You’ll begin with Microsoft Word, learning to create beautifully formatted documents, use professional layouts, work with images, shapes, charts, tables, and apply design principles to make your work stand out.Next, in Microsoft PowerPoint, you’ll discover how to design visually engaging presentations, work with text and multimedia, animate objects, apply transitions, and master slide organization so your audience stays hooked from start to finish.Then, you’ll dive into Microsoft Excel, where you’ll build skills to manage and analyze data, create charts, use formulas, work with PivotTables, and apply essential functions for real-world problem-solving.This masterclass is hands-on, practical, and easy to follow — with real examples and clear explanations for every feature. You’ll not only learn how to use each tool, but when and why to use it in real projects.By the end of this course, you’ll have the confidence to create professional documents, captivating presentations, and powerful spreadsheets — setting you apart in your studies, work, or business.If you want one course that gives you complete mastery of Microsoft Office and the skills to shine in any professional environment, this is it.

Overview

Section 1: Microsoft Word: Getting Started

Lecture 1 Welcome & Course Overview

Lecture 2 How to Install Microsoft Word for Free

Lecture 3 Switching Between Light & Dark Modes

Lecture 4 Your First Document: A Quick Start Guide

Lecture 5 Mastering the Word Interface in Minutes

Lecture 6 Understanding the Bottom Bar & Status Bar

Section 2: Microsoft Word: Formatting Text Like a Pro

Lecture 7 Fonts & Text Formatting Essentials

Lecture 8 Text Styles, Effects & Enhancements

Lecture 9 Quickly Change Case in Word

Lecture 10 Reset Formatting: Clean Up Your Document Fast

Section 3: Microsoft Word: Paragraphs & Lists Made Easy

Lecture 11 Creating Bulleted & Numbered Lists

Lecture 12 Aligning Text & Changing Text Direction

Lecture 13 Justify Text & Improve Document Readability

Lecture 14 Line Spacing, Paragraph Borders & Shading

Section 4: Microsoft Word: Clipboard Tools for Faster Editing

Lecture 15 Cut, Copy, Paste — The Right Way

Lecture 16 Using the Format Painter Tool Efficiently

Section 5: Microsoft Word: Editing & Proofreading Tools

Lecture 17 Finding Words & Phrases in Seconds

Lecture 18 Replacing Words Like a Pro

Section 6: Microsoft Word: Page Layout Mastery

Lecture 19 Introduction to the Layout Tab

Lecture 20 Adjusting Margins for Any Document

Lecture 21 Changing Page Size & Orientation

Lecture 22 Working with Columns in Word

Lecture 23 Inserting Breaks (Page, Column, etc.)

Lecture 24 Adding Line Numbers to Your Pages

Section 7: Microsoft Word: Insert Tab Power Tools

Lecture 25 Creating Tables in Microsoft Word

Lecture 26 Inserting & Editing Pictures Like a Pro

Lecture 27 Adding Shapes & Custom Graphics

Lecture 28 Using Icons to Elevate Your Design

Lecture 29 Working with 3D Models in Word

Lecture 30 SmartArt for Stunning Visuals

Lecture 31 Inserting Charts for Data Presentation

Lecture 32 Taking & Adding Screenshots Quickly

Section 8: Microsoft Word: Document Design Essentials

Lecture 33 Applying Themes for a Professional Look

Lecture 34 Changing the Background Color

Lecture 35 Adding Borders Around Pages

Lecture 36 Watermarks: Add Draft or Confidential Marks

Section 9: Microsoft Word: Drawing Tools in Word

Lecture 37 Introduction to Drawing in Word

Lecture 38 Using Pens for Notes & Annotations

Lecture 39 Freehand Drawing with Pencil Tool

Lecture 40 Highlighting Text & Areas

Lecture 41 Using the Ruler for Precise Drawing

Lecture 42 Selection Tools: Lasso & More

Lecture 43 Formatting the Drawing Canvas Background

Section 10: Microsoft Word: Mathematics & Special Symbols

Lecture 44 Working with Equations in Word

Lecture 45 Inserting Currency Symbols

Lecture 46 Plus-Minus & Special Math Signs

Lecture 47 Not Equal To Symbol

Lecture 48 Copyright, Registered & Trademark Symbols

Lecture 49 Greater Than & Less Than Symbols

Lecture 50 Multiplication & Division Signs

Lecture 51 Inserting the Micro Sign

Lecture 52 Greek Letters (Alpha, Beta, etc.)

Lecture 53 Inserting the Ohm Sign

Lecture 54 Inserting the Sigma Sign

Lecture 55 Umlaut Letters (ä, ö, ü, etc.)

Lecture 56 Creating Complex Equations in Word

Section 11: Microsoft Word: Pro Tips for Word Mastery

Lecture 57 Using the Ruler for Layout Precision

Lecture 58 Sharing & Collaborating on Documents

Section 12: Microsoft Word: Saving & Exporting Your Work

Lecture 59 Saving Documents in Microsoft Word

Lecture 60 Exporting as DOCX

Lecture 61 Exporting as PDF for Easy Sharing

Section 13: Microsoft PowerPoint: Mastering the Basics

Lecture 62 Welcome to Microsoft PowerPoint

Lecture 63 How to Install PowerPoint for Free

Lecture 64 PowerPoint First Look: The Interface Explained

Lecture 65 Switch Between Light & Dark Modes

Lecture 66 Your First Presentation: Let’s Create It Together

Lecture 67 A Beginner’s Guide to PowerPoint Features

Section 14: Microsoft PowerPoint: Slides Made Simple

Lecture 68 Add New Slides: Build Your Story

Lecture 69 Slide Types Explained: Choose the Right Layout

Lecture 70 Organize & Manage Slides Like a Pro

Section 15: Microsoft PowerPoint: Text & Fonts

Lecture 71 Text Boxes: Add & Format Text Anywhere

Lecture 72 Fonts: Families, Sizes & Styling Tips

Lecture 73 Text Formatting for Clean Designs

Lecture 74 Change Colors & Backgrounds for Text

Lecture 75 Clear All Formatting Fast

Section 16: Microsoft PowerPoint: Paragraphs & Lists

Lecture 76 Align Text Perfectly on Your Slides

Lecture 77 Create Bullet & Numbered Lists That Pop

Lecture 78 Adjust Line Spacing & Text Direction

Lecture 79 Rotate Text & Convert to SmartArt

Section 17: Microsoft PowerPoint: Clipboard Tools

Lecture 80 Cut, Copy & Paste Like a Power User

Lecture 81 Format Painter: Style Faster

Section 18: Microsoft PowerPoint: Editing Essentials

Lecture 82 Find Anything in Seconds

Lecture 83 Replace Text Across Slides

Section 19: Microsoft PowerPoint: Adding Visuals: Images, Shapes & More

Lecture 84 Insert Tab: Your Gateway to Visual Content

Lecture 85 Create Beautiful Tables in PowerPoint

Lecture 86 Add & Edit Pictures Like a Designer

Lecture 87 Draw Shapes to Enhance Your Slides

Lecture 88 Use Icons for Modern, Clean Design

Lecture 89 Add Stunning 3D Models

Lecture 90 Charts: Visualize Your Data

Lecture 91 Insert & Edit Videos with Ease

Lecture 92 Add Audio Tracks to Your Slides

Section 20: Microsoft PowerPoint: Animations & Transitions

Lecture 93 Intro to Animations: Bring Slides to Life

Lecture 94 Customize Animation Settings for Impact

Lecture 95 Transitions vs Animations: What’s the Difference?

Lecture 96 Transitions: Smoothly Move Between Slides

Section 21: Microsoft PowerPoint: Drawing Tools for Creative Touches

Lecture 97 Explore the Draw Tab

Lecture 98 Use Pens for Notes & Highlights

Lecture 99 Draw with the Pencil Tool

Lecture 100 Highlight Text for Emphasis

Lecture 101 Erase Drawing Mistakes Easily

Lecture 102 Selection Tools for Editing Drawings

Lecture 103 Ruler Tool: Draw Straight Lines Perfectly

Section 22: Microsoft PowerPoint: Symbols & Math Tools

Lecture 104 Insert Currency Symbols ($, €, £)

Lecture 105 Work with Special Symbols in PowerPoint

Lecture 106 Insert Equations for Professional Documents

Section 23: Microsoft PowerPoint: Save & Export Like a Pro

Lecture 107 Save Your Presentation Properly

Lecture 108 Export as PPTX (Editable Format)

Lecture 109 Export as PDF (Share Anywhere)

Lecture 110 Export as PPSX (Slideshow Format)

Section 24: Microsoft PowerPoint: Deliver with Confidence

Lecture 111 Introduction to Presentation Mode

Lecture 112 Move Between Slides During a Presentation

Lecture 113 Use the Laser Pointer for Emphasis

Lecture 114 Pen, Highlighter & Eraser During Presentations

Lecture 115 Zoom In & Out During Presentations Like a Pro

Lecture 116 Use Black & White Screens to Control Audience Focus

Section 25: Microsoft Excel: Getting Started

Lecture 117 Introduction to Microsoft Excel

Lecture 118 Installing Microsoft Excel (Free Options)

Lecture 119 First Look: Navigating the Excel Interface

Lecture 120 Switching Color Modes in Excel

Lecture 121 Creating Your First Spreadsheet

Lecture 122 Exploring the Bottom Bar in Excel

Lecture 123 Getting Started with Excel Tools

Lecture 124 Entering and Managing Data in Excel

Section 26: Microsoft Excel: Formatting & Styling Your Data

Lecture 125 Overview of Excel’s Font Tools

Lecture 126 Selecting Cells Like a Pro

Lecture 127 Changing Font Family & Size

Lecture 128 Formatting Text in Excel

Lecture 129 Adding Borders to Your Data

Lecture 130 Using Text & Background Colors

Section 27: Microsoft Excel: Aligning, Styling & Organizing Content

Lecture 131 Intro to Alignment Tools

Lecture 132 Horizontal & Vertical Alignment Explained

Lecture 133 Styling Selections for Impact

Lecture 134 Formatting as a Table

Section 28: Microsoft Excel: Working with Cells & Data

Lecture 135 Formatting Cells Like a Pro

Lecture 136 Deleting Cells in Excel

Lecture 137 Inserting Cells with Ease

Lecture 138 Cut, Copy, Paste Essentials

Lecture 139 Using Format Painter for Quick Styling

Section 29: Microsoft Excel: Inserting Visual Elements

Lecture 140 Adding Pictures to Your Spreadsheet

Lecture 141 Drawing Shapes in Excel

Lecture 142 Using Icons for Visual Appeal

Lecture 143 Inserting 3D Models

Lecture 144 Creating SmartArt Diagrams

Lecture 145 Capturing Screenshots

Section 30: Microsoft Excel: Charts & Data Visualization

Lecture 146 Recommended Charts: Quick Wins

Lecture 147 Creating Specific Charts Step by Step

Section 31: Microsoft Excel: Page Layouts & Printing

Lecture 148 Intro to Page Layout Tools

Lecture 149 Themes and Consistency in Excel

Lecture 150 Adjusting Margins for Printing

Lecture 151 Switching Page Orientation

Lecture 152 Choosing the Right Page Size

Lecture 153 Adding Page Backgrounds

Lecture 154 Printing Your Spreadsheet

Section 32: Microsoft Excel: PivotTables Demystified

Lecture 155 Getting Started with PivotTables

Lecture 156 Building PivotTables for Data Analysis

Section 33: Microsoft Excel: Formulas Made Easy

Lecture 157 Intro to Formulas in Excel

Lecture 158 Understanding Addressing in Excel

Lecture 159 Linking Cells Across Sheets

Lecture 160 Basic Math Formulas: Add

Lecture 161 Basic Math Formulas: Subtract

Lecture 162 Basic Math Formulas: Multiply

Lecture 163 Basic Math Formulas: Divide

Lecture 164 Advanced Math Formulas

Section 34: Microsoft Excel: Advanced Functions

Lecture 165 Introducing Excel Functions

Lecture 166 Exploring Excel Functions: Sum

Lecture 167 Exploring Excel Functions: Min

Lecture 168 Exploring Excel Functions: Max

Lecture 169 Exploring Excel Functions: Count

Lecture 170 Exploring Excel Functions: Counta

Lecture 171 Exploring Excel Functions: Average

Lecture 172 Exploring Excel Functions: Median

Lecture 173 Exploring Excel Functions: Concat

Lecture 174 Exploring Excel Functions: If

Lecture 175 Exploring Excel Functions: Count If

Lecture 176 Exploring Excel Functions: Vlookup

Lecture 177 Exploring Excel Functions: Sum If

Lecture 178 Exploring Excel Functions: Now

Section 35: Microsoft Excel: Protect & Share Your Work

Lecture 179 Protecting Sheets in Excel

Lecture 180 Saving Your Spreadsheet

Lecture 181 Exporting as XLSX

Lecture 182 Exporting as CSV

Lecture 183 Exporting as TXT

Lecture 184 Exporting as PDF

Students who want to excel in academic and project work,Office workers who want to boost efficiency and skillset,Business owners who want to manage work professionally,Job seekers looking to add in-demand skills to their resume,Anyone who wants one complete course for all Microsoft Office essentials