Microsoft Office All-in-One: Excel, Word and PowerPoint

Name: Microsoft Office All-in-One: Excel, Word and PowerPoint
Rating: 4.1 (29 reviews)

Everything You Need To Confidently Use Excel, Word and PowerPoint In One Complete Course

Created byLogic Labs

Last updated 1/2026

English

What you'll learn

Introduction Microsoft Excel
Create New Worksheets
Tabs and Ribbon
Logical Function (AND, OR, NOT, XOR)
SUM Function (SUM, SUMIF, SUMIFS, SUMPRODUCT)
Round Function (ROUND, ROUNDUP, ROUNDDOWN, and MROUND)
Average Function
MAX, MIN Function
Today and Now Function
DATE Function (DATE, DATEIF, EDATE, EOMONTH)
LOOKUP Function: VLOOKUP, HLOOKUP and XLOOKUP
Import data from Web and Text
Charts & Graphs (Line, Pie, Column, Bar, Scatter)
Create Pivot Tables
Freeze panes

Course content

3 sections • 78 lectures • 8h 33m total length

Overview of Microsoft Excel Interface5:06
Create, Open, Save Workbook10:07
Navigation and Selection12:24
Tabs and Ribbon12:18
Formulas and Functions15:17
Excel Shortcut Keys12:39
Error Functions6:00
Relative & Absolute Cell References5:21
Logical Function (AND, OR, NOT, XOR)9:47
IF Functions4:38
Nesting Multiple IF Statements7:26
Switch6:00
Cell4:29
Explore the basics of Excel cells, insert, copy, paste, and clear content; format with font styles, colors, and fill, and use cell references and simple formulas.
Row6:19
Round Functions (ROUND, ROUNDUP, ROUNDDOWN and MROUND)7:19
SMALL and LARGE Function6:47
Rank, Percentrank, & Percentile Functions7:19
RAND & RANDBETWEEN Functions5:09
SORT and SORTBY Function12:28
FILTER Function11:09
Combine the SORT, UNIQUE, and COUNT functions6:47
Subtotal Functions5:07
Today and Now Functions4:08
LOOKUP Function10:28
VLOOKUP6:17
HLOOKUP Function11:28
VLookup to Return Multiple Matches9:42
VLookup Approximate Match5:51
Vlookup with Exact Match6:06
XLOOKUP9:29
Drop-Down Lists with SORT, UNIQUE & No Blanks8:32
Unique Drop Down Lists that Automatically Update with New Values3:50
Learn to create a unique drop-down list in Excel that automatically updates as new values are added, using the unique function, a dynamic table, and data validation.
Pie Chart7:26
Learn how to create and customize a pie chart in Excel, including data preparation, chart insertion, styling, labels, legends, and 3d options to visualize proportions.
Column Chart3:51
Bar Chart5:04
Area Chart6:49
Learn to create and customize an area chart in Excel using date or category data and values, including axis titles, chart elements, 3d options, and styling.
Scatter Chart8:56
Histogram Chart7:14
Funnel Chart4:21
Show Gridlines4:46
Discover how to show and customize gridlines in Excel to enhance readability, using the view tab or advanced options, customize color and style, and save your workbook.
Hyperlink7:35
Import Data From Web5:25
Import data from a web page into Excel by copying the URL, loading as a table, and refreshing to update real-time information.
Import Data From Text7:02
Create Pivot Tables10:42
Freeze Panes5:17
Split Panes3:22
Add and Delete Worksheets3:48
Learn to add and delete worksheets in Excel, rename sheet names, and manage your workbook using the plus icon, right-click options, and sequential sheet numbering.
Hide and Unhide Worksheets3:05
Learn to hide and unhide worksheets in Excel to keep workbooks organized and secure, using right-click commands and the unhide dialog to select multiple sheets.
Proetect Worksheet6:55

Introduction to Word Interface4:06
Basic Text Entry and Editing6:27
Undo, Redo, and Repeat Actions3:52
Master undo, redo, and repeat actions in Word to quickly revert changes, reapply last steps, and repeat formatting using keyboard shortcuts and the quick access toolbar.
Font Formatting (Type, Size, Color, Style)4:53
Discover how to format fonts in Microsoft Word by selecting text, changing font type, size, color, and styles. Apply bold, italic, underline, and effects with shortcuts and the font dialog.
Paragraph Formatting (Alignment, Spacing, Indentation)6:40
Format paragraphs in Word by adjusting alignment, spacing, and indentation to produce clean, professional documents; use left, center, right, justify, line spacing, and first-line or hanging indents.
Bulleted, Numbered, Multilevel6:33
Clearing Formatting3:23
Inserting and Deleting Page Breaks3:08
Adding Page Numbers3:32
Inserting Images3:17
Resizing, Moving and Formatting Images4:50
Shapes and SmartArt Graphics8:07
Creating a Table of Contents5:20
Working With Macros7:23
Print Preview and Print Settings5:12
Saving Documents as PDFs3:23
Save Word documents as PDF and learn to use save as or export as PDF options, including page range and standard or high quality settings to preserve layout.

Creating Your First Presentation7:09
Create your first presentation from a blank slide, add slides with layouts, insert text and images, and use SmartArt, icons, transitions, and animations.
Introduction to Ribbon, Quick Access Toolbar3:10
Navigate PowerPoint ribbons and the quick access toolbar to format text, insert images, tables, charts, and media, and manage slides with the slide pane and notes pane for delivery.
Understanding Slide Layouts and Placeholders4:44
Customizing Fonts, Backgrounds and Slide Masters7:09
Using Icons and SmartArt Graphics6:40
Inserting and Editing Images, Screenshots and Stock Photos6:13
Embedding Videos and Audio Files5:55
Embed videos and audio in PowerPoint from device or online sources, resize and position them, and trim or fade with preview for smooth playback.
Using Hyperlinks and Action Buttons for Interactivity7:52
Adjusting Animation Timings and Triggers4:19
Master PowerPoint animations by adjusting timings and triggers to create smooth, professional slides. Learn to set duration, delays, and trigger objects in the animation pane and preview timelines in slideshow.
Using Slide Transitions Effectively4:18
Using Sections to Organize Large Presentations3:55
Mastering Tables, Charts and Excel Data Integration9:38
Master tables, charts, and Excel data integration in PowerPoint to create professional, data-driven presentations through table formatting, chart customization, and linked data updates.
Tips for Delivering Engaging Presentations4:45

Requirements

No Excel experience needed

Description

Microsoft Office All-in-One: Excel, Word, and PowerPoint is a complete practical course designed to help you build strong, job ready skills in the most widely used office applications.

Whether you are a beginner or someone looking to improve productivity at work or school, this course will guide you step by step through Microsoft Word, Excel, and PowerPoint, from the basics to more advanced features. You will learn how to create professional documents, analyze and manage data efficiently, and design impactful presentations.

In the Microsoft Word section, you’ll learn how to format documents, create reports, resumes, letters, and official documents with confidence. You’ll master styles, layouts, tables, headers and footers, and document organization to produce clean, professional results.

The Microsoft Excel section focuses on essential spreadsheet skills used in offices and businesses worldwide. You’ll learn how to enter and organize data, use formulas and functions, create charts, apply formatting, and analyze information efficiently. This section emphasizes real-world tasks such as budgeting, tracking, and reporting.

In the Microsoft PowerPoint section, you’ll learn how to design visually appealing and professional presentations. You’ll discover how to structure slides, use animations and transitions effectively, insert charts and visuals, and present information clearly for meetings, classes, and business presentations.

This course includes hands-on exercises and practical examples to help you apply your skills immediately. You’ll work on real life scenarios that reflect everyday office tasks, improving both speed and accuracy.

This course is ideal for:

Beginners with no prior Microsoft Office experience
Students and job seekers
Office professionals and administrators
Business owners and entrepreneurs

By the end of this course, you’ll be confident using Microsoft Word, Excel, and PowerPoint for professional, academic, and personal purposes. You’ll gain valuable skills that enhance productivity, improve job performance, and increase career opportunities.

This all-in-one course gives you everything you need to master Microsoft Office in one place.

Who this course is for:

Beginners who want to learn Microsoft Office from scratch
Office professionals looking to improve productivity
Students preparing for academic or career success
Job seekers wanting to strengthen resume skills

Microsoft Office All-in-One: Excel, Word and PowerPoint

What you'll learn

Explore related topics

Course content

Microsoft Excel49 lectures • 5hr 57min

Microsoft Word16 lectures • 1hr 20min

Microsoft PowerPoint13 lectures • 1hr 16min

Requirements

Description

Who this course is for: