Unit 1 - Introduction to Microsoft Excel Training
Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0
- Logging in to Microsoft 365
- Installing Applications
- Creating New Files and AutoSaving
- Protected View
- File Sharing
- File Collaboration
- Version History
- Getting Updates
- Mac Versions
Lesson 2: Creating a Microsoft Excel Workbook - Quizzes: 1, Assignments: 1
- Starting Microsoft Excel
- Creating a Workbook
- Saving a Workbook
- The Status Bar
- Adding and Deleting Worksheets
- Copying and Moving Worksheets
- View Options for the Worksheet
- Closing a Workbook
Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0
- Tabs
- Groups and Commands
- Microsoft Search Box
- Customizing the Ribbon
Lesson 4: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 3
- Introduction to the Backstage View
- Opening a Workbook
- New Workbooks and Excel Templates
- Printing Worksheets
- Personalizing Microsoft Office
Lesson 5: The Quick Access Toolbar - Quizzes: 1, Assignments: 1
- Getting Started
- Adding Common Commands
- Adding Additional Commands with the Customize Dialog
- Adding Ribbon Commands or Groups
Lesson 6: Entering Data in Microsoft Excel Worksheets - Quizzes: 1, Assignments: 2
- Entering Text
- Inserting and Deleting Cells
- Inserting Hyperlinks
- Inserting WordArt
- Using AutoComplete
- Entering Numbers and Dates
- Using the Fill Handle
Lesson 7: Formatting Microsoft Excel Worksheets - Quizzes: 1, Assignments: 4
- Selecting Ranges of Cells
- Hiding Worksheets
- Adding Color to Worksheet Tabs
- Adding Themes to Workbooks
- Adding a Watermark
- The Font Group
- The Alignment Group
- The Number Group
Lesson 8: Editing Worksheets - Quizzes: 1, Assignments: 2
- Find
- Find and Replace
- Using the Clipboard
- Moving Columns / Rows
Lesson 9: Working with Rows and Columns - Quizzes: 1, Assignments: 1
- Inserting and Deleting Rows, Columns, and Cells
- Transposing Rows and Columns
- Row Height and Column Width
- Hiding and Unhiding Rows and Columns
- Freezing Panes
Lesson 10: Using Formulas in Microsoft Excel - Quizzes: 1, Assignments: 1
- Math Operators and the Order of Operations
- Entering Formulas
- AutoSum (and Other Common Auto-Formulas)
- Copying Formulas
- Relative, Absolute, and Mixed Cell References
Lesson 11: Finalizing Microsoft Excel Worksheets - Quizzes: 1, Assignments: 1
- Setting Margins
- Setting Page Orientation
- Setting the Print Area
- Print Scaling (Fit Sheet on One Page)
- Repeating Headings
- Headers and Footers
Lesson 12: Using Copilot in Microsoft Excel - Quizzes: 1, Assignments: 1
- Copilot in Microsoft 365 Excel
- Creating Columns
- Analyzing Your Data
- Importing and Framing Data
Introduction to Microsoft Excel Exam
Unit 2 - Intermediate Microsoft Excel Training
Lesson 1: Common Functions - Quizzes: 1, Assignments: 7
- Using Named Ranges in Formulas
- Using Formulas That Span Multiple Worksheets
- Functions: IF and IFS
- Functions: AND and OR
- Functions: NOT
- Functions: SWITCH
- Functions: COUNTIF, AVERAGEIF, and SUMIF
- Functions: PMT and NPER
- Functions: TEXTJOIN and CONCAT
- Text Functions
- Date and Time Functions
Lesson 2: Working with Lists - Quizzes: 1, Assignments: 4
- What is a List of Data?
- Removing Duplicates from a List
- Sorting Data in a List
- Filtering Data in a List
- Adding Subtotals to a List
Lesson 3: Visualizing Your Data - Quizzes: 1, Assignments: 2
- Chart Basics
- Tools for Editing Charts
- The Format Tool Tab
- Using the Three Chart Buttons
- The Format Task Pane
- Useful Charts
- Line and Area Charts
- Hierarchy Charts
- Statistic Charts
- Other Charts
- Combo Charts
- Using Recommended Charts
- Sparklines
- Add and Format Objects
- Working with Shapes
- Working with Icons
- Working with SmartArt
- Using the Quick Analysis Tool
Lesson 4: Working with Tables - Quizzes: 1, Assignments: 1
- Format Data as a Table
- Table Design Tool Tab
- Formatting Individual Cells
- Selecting Table Rows and Columns
- Structured References
- Convert a Table to a Range
Lesson 5: Advanced Formatting - Quizzes: 1, Assignments: 2
- Cell Styles
- Conditional Formatting
- Conditional Formatting: Highlight Cells Rules
- Conditional Formatting: Top/Bottom Rules
- Conditional Formatting: Data Bars, Color Scales, and Icon Sets
- Conditional Formatting: Create a New Rule
- Removing Conditional Formatting
Intermediate Microsoft Excel Exam
Unit 3 - Advanced Microsoft Excel Training
Lesson 1: Using PivotTables - Quizzes: 1, Assignments: 1
- How PivotTables Work
- Timeline Filters
- Inserting Slicers
- Grouping Data
- Calculated Fields
- PivotCharts
Lesson 2: Advanced Functions - Quizzes: 1, Assignments: 2
- Function Syntax
- ROWS, COLUMNS, INDEX, and XMATCH
- Arrays and Array Formulas
- SORT, FILTER, and SORTBY
- Lookup Functions
- The LET Function
- The TRANSPOSE Function
Lesson 3: Auditing Workbooks - Quizzes: 1, Assignments: 1
- Inspecting a Workbook
- Tracing Precedents and Dependents
- Watch Window
- Evaluating Formulas
- Error Checking
Lesson 4: Data Tools - Quizzes: 1, Assignments: 5
- Importing Data from Online Source
- Converting Text to Columns
- Importing Files
- Linking to External Data
- Controlling Calculation Options
- Data Validation
- Consolidating Data
- What-If Analysis
Lesson 5: Recording and Using Macros - Quizzes: 1, Assignments: 2
- Recording Macros
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
Lesson 6: Working with Others - Quizzes: 1, Assignments: 1
- Comments and Notes
- Protecting Worksheets and Workbooks
- Marking a Workbook as Final
- Other Sharing Concerns
Advanced Microsoft Excel Exam, Final Microsoft Excel Exam
Unit 4 - Introduction to Microsoft Word Training
Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0
- Logging in to Microsoft 365
- Installing Applications
- Creating New Files and AutoSaving
- Protected View
- File Sharing
- File Collaboration
- Version History
- Getting Updates
- Mac Versions
Lesson 2: Creating a Microsoft Word Document - Quizzes: 1, Assignments: 1
- Starting Microsoft Word
- Creating a Document
- Saving a Document
- The Status Bar
- Closing a Document
- Opening Documents
Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0
- Tabs
- Groups and Commands
- Microsoft Search Box
- Customizing the Ribbon
Lesson 4: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 3
- Introduction to the Backstage View
- Opening a Document
- New Documents and Word Templates
- Configuring Documents to Print
- Adding Your Name to Microsoft Word
- Adding Values to Document Properties
Lesson 5: The Quick Access Toolbar - Quizzes: 1, Assignments: 1
- Getting Started
- Adding Common Commands
- Adding Additional Commands with the Customize Dialog
- Adding Ribbon Commands or Groups
Lesson 6: Formatting Microsoft Word Documents - Quizzes: 1, Assignments: 7
- Selecting Text
- Fonts
- Working with Lists
- Inserting a Hyperlink in a Document
- Using Styles
- Using Themes
- Using the Ruler
- Indentation
- Setting Margins
- Special Characters
- WordArt
- Page Background Elements
Lesson 7: Editing Documents - Quizzes: 1, Assignments: 2
- Find
- Find and Replace
- Using the Clipboard
- Search Options
- Inserting Text from Another File
Lesson 8: Finalizing Microsoft Word Documents - Quizzes: 1, Assignments: 3
- Adding Page Numbers
- Headers and Footers
- Microsoft Editor
- Checking Spelling and Grammar
- Internationalization and Accessibility
Lesson 9: Using Copilot in Microsoft Word
- Copilot in Microsoft 365 Word
- Highlighting Existing Text
- Copilot Sidecar
- Temporary Chat
- Practical ways to use Copilot
Introduction to Microsoft Word Exam
Unit 5 - Intermediate Microsoft Word Training
Lesson 1: Advanced Formatting - Quizzes: 1, Assignments: 3
- Shading and Borders
- Setting Line and Paragraph Spacing
- Changing Styles
- Paragraph Marks and Other Formatting Symbols
- Character Space Options
- Changing the Default Font
- Custom Design Elements
- Editing PDF Documents in Microsoft Word
Lesson 2: Working with Tables - Quizzes: 1, Assignments: 3
- Inserting a Table
- Converting Tables to Text
- Sorting Table Data
- Setting Cell Margins
- Modifying Table Dimensions
- Merging and Splitting Cells
- Applying Formulas to a Table
- Table Styles
- Manipulating Rows, Columns, and Cells
Lesson 3: Working with Images - Quizzes: 1, Assignments: 3
- Inserting Images
- Placing and Sizing Images
- Wrapping Text around an Image
- Adjusting Images
- Borders and Effects
- Using Live Layout and Alignment Guides
Lesson 4: Page Layout - Quizzes: 1, Assignments: 2
- Orientation and Paper Size
- Working with Columns
- Page and Section Breaks
- Adding Titles to Sections
- Hyphenation
- Line Numbers
Lesson 5: Working with Illustrations - Quizzes: 1, Assignments: 5
- Adding and Editing Charts
- Inserting Images
- Using Shapes
- Working with Icons
- 3D Models
- Working with SmartArt
- Using Building Blocks
Lesson 6: Viewing Your Documents - Quizzes: 1, Assignments: 2
- Document Views
- Using the Navigation Pane
- Multiple Windows
- Object Zoom Feature
Intermediate Microsoft Word Exam
Unit 6 - Advanced Microsoft Word Training
Lesson 1: Working with Long Documents - Quizzes: 1, Assignments: 4
- Adding a Table of Contents
- Updating the Table of Contents
- Deleting the Table of Contents
- Cross References
- Footnotes and Endnotes
- Inserting Citations and a Bibliography
- Adding an Index
- Inserting a Table of Figures
- Inserting and Updating a Table of Authorities
- Using Bookmarks
- Go To Feature
Lesson 2: Reviewing and Collaborating on Documents - Quizzes: 1, Assignments: 4
- Adding Comments
- Tracking Changes
- Viewing Changes
- Accepting and Rejecting Changes
- Sharing
Lesson 3: Comparing and Combining Documents - Quizzes: 1, Assignments: 2
- Comparing Documents
- Combining Documents
Lesson 4: Forms - Quizzes: 1, Assignments: 6
- Showing the Developer Tab
Lesson 5: Managing Mailings - Quizzes: 1, Assignments: 2
- Creating Envelopes and Labels
- Using Mail Merge
Lesson 6: Protecting Documents - Quizzes: 1, Assignments: 2
- Marking Documents Final
- Password Protect Word Documents
- Removing Metadata from Files
- Restrict Formatting and Editing
- Adding Watermarks
Lesson 7: Macros - Quizzes: 0, Assignments: 1
Advanced Microsoft Word Exam, Final Microsoft Word Exam
Unit 7 - Introduction to Microsoft PowerPoint Training
Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0
- Logging in to Microsoft 365
- Installing Applications
- Creating New Files and AutoSaving
- Protected View
- File Sharing
- File Collaboration
- Version History
- Getting Updates
- Mac Versions
Lesson 2: Creating a Presentation - Quizzes: 1, Assignments: 1
- Starting Microsoft PowerPoint
- Creating a Presentation
- Saving a Presentation
- The Status Bar
- Closing a Presentation
Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0
- Tabs
- Groups and Commands
- Microsoft Search Box
- Customizing the Ribbon
Lesson 4: The Quick Access Toolbar - Quizzes: 1, Assignments: 1
- Getting Started
- Adding Common Commands
- Adding More Commands with the Customize Dialog Box
- Adding Ribbon Commands or Groups
Lesson 5: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 2
- Introduction to the Backstage View
- Opening a Presentation
- New Presentations and Presentation Templates
- Adding Your Name to Microsoft PowerPoint
Lesson 6: Formatting Presentations - Quizzes: 1, Assignments: 1
- Selecting a Slide Layout
- Adding and Editing Text
- Adding Text from a Text File or Word Outline
- Formatting Text
- Text Effects and WordArt
- Bulleted and Numbered Lists
- Columns
- Adding Slides to a Presentation
- Arranging Slides
Lesson 7: Working with Images - Quizzes: 1, Assignments: 1
- Adding Images to a Slide
- Removing an Image Background
- Picture Format Tools Tab
- Grouping and Ungrouping Images
- Arranging Images
- Adding Shapes
- Working with Icons
- 3D Models
- Using Digital Ink
Lesson 8: Working with Tables and Charts - Quizzes: 1, Assignments: 2
- Inserting a Table
- Formatting Tables
- Importing Tables from External Sources
- Inserting a Chart
- Formatting a Chart
- Importing Charts from External Sources
Lesson 9: Preparing and Presenting - Quizzes: 1, Assignments: 2
- Checking Spelling
- Accessing Different Views of a Presentation
- Running the Slide Show
- Organizing a Presentation in Sections
- Adding Transitions to Slides
- Adding Speaker Notes
- Printing a Presentation
Lesson 10: Using Copilot in Microsoft PowerPoint - Quizzes: 1, Assignments: 1
- Copilot in Microsoft 365 PowerPoint
- Creating a New Presentation
- Creating New Slides
- Summarizing Large Amounts of Content
- Branding a Deck
Introduction to Microsoft PowerPoint Exam
Unit 8 - Advanced Microsoft PowerPoint Training
Lesson 1: Customizing Presentations - Quizzes: 1, Assignments: 1
- Applying a Theme
- Formatting Backgrounds
- Headers and Footers
- Adding a Background Image
Lesson 2: Presentation Masters - Quizzes: 1, Assignments: 1
- Working with the Slide Master
- Slide Layouts
- Formatting Slide Masters and Layouts
- Adding a Watermark to Your Presentation
- Adding Slide Numbers Using the Slide Master
- Inserting a New Slide Master
- Removing Unused Slide Masters and Layouts
- Modifying the Notes Master
- Modifying the Handout Master
Lesson 3: Working with Special Effects - Quizzes: 1, Assignments: 1
- Animating Bullets
- Working with the Animation Painter
- Motion Paths
- Animating a Chart
- Slide Transitions
Lesson 4: Using SmartArt - Quizzes: 1, Assignments: 1
- Inserting SmartArt Graphics
- Modifying SmartArt Graphics
- Resizing/Repositioning a SmartArt Object
- Inserting Text into a SmartArt Object
- Adding Shapes to a SmartArt Object
- Ungrouping SmartArt Objects
Lesson 5: Multimedia - Quizzes: 1, Assignments: 2
- Creating a Photo Album
- Editing a Photo Album
- Inserting Sounds and Video
- Editing Media Clips
Lesson 6: Setting up the Slide Show - Quizzes: 1, Assignments: 2
- Setting up a Custom Slide Show
- Creating a Hyperlink
- Adding an Action Button
- Zoom
- Using Rehearse Timings
- Navigating within a Slide Show
- Annotating a Presentation
- Recording a Slide Show
Lesson 7: Outlines and Slides - Quizzes: 1, Assignments: 1
- Exporting Handouts to Word
- Exporting an Outline to Word
- Saving a Presentation as an Outline
- Saving a Slide as a Graphic
Lesson 8: Managing Multiple Presentations - Quizzes: 1, Assignments: 1
- Merging Multiple Presentations
- Viewing Multiple Presentations
- Tracking Changes in PowerPoint
- Adding Comments
Lesson 9: Finalizing Presentations - Quizzes: 1, Assignments: 0
- Inspecting a Presentation
- Encrypting a Presentation
- Embedding the Fonts in a Presentation
- Saving a Presentation in PDF Format
- Compressing Pictures
- Marking a Presentation as Final
Advanced Microsoft PowerPoint Exam, Final Microsoft PowerPoint Exam
Unit 9 - Introduction to Microsoft Outlook 365 Training
Lesson 1: The Outlook Interface - Quizzes: 1, Assignments: 0
- Overview of the Outlook Interface
- The Ribbon
- Review of Differences Between Classic and New Layouts
Lesson 2: Working with Messages - Quizzes: 1, Assignments: 1
- Compose a Message
- Add an Attachment
- Add Polling Options
- Check Spelling and Grammar
- Format Text
- Insert a Hyperlink or Image in a Message
- Send a Message
Lesson 3: Working with the Calendar - Quizzes: 1, Assignments: 2
- Change Your Calendar View
- Set Up Availability Status
- Print Your Schedule
- Share Your Calendar
- Schedule a Meeting
- Make Updates to Meetings
- Cancel a Meeting
- View Others’ Calendars
- Delete a Calendar
- Work with Calendar Items
- Create and Add Calendars
Lesson 4: Organizing Contacts - Quizzes: 1, Assignments: 1
- Add, Delete, and Import/Export a Contact
- Update a Contact
- Locate a Contact
- Sort Contacts
- Work with Contact Lists
- Manage Multiple Address Books
Lesson 5: Working with Groups - Quizzes: 1, Assignments: 1
- Search for a Group
- Create a Group
- Add or Remove Members
- Send Email to a Group
Lesson 6: Using Copilot in Microsoft Outlook
- Copilot in Microsoft 365 Outlook
- Emails
- Meetings
Introduction to Microsoft Outlook 365 Exam
Unit 10 - Advanced Microsoft Outlook 365 Training
Lesson 1: Performing Popular Tasks - Quizzes: 1, Assignments: 3
- Open Email Messages
- Reply to and Forward Email Messages
- Preview and Save an Attachment
- Print a Message
- Delete a Message
- Save a Message in an Alternate Format
- Customize the Navigation Pane
Lesson 2: Working with Tasks and Notes - Quizzes: 1, Assignments: 1
- Create a Task
- Print a Task
- Add Steps to a Task
- Update a Task
- Search for Tasks
- Change Your Task View
Lesson 3: Using Signature and Themes - Quizzes: 1, Assignments: 1
- Create a Signature
- Automatically Add a Signature to Messages
- Modify a Signature
- Format Outgoing Messages
Lesson 4: Managing Your Inbox - Quizzes: 1, Assignments: 2
- Search for Messages
- Sort Messages
- Add New Local Folders
- Move Messages between Folders
- Group Your Mailbox Items
- Filter Messages
- Organize Messages
- Create and Manage Rules
- Manage Your Junk Email
- Archive Your Messages
- Create a Quick Step
- Create Auto-Replies
Lesson 5: Working with Multiple Email Accounts - Quizzes: 1, Assignments: 1
- Setting Up Multiple Accounts in Outlook
- Send Emails from Different Accounts
- POP vs. IMAP Email Protocols
Advanced Microsoft Outlook 365 Exam, Microsoft Outlook 365 Final Exam
Advanced Microsoft Access 365 Exam, Final Microsoft Excel Exam, Final Microsoft PowerPoint Exam, Final Microsoft Word Exam, Microsoft Access 365 Final Exam, Microsoft Outlook 365 Final Exam