Complete Microsoft Office Masterclass Word Excel PowerPoint

Name: Complete Microsoft Office Masterclass Word Excel PowerPoint
Rating: 3.9 (131 reviews)

Master in Microsoft Word, Excel and PowerPoint for Business and Personal Job Success to boost productivity

Created byJames Joab Soren, Hudson Dynamic Lab

Last updated 6/2026

English

What you'll learn

Create, format, and edit professional documents
Use templates, styles, headers/footers, and tables
Insert graphics, charts, and SmartArt
Master mail merge for bulk emails and letters
Enter, format, and analyze data efficiently
Use formulas and functions (VLOOKUP, IF, SUMIF, etc.)
PivotTables, conditional formatting, and data validation
Design stunning, professional presentations
Use master slides, transitions, and animations
Insert multimedia elements

Course content

3 sections • 30 lectures • 10h 25m total length

Introduction1:35
Introducing MS EXCEL and Its Basic Tools7:48
Creating Telephone List in MS EXCEL27:58
Create a telephone list in Microsoft Excel by starting a blank workbook or template, outlining name, occupation, blood type, and phone numbers, and formatting cells with alignment and color.
Creating Data Entry Student's Information list Using MS EXCEL30:38
Microsoft Excel’s all Formula’s Usage Explanation part -15:02
Microsoft Excel’s all Formula’s Usage Explanation Part -248:33
Master essential Excel formulas, including sum, sumif, max, min, len, count, countif, left, right, concatenate, upper, proper, roman, now, today, time, and month, with practical examples.
Microsoft Excel’s all Formula’s Usage Explanation Part 38:58
Entry of Billing Information in MS EXCEL25:59
Create a bill invoice in Microsoft Excel by building a worksheet with company details, itemized columns, currency formatting, borders, then calculate amounts, totals, GST 15%, and the grand total.
How To Create Salary Sheet in MS EXCEL and Using Formulas & Algorithms34:23
Learn to create a salary sheet in Excel using formulas and algorithms, building a formatted workbook with serial numbers, names, positions, basic salary, deductions, and net pay.
Creating a Clean Spreadsheet in MS EXCEL25:16

Introducing MS Word and its Basic Tools Part 12:05
Introducing MS Word and its Basic Tools Part 220:07
Understanding basic Tools of MS WORD31:51
Master MS Word by creating and styling text with titles, headings, and subtitles, applying fonts, colors, borders, and highlights, then inserting tables, images, shapes, and references.
Creating a CV Using Microsoft Word Part 112:04
Creating a CV Using Microsoft Word Part 234:54
Creating Report File In MS WORD39:00
Creating a Table Report in MS WORD17:17
Creating a Simple Logo in MS WORD21:45
Creating a Front Page Using MS WORD27:08
Creating a TABLE CALERNDER DESIGN Using MS WORD33:56
Intro MS WORD2:07
Explore Microsoft Word basics, from creating documents to formatting, templates, and collaboration features, while building a cv, reports, calendars, and a simple logo.

Introducing MS POWERPOINT and its Basic Tools Part 17:06
Introducing MS POWERPOINT and its Basic Tools Part 236:55
Discover microsoft PowerPoint basics: format text, bullets, alignment, columns, shapes, images, smart art, 3D models, charts, and transitions, plus design, media insertion, and slide show practices.
Using and Redesigning Templates of MS POWERPOINT15:20
Learn to use and reuse pre-made templates in Microsoft PowerPoint, customize slides by editing text, colors, backgrounds, and footers, and apply transitions and animations such as morph, wipe, and float.
Creating Image Slider Design in MS POWERPOINT41:07
Creating Animated Motion Change Slides Using MS POWERPOINT Part -16:52
Creating Animated Motion Change Slides Using MS POWERPOINT part-29:42
Create animated motion change slides in PowerPoint by merging shapes, cropping to 16 by 9, and applying left motion path animations for professional presentations.
Creating POWERPOINT Slides Using Morph Transition and Hyperlink Function8:07
Create cohesive PowerPoint slides by adding text boxes and descriptions, applying the morph transition with a 1.25-second duration, and clean up layouts by removing guides and aligning images.
Creating Carousel Effect Animation in PowerPoint Using Morph Transition41:38
How to Take Help of AI for Complete Microsoft Office Masterclass

Requirements

No experience required

Description

Are you ready to become a Microsoft Office power user?

This all-in-one Microsoft Office Masterclass is designed to take you from beginner to advanced in Word, Excel, and PowerPoint – the three most essential tools in the Microsoft Office suite. Whether you're a student, professional, entrepreneur, or someone looking to boost productivity, this course gives you real-world, job-ready skills to thrive in any industry.

What You’ll Learn:

Microsoft Word: Craft Professional Documents with Finesse

Master document creation and formatting: Learn to effectively use styles, themes, and page layouts to create visually appealing and organized documents.
Enhance your writing with advanced features: Explore tables, mail merge, headers/footers, and advanced text manipulation techniques.
Collaborate and secure your documents: Discover tools for tracking changes, commenting, and protecting your work.
Automate repetitive tasks: Get an introduction to macros for increased efficiency.

Microsoft Excel: Become a Spreadsheet Wizard for Data Analysis

Conquer spreadsheet fundamentals: Master data entry, cell formatting, and basic calculations.
Unleash the power of formulas and functions: Learn to use a wide array of functions (lookup, logical, statistical, etc.) for powerful data manipulation.
Visualize your data with stunning charts and graphs: Create compelling visuals to communicate insights effectively.
Perform in-depth data analysis: Explore tools like Conditional Formatting, Goal Seek, and Solver for robust data interpretation.
Automate your workflow: Dive into Excel Macros for increased productivity and efficiency.

Microsoft PowerPoint: Design Captivating and Impactful Presentations

Create engaging slides from scratch: Learn to effectively use slide layouts, themes, and design principles.
Bring your presentations to life with animation and transitions: Master customizing animations, transitions, and multimedia elements (audio, video).
Streamline your design process: Understand the power of Slide Master and layouts for consistent branding.
Deliver impactful presentations: Learn techniques for effective communication, storytelling, and using speaker notes.
Incorporate external data: Seamlessly integrate charts, tables, and objects from other applications.

Who Is This Course For?

Anyone want to learn MS Office for Word, Excel and PowerPoint

Get lifetime access, learn at your own pace, and join thousands of students building their Microsoft Office skills with this comprehensive masterclass.

Boost your productivity and career—enroll now and start mastering Microsoft Office today!

Who this course is for:

Anyone want to learn MS Office for Word, Excel and PowerPoint

Complete Microsoft Office Masterclass Word Excel PowerPoint

What you'll learn

Explore related topics

Course content

Introduction10 lectures • 3hr 36min

MS Word11 lectures • 4hr 2min

PowerPoint9 lectures • 2hr 47min

Requirements

Description

Who this course is for: