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

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

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

Created byLogic Labs

Last updated 1/2026

English

English [Auto],

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
Explore the Microsoft Excel interface by navigating the ribbon, tabs, quick access toolbar, and formula bar, and understand the worksheet grid, cells, and sheet tabs for efficient data work.
Create, Open, Save Workbook10:07
Create, open, and save workbooks in Excel, recognizing a workbook as a data container with multiple worksheets and templates, while using flexible save options.
Navigation and Selection12:24
Master navigation and selection in Excel using keyboard shortcuts and go-to commands. Apply insert, delete, and find and replace tools to streamline data management.
Tabs and Ribbon12:18
Explore how to navigate Excel's tabs and ribbons, mastering home tab, insert tab, data tab, draw tab, page layout, formula tab, review tab, and view tools for efficient spreadsheet work.
Formulas and Functions15:17
Master Excel formulas and functions from sum and average to trim, max, min, length, today, and now, plus text tools like concatenate and left, right, and mid.
Excel Shortcut Keys12:39
Boost your productivity with essential Excel shortcut keys, from close and save commands (Ctrl+W, Ctrl+S) to copy, paste, undo, and navigate worksheets for faster data work.
Error Functions6:00
Explore how the Excel error function gracefully handles common errors like not available, division by zero, and value or reference errors, using examples to improve data reliability.
Relative & Absolute Cell References5:21
Explore relative and absolute cell references in Excel, learn to lock cells with the dollar sign, and build dynamic formulas that adapt as you drag down across data.
Logical Function (AND, OR, NOT, XOR)9:47
IF Functions4:38
Explore how to use Excel if functions to perform logical tests, define value if true or false, and apply with real-world data to determine grades and pass or fail outcomes.
Nesting Multiple IF Statements7:26
Nest multiple if statements in Excel to handle complex conditions with math and English scores. Use logical tests, and/or operators, and if error to manage missing data for robust analysis.
Switch6:00
Master how to switch between sheets, workbooks, and windows in Excel with keyboard shortcuts for fast navigation, boosting efficiency and productivity.
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
Learn to use the small and large functions in Excel to find the k-th smallest or largest values in a data range. Compare with min and max, and handle errors.
Rank, Percentrank, & Percentile Functions7:19
Learn to use rank, percent rank, and percentile functions in Excel to analyze data, determine relative standings, and identify values at specific percentiles.
RAND & RANDBETWEEN Functions5:09
Explore the rand and randbetween functions to generate random decimals and integers, then apply them to real-world data such as simulating daily website traffic and randomizing student presentations.
SORT and SORTBY Function12:28
Explore how to use Excel's sort and sort by functions to organize data quickly, sorting by columns or by another range, using arrays and tables with dynamic ranges.
FILTER Function11:09
Explore the filter function in Excel, a dynamic array tool that extracts data from a table by criteria, handling multiple conditions and empty results.
Combine the SORT, UNIQUE, and COUNT functions6:47
Combine the sort, unique, and count functions in Excel to quickly analyze and organize data. Learn through practical examples like zip codes and fruit lists.
Subtotal Functions5:07
Explore how to use the subtotal function in Excel to group by product, calculate sums or averages, and generate subtotals and grand totals for large data sets.
Today and Now Functions4:08
Discover how to use today and now in Excel to fetch current date or time, update automatically, format dates, track events, and perform date calculations like age and duration.
LOOKUP Function10:28
Master the Excel lookup function to search a value in a range and return a corresponding value from another range, including vertical, horizontal, and approximate matches.
VLOOKUP6:17
HLOOKUP Function11:28
Learn how to use the Excel HLOOKUP function for horizontal lookups by specifying the lookup value, table array, row index, and exact or approximate match, with practical examples.
VLookup to Return Multiple Matches9:42
Master using VLOOKUP to return multiple matches for product names, sales persons, and amounts in a table in Excel by pairing ROW, MATCH, and COUNTIF, with IFERROR to hide blanks.
VLookup Approximate Match5:51
Learn how to use VLOOKUP to perform approximate matches in Excel, including setting range_lookup to true, sorting data ascending, and retrieving nearest grades or values.
Vlookup with Exact Match6:06
Learn to use vlookup with exact match in Excel to search a value in table and return corresponding value from a column by setting range_lookup to false or 0.
XLOOKUP9:29
Learn the XLOOKUP function in Excel, a flexible lookup and reference tool that replaces VLOOKUP and HLOOKUP, with its syntax and real-world data applications.
Drop-Down Lists with SORT, UNIQUE & No Blanks8:32
Create a dynamic drop-down list in Excel using data validation with sorted unique values and no blanks, by filtering, removing blanks, and converting to a table for easy expansion.
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
Create a column chart in Excel from prepared categories and values using the insert tab, then edit data and chart elements like titles and legends.
Bar Chart5:04
Organize data with clear headers, convert to a table, and insert a cluster bar chart to visualize month-wise sales in Excel, then customize titles, colors, and layouts.
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
Learn to create a scatter chart in Excel, visualize data relationships, trends, and correlations, and customize with trend lines, colors, and chart elements.
Histogram Chart7:14
Learn to create and customize histogram charts in Excel to analyze data distributions, using test scores as an example and adjusting chart elements, colors, and axis titles.
Funnel Chart4:21
Learn to create and customize funnel charts in Excel to visualize data across stages, by preparing two-column data and adjusting colors, styles, titles, axes, and legend.
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
Master hyperlinks in Excel to link web pages, files, or other cells within your workbook, and learn how to create and edit them from the insert tab.
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
Import data from a text or csv file into Excel by selecting the text file, choosing delimiters, and loading it as a table or pivot table for analysis.
Create Pivot Tables10:42
Learn to create pivot tables in Excel in 10 minutes, analyze and summarize data with fields like date, product, category, sales, and quantity.
Freeze Panes5:17
Master freeze panes in Excel to keep headers visible as you scroll through large data sets. Learn to freeze the top row, freeze the first column, and unfreeze when needed.
Split Panes3:22
Split panes divide your Excel window into two horizontal, scrollable sections, keeping specific rows or columns visible while you work through a large dataset.
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
Learn to protect and unprotect worksheets in Excel, set a password, and control which cells may be edited to safeguard data and formulas.

Introduction to Word Interface4:06
Explore the Microsoft Word interface by navigating the ribbon, quick access toolbar, and backstage view to use the Home, Insert, Design, and other tabs, and manage files efficiently.
Basic Text Entry and Editing6:27
Learn to enter and edit text in Microsoft Word, select and format text with bold, italic, underline, and use copy, cut, paste, undo, redo, and adjust font size and style.
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
Learn to create and customize bulleted, numbered, and multilevel lists in Microsoft Word. Define new bullets, choose formats, and use tabs to indent subpoints.
Clearing Formatting3:23
Learn to clear formatting in Microsoft Word by selecting text, using the Clear Formatting tool, remove character formatting with Ctrl+Space, and reset paragraph styles with Ctrl+Q.
Inserting and Deleting Page Breaks3:08
Learn how to insert and delete page breaks in Microsoft Word using the insert tab or control+enter. Be careful deleting breaks in long documents to avoid shifting layout.
Adding Page Numbers3:32
Add page numbers in Word via the insert tab, choose bottom of page in header or footer, start numbering from a chosen page, and omit the first page.
Inserting Images3:17
Learn to insert images into Microsoft Word from your computer or online using the insert tab, pictures, and online pictures, then resize and position them as needed.
Resizing, Moving and Formatting Images4:50
Learn to insert, resize, move, and format images in Word, using wrap options, cropping, borders, brightness, and color adjustments to create polished documents.
Shapes and SmartArt Graphics8:07
Learn to insert and format shapes and smart art in Microsoft Word, apply colors, outlines, and text, and manage grouping, bring to front, or send to back.
Creating a Table of Contents5:20
Create a professional table of contents in Microsoft Word by applying heading styles and inserting an automatic or custom table of contents from the references tab. Update as headings change.
Working With Macros7:23
Learn to automate repetitive Word tasks by recording, editing, and running macros, enabling the developer tab, and saving macros for all documents with keyboard shortcuts and the VBA editor.
Print Preview and Print Settings5:12
Master print preview and print settings in Microsoft Word by previewing pages, selecting printers, choosing copies, page ranges, orientation, paper size, margins, duplex, and color options.
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
Explore PowerPoint slide layouts and placeholders to structure and customize presentations, using the home tab, slide master, and various placeholders for text, images, and media.
Customizing Fonts, Backgrounds and Slide Masters7:09
Learn to customize fonts, backgrounds, and slide masters in PowerPoint to create consistent, professional presentations with branded logos and reusable themes.
Using Icons and SmartArt Graphics6:40
Explore built-in shapes, icons, and smart art graphics in PowerPoint to create visually engaging slides, using the insert tab, shape customization, and 3d effects.
Inserting and Editing Images, Screenshots and Stock Photos6:13
Insert and edit images, stock photos, and screenshots in PowerPoint to enhance your presentations with tools for removing background, adjusting brightness and contrast, transparency, cropping, and artistic effects.
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
Learn to boost PowerPoint interactivity by using hyperlinks and action buttons to link to websites, other slides, files, and email addresses, enabling interactive slides, a navigation menu, and interactive quiz.
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
Master PowerPoint slide transitions by choosing subtle, exciting, or dynamic content effects like morphs, zoom, and flips, applying them consistently to keep your presentation professional and engaging.
Using Sections to Organize Large Presentations3:55
Learn how to use sections in PowerPoint to organize slides into manageable groups, improve navigation, and assign work to team members.
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
Learn to deliver engaging PowerPoint presentations by keeping slides simple with the 6x6 rule, using high-quality visuals, infographics and charts, and practicing delivery with storytelling.

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: