Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Office 2021 Basics
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (5:12)
Excel Basics Overview (1:29)
Opening Excel and Selecting the Blank Workbook Template (1:27)
Excel Interface (6:21)
Entering Data and Using AutoFill (3:05)
Numbers (2:51)
Sorting Lists and Saving Files (2:51)
Basic Formulas (3:56)
Basic Functions (4:10)
SUM Function and Function Arguments (4:59)
AutoSum (2:16)
Average (3:58)
MAX and MIN Functions (1:45)
COUNT Function (3:10)
IF Function (4:09)
Relative and Absolute Cell References (4:10)
Nested IF Functions (6:04)
Adjusting Column Widths and Formatting Numbers (4:12)
Using Cell Styles to Format Data (3:51)
Inserting and Hiding Rows and Columns (3:54)
Cutting, Copying, and Pasting Data (6:52)
Inserting New Worksheets, Renaming Tabs, and Printing (6:35)
Excel Basics Recap (0:20)
PowerPoint Basics Overview (0:55)
PowerPoint Interface (5:19)
Creating Slides (3:16)
Duplicating and Deleting Slides (3:24)
SmartArt (4:20)
Moving Slides (1:08)
Keyboard Shortcuts (1:04)
Formatting Graphics and Saving Presentations (2:50)
Formatting Text and Using the Format Painter (3:32)
Duplicating Slides and Updating Text (1:47)
Inserting Images (5:23)
Formatting Images (3:15)
Inserting Shapes (1:52)
Formatting and Aligning Shapes (4:00)
Grouping Shapes (3:31)
Animation (6:31)
Themes (4:08)
Reviewing with Spell Check and Rehearsing (8:19)
PowerPoint Takeaways (4:23)
PowerPoint Basics Recap (0:24)
Outlook Basics Overview (1:10)
Outlook Interface (3:43)
Composing and Sending Emails (4:27)
Setting Up Auto Spell Check (0:48)
Formatting Emails (5:25)
Attaching Files (7:50)
Tracking Emails (5:23)
Email Recall and Resend (7:01)
Marking Emails (2:23)
Organizing with Folders and Search Folders (6:56)
Scheduling Meetings (7:12)
Adding Emails to Calendars and Printing (6:29)
Outlook Basics Recap (0:29)
Teams Basics Overview (0:58)
Why Use Teams (3:08)
Teams Interface (5:23)
Profile and Status Options (3:13)
Chat (2:46)
Group Chat (2:55)
Chatting with External Users (1:40)
Video Calls (5:23)
Sharing Files (1:29)
Creating Teams, Channels, and Posts (6:10)
Search (1:58)
Scheduling Meetings (6:14)
Notification Settings (3:43)
Teams Overview Recap (0:27)
Conclusion (5:55)
Themes
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock