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
Unit 11 - Introduction to Microsoft Access 365 Training
Lesson 1: Databases and Access Terms - Quizzes: 0, Assignments: 2
- Database Defined
- Databases vs. Spreadsheets
- Access vs. Excel
- Relational Database Defined
- Relational Database Management System (RDBMS) Defined
- Access is an RDBMS
- Creating a Relationship
- Benefits and Limitations of Access
Lesson 2: Quick Overview Access Interface - Quizzes: 1, Assignments: 1
- Access Ribbon
- Quick Access Toolbar
- Object Navigation Pane
- Access Work Surface
- Object Overview
- Process Overview
- Create a Database Using a Wizard
Lesson 3: Fundamentals - Quizzes: 1, Assignments: 3
- Questions to Ask Before You Start
- Approaches to Database Design
- Gather Information
- A Few Words about Naming Conventions
- Normalization
- Table Relationships
Lesson 4: Tables and Their Views - Quizzes: 1, Assignments: 1
- Definition and Purpose
- Datasheet View
- Import a Table of Data
- Design View
Lesson 5: Tables - Quizzes: 1, Assignments: 3
- Creating an Access Database
- Data Types
- Create a Table in Design View
- Link a Table of Data
Lesson 6: Queries - Quizzes: 1, Assignments: 1
- Queries
- Select Queries
- Select Queries with Criteria
- Logical Operators
- Group and Total with Queries
Lesson 7: Forms - Quizzes: 1, Assignments: 2
- Forms
- Alter a Form
- Form Record Navigation
- Layout View and Design View
- One-Click Forms
- Form Wizard
Lesson 8: Reports - Quizzes: 1, Assignments: 1
Introduction to Microsoft Access 365 Exam
Unit 12 - Advanced Microsoft Access 365 Training
Lesson 1: Relationships - Quizzes: 1, Assignments: 1
- Reviewing Data Normalization and Table Relationships
- Relationships
- Referential Integrity
- A Few Words about Naming Conventions
Lesson 2: Advanced Queries - Quizzes: 1, Assignments: 2
- Query Design View
- Review of Select Queries
- Review of Select Queries with Criteria
- Logical Operators
- Parameter Queries
- Action Queries
Lesson 3: Table Functions - Quizzes: 1, Assignments: 2
- Importing Data
- Linking Tables from External Sources
- Import Tables from Other Databases
- Tables from Templates and Application Parts
- Exporting Data
Lesson 4: Advanced Forms - Quizzes: 1, Assignments: 1
- Design View
- Formatting
- Tab Order and Properties
- Create Forms with Application Parts
- Creating a Subform
- Alter a Form
Lesson 5: Advanced Reports - Quizzes: 1, Assignments: 1
- Design View
- Report Sections
- Arranging Fields on a Report
- Resizing the Detail Section
- Grouping and Sorting
- Setting Properties on a Report
- Special Report Fields
- Controls
- SubReports
- Application Parts
- Deleting a Report
- Formatting a Report
Lesson 6: Macros - Quizzes: 1, Assignments: 1
- Macro Basics
- Running a Macro
Lesson 7: Completing the Desktop Application - Quizzes: 1, Assignments: 1
- The Navigation Form
- Running Macros from a Navigation Form
- Setting the Navigation Form as the Default Form
- Splitting the Database
- Distributing the Front-End Database
- Database Maintenance
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