Office Fundamentals

Understand the Screen
Understand the Word Screen and Ribbon

Select and Edit Text
How to Select and Edit Text in Word

Cut, Copy, and Paste
How to Cut, Copy, and Paste in Word

Undo, Redo, and Repeat
How to Undo, Redo, and Repeat Actions in Word

Check Spelling and Grammar
How to Check Spelling and Grammar in Word

Find and Replace Text
How to Find and Replace Text in Word

Highlight and Comment
How to Highlight and Comment in Word

Links
How to Add Links in Word

Pictures
How to Insert and Crop Pictures in Word

Word

Line and Paragraph Spacing
How to Adjust Line and Paragraph Spacing in Word

Indent Paragraphs
Follow these simple steps to create a hanging indent in Word. In hanging indentation, a paragraph's first line remains against the left margin while the other lines are indented, like in a bibliography.

Adjust Margins
How to Adjust Margins in Word

Headers and Footers
How to Add and Remove Headers and Footers in Word

Page Numbers
Add and Format Page Numbers in a Word Document

Page Breaks
How to Add and Remove Page Breaks in Word

Create Tables
How to Create Tables in Word

Position and Text Wrap
How to Position Images and Wrap Text in Word

Forms
How to Build Forms in Word

Advanced Find and Replace
How to Use Advanced Find and Replace in Word

Print Labels
How to Print Labels in Word

Excel

Select Cells and Ranges
How to Select Cells and Ranges in Excel

Insert and Move Cells
How to Insert and Move Cells in Excel

Row Heights and Column Widths
How to Adjust Row Heights and Column Widths in Excel

Freeze Rows and Columns
How to Freeze and Unfreeze Rows and Columns in Excel

Hide Columns and Rows
How to Hide Columns and Rows in Excel

AutoFill
How to Use AutoFill in Excel

Sums and Averages
How to Use Sum and Average Formulas in Excel

Format Numbers and Dates
How to Format Numbers and Dates in Excel

Borders and Background Colors
How to Add Cell Borders and Background Colors in Excel

Reference External Worksheets
How to Reference External Worksheets in Excel

Version History
How to Use Version History in Excel

PowerPoint

Add Slides from External Sources
How to Combine PowerPoints

Presenter View
How to Use Presenter View in PowerPoint

Convert Presentations to Video
How to Convert a PowerPoint to Video

Slide Notes
How to How to Print a PowerPoint with Notes

Slide Size
How to Change Slide Size in PowerPoint

Templates
How to Create a PowerPoint Template

Icons
How to Add Icons in PowerPoint

Slide Transitions
How to Add Transitions in PowerPoint

Apply Animations
How to Add Animations in PowerPoint

Footers
How to Add Slide Numbers in PowerPoint

Outlook

Sort Email
How to Sort Email in Outlook

Signatures
How to Create Signatures in Outlook

Send Automatic Replies
How to Send Automatic Replies in Outlook

Recall Messages
How to Recall Messages in Outlook

Save Messages in Alternate Formats
How to Save Messages in Alternate Formats in Outlook

View and Search Contacts
How to View and Search Contacts in Outlook

View your Calendar
How to View your Calendar in Outlook

Share your Calendar
How to Share your Calendar in Outlook

Schedule Meetings
How to Schedule Meetings in Outlook

Microsoft Teams

Join a Meeting
How to Join a Meeting in Microsoft Teams

Manage Audio and Video Settings
How to Manage Audio and Video Settings in Microsoft Teams

Record a Meeting
How to Record a Meeting in Microsoft Teams

Join and Create Teams
How to Join and Create Teams in Microsoft Teams

Use Wikis
How to Use Wikis in Microsoft Teams

Change your Status
How to Change Your Status in Microsoft Teams

Teams Settings
How to Update Settings in Microsoft Teams