Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering Microsoft Office: Word, Excel, PowerPoint, and 365
Section 01: Getting Started
Introduction (2:58)
Getting started on Windows, macOS, and Linux (1:21)
How to ask great questions (1:14)
FAQ’s (1:19)
Section 02: 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)
Section 03: Excel 2021: Rows, Columns, and Cells
Adding Rows and Columns (2:34)
Modifying Rows and Column lengths (5:03)
Section 04: Excel 2021: Data Handling
Copy Cut and Paste (7:07)
Copying Formulas (3:01)
Section 05: Excel 2021: Page Setting Up and Print
Page setup options (5:50)
Fit to print on One Page (2:39)
Print Workbooks (2:47)
Section 06: Excel 2021: Sorting and Filtering
Sorting Data Ascending Order (3:48)
Sorting Data Descending Order (2:25)
Filter Data (4:09)
Section 07: Excel 2021: Writing Formulas
Creating Basic Formulas (6:14)
Datetime Formulas (6:21)
Mathematical formulas phase1 (19:54)
Mathematical formulas phase2 (12:23)
Section 08: Excel 2021: Advanced Formulas
VLOOKUP formula (12:12)
HLOOKUP formula (4:07)
Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365
XLOOKUP (7:39)
Handling #NA and Approximates match in XLOOKUP (10:31)
Section 10: 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)
Section 11: 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)
Section 12: Excel 2021: Pivot Tables
Pivot Tables (6:43)
Pivot Charts (1:49)
Section 13: 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)
Section 14: PowerPoint 2021: Course Introduction
Overview (3:47)
Start PowerPoint Presentation (4:59)
Screen setting and Views (4:37)
Section 15: 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)
Section 16: 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)
Section 17: 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)
Section 18: PowerPoint 2021: Picture Formatting
Picture Options (3:56)
Picture Cropping (2:33)
Applying Built-in Picture Styles (4:02)
Section 19: PowerPoint 2021: SmartArt Graphics
Add SmartArt Graphic (2:33)
Modifying SmartArt (3:13)
Creating a Target Chart using SmartArt (3:04)
Section 20: PowerPoint 2021: Working with Tables
Create a Table on Slide (4:13)
Formatting Tables (2:24)
Inserting Tables (1:56)
Table Layouts (1:19)
Section 21: PowerPoint 2021: Working with Charts
Add a Chart (1:57)
Formatting Charts (1:48)
Insert Chart from Microsoft Excel (2:57)
Section 22: PowerPoint 2021: Adding Multimedia
Adding Video to a Presentation (2:31)
Adding Audio to a Presentation (1:33)
Screen Recording and Adding (2:29)
Section 23: PowerPoint 2021: Working with Transition
Applying Transitions to Presentation (4:14)
Section 24: PowerPoint 2021: Animation
Object Animation (3:14)
Effect Options (2:03)
Advanced Animation (1:31)
Triggers to control animation (1:47)
Section 25: PowerPoint 2021: Slideshow Effects
Onscreen Presentation (2:16)
Hiding Slides (1:42)
Changing Order of Slides (1:50)
Copying Slides (2:10)
Section 26: Word 2021: Introduction
Overview of MS Word (3:57)
Start MS Word 2021 (4:48)
Section 27: Word 2021: Basics
Create a New Blank Document (4:20)
Creating a Paragraph Text (4:55)
Non-printing characters (2:59)
Open a Document (1:22)
Find and Replace (3:50)
Section 28: 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)
Section 29: 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:43)
Convert Table to Text (2:05)
Insert a Spreadsheet (1:41)
Quick Tables – Readily Available Formats (1:52)
Section 30: Word 2021: Styles
Working with Styles (1:54)
Creating Styles (1:50)
Clear Formatting (1:16)
Section 31: 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)
Section 32: Word 2021: Envelops and Lables
Create envelops (2:28)
Creating labels (1:58)
Section 33: Word 2021: Mail Merges
Create a New Blank Document (4:20)
Section 34: 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)
Import Data from .CSV files
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock