Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Online Microsoft Office Complete Course: Word, Excel, Powerpoint and 365
Getting Started
Introduction (2:58)
Getting started on Windows macOS and Linux (1:21)
How to ask great questions (1:14)
FAQs (1:19)
Excel 2021: Basics
Excel Overview (5:20)
Start Excel Spreadsheet (4:26)
Enter Text and Numbers (7:25)
Relative References (3:40)
Working with ranges (6:52)
Save and Save as Actions (7:52)
File Extensions, Share, Export, and Publish files (5:53)
Excel 2021: Row, Columns, and Cells
Adding Rows and Columns (2:34)
Modifying Rows and Column lengths (5:03)
Excel 2021: Data Handling
Copy Cut and Paste (7:07)
Copying Formulas (3:01)
Excel 2021: Page Setting Up and print
Page setup options (5:50)
Fit to print on One Page (2:39)
Print Workbooks (2:47)
Excel 2021: Sorting and Filtering
Sorting Data Ascending Order (3:48)
Sorting Data Descending Order (2:25)
Filter Data (4:09)
Excel 2021: Writing Formulas
Basic formula operations (6:14)
Date time functions (6:21)
Mathematical functions phase 1 (19:54)
Mathematical functions phase 2 (12:23)
Excel 2021: Advanced Formulas
VLookup formula (12:12)
HLookup formula (4:07)
Excel 2021: XLOOKUP Only for 2021 and Office 365
XLookup (7:39)
Handling NA and Approximates match in XLookup (10:31)
Excel 2021: Data and Tools
Split Text into columns (7:03)
Flash Fill (7:03)
Data Validation (6:34)
Remove Duplicates (7:47)
Import Data from Text files (5:38)
Import Data from .CSV files (3:22)
Excel 2021: Formatting Data and Tables
Formatting Font (4:15)
Formatting Alignment (6:04)
Formatting Number (4:37)
Formatting Date (3:29)
Formatting tables (5:13)
Excel 2021: Pivot Tables
Creating Pivot Table (6:43)
Pivot charts (1:49)
Excel 2021: Charts
Excel Charts – Categories (2:31)
Elements of a chart (4:12)
Creating charts (1:55)
Column or Bar charts (4:21)
Formatting charts (3:37)
Line charts (2:13)
Pie and Doughnut charts (3:47)
PowerPoint 2021: Introduction
Overview (3:47)
Start PowerPoint Presentation (4:59)
Screen setting and Views (4:37)
PowerPoint 2021: Basics
Presentation Tips and Guidelines (6:00)
Creating a New Presentation (3:51)
Working with Slides (3:40)
Save a Presentation (4:16)
Print Slides (3:11)
PowerPoint 2021: Text and Bullet Options
Formatting Text (5:05)
Slide Text Alignments (3:01)
Multi-Column Text Alignments (1:40)
Adding Bullets and Numbered List Items (2:48)
PowerPoint 2021: Adding Graphic Assets
Insert Shapes (3:27)
Insert Icons (3:02)
Insert Graphics (3:39)
Add 3D Models (2:41)
Insert Pictures (2:59)
PowerPoint 2021: Picture Formatting
Picture Options (3:56)
Picture Cropping (2:33)
Applying Built-in Picture Styles (4:02)
PowerPoint 2021: SmartArt Graphics
Add SmartArt Graphic (2:33)
Modifying SmartArt (3:13)
Creating a Target Chart using SmartArt (3:04)
PowerPoint 2021: Working with Tables
Create a Table on Slide (4:13)
Formatting Tables (2:24)
Inserting Tables (1:56)
Table Layouts (1:19)
PowerPoint 2021: Working with Charts
Add a Chart (1:57)
Formatting Charts (1:48)
Insert Chart from Microsoft Excel (2:57)
PowerPoint 2021: Adding Multimedia
Adding Video to a Presentation (2:31)
Adding Audio to a Presentation (1:33)
Screen Recording and Adding (2:29)
PowerPoint 2021: Working with Transition
Applying Transitions to Presentation (4:14)
PowerPoint 2021: Animation
Object Animation (3:14)
Effect Options (2:03)
Advanced Animation (1:31)
Triggers to control animation (1:47)
PowerPoint 2021: Slideshow Affects
Onscreen Presentation (2:16)
Hiding Slides (1:42)
Copying Slides (2:10)
Changing Order of Slides (1:50)
Word 2021: Introduction
Overview of MS Word (3:58)
Start MS Word 2021 (4:48)
Word 2021: Basics
Create a New Blank Document (4:20)
Creating a Paragraph Text (4:55)
Non-printing characters (3:00)
Save a Document (2:45)
Open a Document (1:22)
Find and Replace (3:50)
Word 2021: Word Formatting
AutoCorrect Options (2:54)
Formatting Text (3:59)
Copy Cut and Paste (3:50)
Character Formatting (2:28)
Format Painter (3:58)
Work with Numbers (1:43)
Add Bullets (2:46)
Outline Creation (3:42)
Word 2021: Tables
Creating a Table (2:30)
Adding Rows and Columns to a table (2:11)
Formatting Table Data (2:19)
Borders and Shading (1:45)
Sorting in a Table (3:41)
Draw a Table (3:31)
Convert Text to Table (2:44)
Convert Table to Text (2:44)
Insert a Spreadsheet (1:41)
Quick Tables – Readily Available Formats (1:52)
Word 2021: Styles
Working with Styles (1:54)
Creating Styles (1:50)
Clear Formatting (1:16)
Word 2021: Page Layout
Margins (1:44)
Orientation (1:23)
Page size setting (0:57)
Adding columns (3:24)
Page break section break (1:37)
Adding watermark (2:59)
Headers and footers (2:41)
Word 2021: Envelops and Levels
Create envelops (2:28)
Creating labels (1:58)
Word 2021: Mail Merges
Creating a mail merge document (3:20)
Word 2021: Review and Printing
Thesaurus and spell check (1:09)
Word count (1:21)
Speech – read aloud (0:58)
Language – translate (1:13)
Tracking (1:10)
Handling NA and Approximates match in XLookup
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock