Microsoft Courses – Integrated IT Training

Check your understanding 1
Check your understanding 2
Check your understanding 3
Check your understanding 4
Check your understanding 5
Check your understanding 6
Check your understanding 7
Course Completion

Mastering Word 365 – Expert (2024)

Module 01: Introduction

Module 02: Customizing Word and Managing Templates

Module 03: Customizing the Table of Contents

Module 04: Mastering Font Options

Module 05: Managing Styles

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 06: Advanced Find, Watermarks, and Cover Pages

Module 07: Quick Parts and Building Blocks

Module 08: Custom Dictionary and Automatic Corrections

Module 09: Customize Footnotes, Headers, Footers, and Columns

Module 10: Text Boxes and Fields

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 11: Protect Documents

Module 12: Restrict Access and Share

Module 13: Signatures

Module 14: Compare Documents and Versions

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 15: Mastering Graphics

Module 16: Editing with a Pen

Module 17: Forms

Module 18: Set Up Mail Merge

Module 19: Perform Mail Merges

Check Your Understanding 10
Check Your Understanding 11
Check Your Understanding 12
Course Completion

Mastering PowerPoint 365 – Basics (2024)

Module 01: Introduction

Module 02: Creating and Printing a New Presentation

Module 03: Opening and Saving a Presentation

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 04: Modifying a Presentation’s Design

Module 05: Formatting Text

Module 06: Formatting Textbox Placeholders

Module 07: Customizing Bulleted Lists

Module 08: Customizing Numbered Lists

Module 09: Using the Spell Checker

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 10: Customizing Pictures

Module 11: Modifying Tables

Check Your Understanding 7
Check Your Understanding 8

Module 12: Adding Transitions and Animation

Module 13: Presenting a Presentation

Check Your Understanding 9
Check Your Understanding 10
Course Completion

Mastering PowerPoint 365 – Beginner (2024)

Module 01: Introduction

Module 02: Navigating the PowerPoint Interface

Module 03: Using the Backstage Area

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 04: Creating a Presentation

Module 05: Adding Text to a Slide

Module 06: Copying and Pastin

Module 07: Saving a PowerPoint File

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 08: Inserting a Picture

Module 09: Adding Shapes

Module 10: Inserting a Table

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9
Course Completion

Microsoft Power Automate – Basics (2024)

Module 01: Introduction

Module 02: Power Automate Overview

Module 03: Templates and Flows

Module 04: Automated Cloud Flows

Module 05: Scheduled Cloud Flow

Module 06: Instant Cloud Flows

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 07: Error Handling

Module 08: Flow Management

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6
Course Completion

Microsoft Power Automate – Advanced (2024)

Module 01: Introduction

Module 02: Introduction to Expressions

Module 03: Using Expressions

Module 04: Using Variables

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 05: Condition Actions

Module 06: Trigger Settings

Module 07: If Functions and Switch Control

Module 08: Parallel Branches

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6
Course Completion

OneDrive Essentials (2024)

Module 01: Introduction to OneDrive

Module 02: What is OneDrive?

Module 03: Accessing OneDrive

Module 04: Using OneDrive

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 05: Sharing

Module 06: Recycle Bin

Module 07: Sync and Files on Demand

Module 08: Files and File Types

Module 09: Version History

Module 10: Co-Authoring

Module 11: Links, Favorites, and Quick Access

Module 12: OneDrive vs. SharePoint and Teams

Check your understanding 4
Check your understanding 5
Check your understanding 6
Check your understanding 7
Course Completion

OneDrive In 30 Minutes (2024)

Module 01: Introduction to OneDrive

Module 02: What is OneDrive?

Module 03: Accessing OneDrive

Module 04: Using OneDrive

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 05: Recycle Bin

Module 06: Version History

Module 07: OneDrive vs. SharePoint and Teams

Check Your Understanding 4
Check Your Understanding 5
Course Completion

SharePoint Online Basics (2024)

Module 01: Introduction

Module 02: Introduction to SharePoint Online

Module 03: Creating Team Sites

Module 04: Adding Document Libraries and Lists

Module 05: Creating Communication Sites

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 06: Adding Pages

Module 07: Managing Lists and Libraries

Check Your Understanding 4
Check Your Understanding 5
Course Completion

Mastering Outlook 365 – Expert (2024)

Module 01: Introduction

Module 02: Customize Options

Module 03: Customize Views

Module 04: Send/Receive Settings

Module 05: Manage Accounts

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 06: Add-ins

Module 07: Templates

Check Your Understanding 4
Check Your Understanding 5

Module 08: Shared Email Folders

Module 09: Advanced Search and Filter

Module 10: Clean Up Email

Module 11: Flags and Follow-up

Module 12: Calendar Options

Module 13: Share Contacts

Check Your Understanding 6
Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9
Course Completion

Mastering Outlook 365 – Beginner (2024)

Module 01: Introduction

Module 02: Navigate Outlook

Module 03: Get Help with Outlook

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 04: Compose and Send Emails

Module 05: Read and Reply to Emails

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 06: View and Navigate the Calendar

Module 07: Create Outlook Contacts

Module 08: Create Outlook Tasks

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9
Course Completion

Mastering Excel 365 – Basics (2024)

Module 01: Introduction

Module 02: Open and Save a Workbook

Module 03: Modifying Rows and Columns, Part 1

Module 04: Modifying Rows and Columns, Part 2

Module 05: Managing Worksheets, Part 1

Module 06: Managing Worksheets, Part 2

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 07: Using Absolute References

Module 08: Creating Named Ranges

Module 09: Using Named Ranges in Functions

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 10: Working with IF Functions

Module 11: Working with Logical Functions

Module 12: Creating Functions Based on Conditions

Module 13: Tracing Formulas

Module 14: Addressing Formula Errors

Module 15: Aligning Cell Contents

Module 16: Adding Borders and Shading

Module 17: Applying Number and Date Formats

Module 18: Using Format Painter

Module 19: Applying Cell Styles and Themes

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 20: Changing Chart Types

Module 21: Changing Chart Source Data

Module 22: Creating a Table

Module 23: Creating a PivotTable

Check Your Understanding 10
Check Your Understanding 11
Check Your Understanding 12

Module 24: Setting Page Layout Options

Module 25: Changing Page Breaks and Scaling

Module 26: Configuring Headers and Footers

Check Your Understanding 13
Check Your Understanding 14
Check Your Understanding 15
Course Completion

Mastering Excel 365 – Beginner (2024)

Module 01: Introduction

Module 02: Navigating Excel

Module 03: Using Commands

Module 04: Selecting Data

Check Your Understanding 1
Check Your Understanding 2

Module 05: Creating a New Workbook

Module 06: Entering Cell Data

Module 07: Using AutoFill

Module 08: Getting Help

Check Your Understanding 3
Check Your Understanding 4

Module 09: Creating Formulas

Module 10: Inserting Functions

Module 11: Copying Formulas and Functions

Check Your Understanding 5
Check Your Understanding 6

Module 12: Applying Text Formats

Module 13: Applying Cell Styles

Module 14: Applying Basic Conditional Formatting

Module 15: Printing Workbooks

Check Your Understanding 7
Check Your Understanding 8

Module 16: Creating Charts

Module 17: Inserting Graphics

Check Your Understanding 9

Module 18: Sorting Data

Module 19: Filtering Data

Check Your Understanding 10
Check Your Understanding 11
Course Completion

Mastering Word 365 – Intermediate (2023)

Module 01: Introduction

Module 02: Layouts and Navigation Pane

Module 03: Managing Multiple Documents

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 04: Find and Replace

Module 05: Paste Special

Module 06: Lists

Module 07: Indents and Tabs

Module 08: Text Effects, Borders, and Shading

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 09: Margins, Columns, and Orientation

Module 10: Line and Paragraph Options

Module 11: Page and Section Breaks

Module 12: Footnotes and Endnotes, Page Borders, Colors

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 13: Use Tables

Module 14: Cell Formatting and Draw Tables

Check Your Understanding 10
Check Your Understanding 11

Module 15: Track Changes

Module 16: Comments and Co-Authoring

Check Your Understanding 12
Check Your Understanding 13

Module 17: Insert Graphics

Module 18: Insert Captions and Table of Contents

Check Your Understanding 14
Check Your Understanding 15
Course Completion

Mastering Word 365 – Advanced (2023)

Module 01: Introduction

Module 02: Backstage Features

Module 03: Sharing

Module 04: Outline and Master Document Views

Module 05: AutoText

Module 06: Modifying Themes and Columns

Module 07: Spelling, Grammar, and Accessibility Options

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 08: Advanced Graphics

Module 09: Advanced SmartArt and Shapes

Module 10: Advanced Image Editing and Videos

Module 11: Table Calculations and Styles

Module 12: Link and Embed Tables

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 13: Translation

Module 14: Table of Contents and Bibliography

Module 15: Bookmarks and Hyperlinks

Module 16: Indexes, Cross-References, and a Table of Authorities

Module 17: Macros

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9
Course Completion

Mastering PowerPoint 365 – Expert (2023)

Module 01: Introduction

Module 02: Comparing Presentations

Module 03: PowerPoint Add-Ins

Check Your Understanding 1
Check Your Understanding 2

Module 04: The Outline Pane and Font Sets

Module 05: Macros and ActiveX Controls

Check Your Understanding 3
Check Your Understanding 4

Module 06: Mastering Slide Masters

Module 07: Customize Layouts

Module 08: Notes & Handout Master

Check Your Understanding 5
Check Your Understanding 6

Module 09: Objects, Inking, and Picture Editing

Module 10: WordArt, Icons, and Equations

Check Your Understanding 7
Check Your Understanding 8

Module 11: Animation, Action Buttons, and Video

Module 12: Manage Video

Check Your Understanding 9
Check Your Understanding 10

Module 13: Custom Slide Shows

Module 14: Finishing Touches

Module 15: Maximize Presenter View

Module 16: Master Transitions

Module 17: Rehearse & Record Slide Show

Check Your Understanding 11
Check Your Understanding 12

Module 18: Accessibility

Module 19: Saving Videos, Images, & Animated GIFs

Module 20: Sharing & Collaborating on a Presentation

Check Your Understanding 13
Check Your Understanding 14
Course Completion

Mastering PowerPoint 365 - Advanced (2023)

Module 01: Introduction

Module 02: Print Options

Module 03: Customize the Ribbon

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 04: PowerPoint Options and Views

Module 05: Backstage and Versioning

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 06: AutoCorrect, Symbols, and Translate

Module 07: Find, Replace, and Replace Fonts

Module 08: Paste Options and the Clipboard

Module 09: WordArt and Text Orientation

Module 10: Slides from Microsoft Word

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 11: Shapes and Effects

Module 12: Screenshots and Pictures

Module 13: Selection Pane, Layers, and 3D Models

Check Your Understanding 10
Check Your Understanding 11

Module 14: Table and Chart Styles

Module 15: Chart Elements and Formatting

Module 16: Link and Embed Objects

Check Your Understanding 12
Check Your Understanding 13
Check Your Understanding 14

Module 17: Working with Animation

Module 18: The Animation Pane

Module 19: Animation Effects and Motion Paths

Check Your Understanding 15
Check Your Understanding 16
Check Your Understanding 17

Module 20: Insert Video

Module 21: Insert Audio

Check Your Understanding 18
Check Your Understanding 19

Module 22: Slide Masters

Module 23: Custom Themes and Templates

Module 24: Design Ideas and Grayscale

Check Your Understanding 20
Check Your Understanding 21
Check Your Understanding 22

Module 25: Slide Transitions and Timings

Module 26: Slide Show Options

Module 27: Sections and Bookmarks

Check Your Understanding 23
Check Your Understanding 24
Course Completion

Microsoft Planner Essentials (2023)

Module 01: Introduction

Module 02: Intro to Planner

Module 03: Working with Cards Part 1

Module 04: Working with Cards Part 2

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 05: Organizing with Buckets

Module 06: Managing My Plans

Module 07: Integration with Microsoft 365 Apps

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6
Course Completion

Mastering Excel 365 - Expert (2023)

Module 01: Introduction

Module 02: Collaborating and Co-Authoring

Module 03: Digital Signatures

Module 04: Get and Transform Data

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 05: Map Charts

Module 06: 3D Maps

Module 07: Waterfall, Treemap, and Funnel Charts

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 08: PivotTable Options

Module 09: Summarize Data in a PivotTable (Part 1)

Module 10: Summarize Data in a PivotTable (Part 2)

Module 11: PivotCharts

Module 12: Data Models

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 13: Named Ranges

Module 14: Creating Internal Links

Module 15: Creating External Links

Module 16: INDEX, MATCH, and Sparklines

Module 17: Date Functions

Module 18: Information Functions

Module 19: LAMBDA and LET

Module 20: Financial Functions

Module 21: Watch and Evaluate Formulas

Check Your Understanding 10
Check Your Understanding 11
Check Your Understanding 12

Module 22: Forecast Data Trends

Module 23: Using Scenarios

Module 24: Use Solver

Module 25: Data Analysis ToolPack

Check Your Understanding 13
Check Your Understanding 14
Check Your Understanding 15

Module 26: Record a Macro

Module 27: Run a Macro

Module 28: Edit a Macro

Module 29: Forms

Check Your Understanding 16
Check Your Understanding 17
Check Your Understanding 18

Module 30: Customize the Ribbon

Module 31: Excel Options

Module 32: Custom Lists

Module 33: Linked Data Types

Module 34: Add-ins

Check Your Understanding 19
Check Your Understanding 20
Check Your Understanding 21

Mastering Excel 365 - Advanced (2023)

Module 01: Introduction

Module 02: File Types

Module 03: Templates

Module 04: Customizing the QAT

Check Your Understanding 1
Check Your Understanding 2

Module 05: Dynamic Arrays

Module 06: VLOOKUP

Module 07: XLOOKUP, Part 1

Module 08: XLOOKUP, Part 2

Module 09: MATCH, INDEX

Module 10: Multiple Criteria Functions

Module 11: Text Functions

Module 12: Date Functions

Module 13: Time Formulas

Module 14: Math Functions

Module 15: Database Functions

Check Your Understanding 3
Check Your Understanding 4
Check Your Understanding 5

Module 16: Advanced Filtering

Module 17: Advanced Sorting

Module 18: Data Validation

Module 19: Data Validation Lists

Module 20: Data Validation Messages and Invalid Data

Module 21: Form Controls

Check Your Understanding 6
Check Your Understanding 7

Module 22: Subtotal Function

Module 23: Subtotal Feature

Module 24: Data Consolidation

Check Your Understanding 8
Check Your Understanding 9

Module 25: Manage PivotTables

Module 26: Report Filter, Slicers, and Timelines

Module 27: Run a Macro

Check Your Understanding 10
Check Your Understanding 11

Module 28: Customize Charts

Module 29: Combo Charts

Module 30: Trendlines

Module 31: Chart Templates

Check Your Understanding 12
Check Your Understanding 13

Module 32: Screenshots, Symbols, 3D Models

Module 33: Format Graphics, Part 1

Module 34: Format Graphics, Part 2

Module 35: Manipulate Graphic Objects

Check Your Understanding 14
Check Your Understanding 15

Module 36: Accessibility Checker

Module 37: Modifying Hyperlinks

Module 38: Protecting Sheets and Workbooks

Module 39: Protecting Ranges

Module 40: Protecting a Workbook File

Module 41: Digital Signatures

Module 42: Sheet Views

Check Your Understanding 16
Check Your Understanding 17
Course Completion

Microsoft Sway Essentials (2023)

Module 01: Introduction

Module 02: What is Sway?

Module 03: Starting a Sway

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 04: Inserting Text

Module 05: Adding Graphics and Video

Module 06: Designing Your Sway

Module 07: Viewing and Sharing

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Mastering Outlook 365 - Intermediate (2023)

Module 01: Introduction

Module 02: Attach and Link Items

Module 03: Review and Proof Messages

Module 04: Message Options

Module 05: Signatures

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 06: Manage Messages and Conversations

Module 07: Categories

Module 08: Automatic Replies

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 09: Calendar Settings

Check Your Understanding 7
Check Your Understanding 8

Module 10: Teams Meetings

Module 11: New Tasks

Module 12: Manage Tasks

Module 13: Share Tasks

Module 14: Notes

Check Your Understanding 9
Check Your Understanding 10
Check Your Understanding 11
Course Completion

Mastering Outlook 365 - Advanced (2023)

Module 01: Introduction

Module 02: Set Up an Account

Module 03: Data Files

Module 04: Customize the Environment

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 05: Calendars, Tables, and Illustrations

Module 06: Text and Drawing Features

Module 07: Voting Buttons and Polls

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 08: Quick Steps

Module 09: Rules and Alerts

Module 10: Junk Mail Options

Module 11: Manage the Inbox

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 12: Share and Delegate

Module 13: Calendar Groups

Module 14: Contacts and Meetings

Check Your Understanding 10
Check Your Understanding 11
Check Your Understanding 12
Course Completion

Brain Bites - Microsoft Teams Meetings (2023)

Module 01: Joining a Meeting

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 02: Nine Ways to Start a Meeting, Part 1

Module 03: Nine Ways to Start a Meeting, Part 2

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 04: Participating in a Meeting

Module 05: Sharing in a Meeting

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 06: Teams Meetings Best Practices

Course Completion

Microsoft Forms Essentials (2022)

Module 01: Creating Forms

Module 02: Sharing Forms and Responses

Module 03: Quizzes and Polls

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Course Completion

Mastering Microsoft 365 (2022)

Module 01: Intro to Microsoft 365

Module 02: Home Screen

Module 03: Navigation Bar

Module 04: Microsoft Search

Module 05: Accessing Help

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module06: Outlook Email Basics, Part 1

Module 07: Outlook Email Basics, Part 2

Module 08: Email Search and Filters

Module 9: Email Folders

Module 10: Categories and Mentions

Module 11: Focused Inbox and Clutter

Module12: Sweep and Rules

Module 13: Email Archive

Module 14: Email Signatures

Module 15: Automatic Replies

Check Your Understanding 4

Module 16: To Do and Flagged Emails

Module 17: To Do and My Day

Module 18: Outlook Calendar Basics

Module19: Adding Calendar Events, Part 1

Module 20: Adding Calendar Events, Part 2

Module 21: Calendar, Search, and Print

Module 22: Sticky Notes

Module 23: Calendar Board View, Part 1

Module 24: Calendar Board View, Part 2

Module 25: People (Contacts)

Module 26: Contact Lists and Address Books

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 27: Sharing Calendars, Part 1

Module 28: Sharing Calendars, Part 2

Module 29: Group Calendars and Shared Mailboxes

Module 30: Publish and Export Calendars

Module 31: Delegate Access

Module 32: Share Email Folders

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Module 33: Introduction to OneDrive

Module 34: Using OneDrive Online, Part 1

Module 35: Using OneDrive Online, Part 2

Module 36: Using OneDrive Online, Part 3

Module 37: OneDrive and Office Apps

Module 38: OneDrive Sync

Module 39: OneDrive Files On-Demand

Module 40: OneDrive Sharing

Module 41: OneDrive Co-Authoring

Module 42: OneDrive Versioning and Backup

Module 43: OneDrive Recycle Bin

Check Your Understanding 13

Module 44: Intro to Groups

Module 45: Conversations in Groups

Module 46: Groups Calendar

Module 47: Files in Groups, Part 1

Module 48: Files in Groups, Part 2

Module 49: Recommendations

Module 50: Managing Groups

Check Your Understanding 16

Check Your Understanding 17

Module 51: Teams and Channels

Module 52: Tags and Notifications

Module 53: Chat, Calls, and Meetings

Module 54: Best Practices - Teams and Channels

Module 55: Best Practices - Notifications and Tagging

Module 56: Best Practices - Conversations and Meetings

Module 57: Best Practices - Files

Check Your Understanding 18

Check Your Understanding 19

Check Your Understanding 20

Module 58: Intro to Planner

Module 59: Working with Cards, Part 1

Module 60: Working with Cards, Part 2

Module 61: Working with Buckets and To Do

Module 62: Managing My Plans

Module 63: Tasks by Planner and To Do

Check Your Understanding 21

Check Your Understanding 22

Check Your Understanding 23

Check Your Understanding 24

Module 64: Intro to SharePoint

Module 65: Creating a Team Site

Module 66: Communication Sites

Module 67: Adding Pages

Check Your Understanding 25

Check Your Understanding 26

Module 68: Creating Forms

Module 69: Sharing Forms and Responses

Module 70: Quizzes and Polls

Check Your Understanding 27

Check Your Understanding 28

Check Your Understanding 29

Module 71: Rules and Policies, Part 1

Module 72: Rules and Policies, Part 2

Module 73: Advanced Email Settings

Check Your Understanding 30

Check Your Understanding 31

Module 74: Office Apps

Module 75: Mobile Apps

Module 76: Lens

Module 77: App Store and Add-Ins

Module 78: Lists

Module 79: Yammer, Part 1

Module 80: Yammer, Part 2

Module 81: Power Platform, Part 1

Module 82: Power Platform, Part 2

Module 84: Stream

Check Your Understanding 32

Check Your Understanding 33

Check Your Understanding 34

Module 86: Kaizala, Part 2

Module 87: Delve

Module 88: My Analytics

Check Your Understanding 35

Check Your Understanding 36

Check Your Understanding 37

Course Completion

Microsoft 365 Sharing Calendars And Email (2022)

Module 01: Sharing Calendars Part 1

Module 02: Sharing Calendars Part 2

Module 03: Group Calendars and Shared Mailboxes

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 04: Publish and Export Calendars

Module 05: Delegate Access

Module 06: Share Email Folders

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Course Completion

Microsoft 365 To Do, Calendar, And People Essentials (2022)

Module 01: To Do and Flagged Emails

Module 02: To Do and My Day

Check Your Understanding 1

Check Your Understanding 2

Module 03: Calendar Basics

Module 04: Adding Calendar Events, Part 1

Module 05: Adding Calendar Events, Part 2

Module 06: Calendar, Search, and Print

Module 07: Sticky Notes

Check Your Understanding 3

Check Your Understanding 4

Module 08: Calendar Board View, Part 1

Module 9: Calendar Board View, Part 2

Module 10: People (Contacts)

Module 11: Contact Lists and Address Books

Check Your Understanding 5

Check Your Understanding 6

Check Your Understanding 7

Course Completion

Brain Bites - Windows 11 Essentials

Module 01: Introduction to Windows 11

Module 02: Taskbar and Start Menu

Module 03: Taskbar Corner

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Check Your Understanding 4

Module 04: Snap, Task View, and Virtual Desktop

Module 05: File Explorer and Quick Access

Check Your Understanding 5

Check Your Understanding 6

Check Your Understanding 7

Module 06: Windows Apps

Module 07: Customization and Settings

Check Your Understanding 8

Check Your Understanding 9

Check Your Understanding 10

Course Completion

OneDrive In 30 Minutes (2021)

Module 01: Introduction to OneDrive

Module 02: Using OneDrive Online, Part 1

Module 03: Using OneDrive Online, Part 2

Module 04: OneDrive Sharing

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Microsoft 365 Email Essentials (2021)

Module 1: Outlook Email Basics, Part 1

Module 2: Outlook Email Basics, Part 2

Module 3: Email Search and Filters

Module 4: Email Folders

Check Your Understanding 1

Check Your Understanding 2

Categories and Mentions

Focused Inbox and Clutter

Sweep and Rules

Module 5: Email Archive

Check Your Understanding 3

Check Your Understanding 4

Module 6: Email Signatures

Automatic Replies

Check Your Understanding 5

Check Your Understanding 6

Course Completion

Intro To Microsoft 365

Module 01: Intro to 365

Module 02: Home Screen

Module 03: Navigation Bar

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Check Your Understanding 4

Module 04: Microsoft Search

Module 05: Accessing Help

Check Your Understanding 5

Check Your Understanding 6

Check Your Understanding 7

Course Completion

Learning PowerPoint 2019 - Expert (TOSA)

Module 01: View and Navigate a Presentation

Module 02: Create and Save

Module 03: Managing Different Modes of Compatibility

Module 04: Setting Windows Options

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 05: Editing Text

Module 06: Arranging Slides

Module 07: Working with Themes

Module 08: Formatting Characters

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 9: Insert and Edit Shapes

Module 10: Inserting SVGs and Icons

Module 11: Edit Pictures

Module 12: Picture Styles

Module 13: Arrange Objects

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 14: Table Design

Module 15: Review Your Presentation

Module 16: Apply Transitions

Module 17: Exporting Presentations

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Module 18: Setting PowerPoint Options

Module 19: Modifying Slide Masters, Part 1

Module 20: Modifying Slide Masters, Part 2

Module 21: Modifying Notes and Handout Masters

Module 22: Writing Math Equations

Check Your Understanding 13

Check Your Understanding 14

Module 23: Editing Audio

Module 24: Editing Video

Module 25: Customizing Animations

Module 26: Inserting Action Buttons

Check Your Understanding 15

Check Your Understanding 16

Check Your Understanding 17

Module 27: Using the Zoom Feature

Module 28: Using Compare and Merge

Annotating a Presentation

Module 29: Using Presenter View

Module 30: Using Set Up Slide Show

Module 31: Creating a Custom Show

Module 32: Linking to a Slide

Module 33: Recording a Presentation, Part 1

Module 34: Recording a Presentation, Part 2

Module 35: Securing a Presentation

Module 36: Rehearsing with Presenter Coach

Module 37: Using Office Add-ins

Check Your Understanding 18

Check Your Understanding 19

Check Your Understanding 20

Course Completion

Microsoft Groups Essentials (2021)

Module 01: Intro to Microsoft Groups

Module 02: Conversations in Groups

Module 03: Groups Calendar

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 04: Files in Groups, Part 1

Module 05: Files in Groups, Part 2

Module 06: Groups Connectors

Module 07: Managing Groups

Check Your Understanding 4

Check Your Understanding 5

Course Completion

Learning PowerPoint 2019 - Advanced (TOSA)

Module 01: The PowerPoint Interface

Module 02: View and Navigate a Presentation

Module 03: Recovering an Earlier Version of a Presentation

Module 04: Customizing the Ribbon

Module 05: Customizing the Interface

Module 06: Slideshow Options

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 07: Editing Text, Part 1

Module 08: Editing Text, Part 2

Module 9: Formatting Characters

Module 10: Alignment and Spacing

Module 11: Text Options

Module 12: Using Find and Replace

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 13: Insert Images

Module 14: Edit Pictures

Module 15: Align Objects

Module 16: Group Objects

Module 17: Arrange Objects

Module 18: Animate Objects, Part 1

Animate Objects, Part 2

Module 19: Inserting 3D Models

Module 20: Inserting SVGs and Icons

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 21: Table Design

Module 22: Insert a Table from Other Applications

Module 23: New Chart Types

Module 24: Designing a Chart

Module 25: Formatting a Chart

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Module 26: Review Your Presentation, Part 1

Module 27: Review Your Presentation, Part 2

Module 28: Printing Your Presentation

Check Your Understanding 13

Check Your Understanding 14

Check Your Understanding 15

Module 29: Using Translation and Dictation

Module 30: Apply Transitions

Module 31: Morph Transition

Module 32: Modifying Slide Masters, Part 1

Module 33: Modifying Slide Masters, Part 2

Module 34: Inserting Headers and Footers

Check Your Understanding 16

Check Your Understanding 17

Module 35: Adding Audio

Module 36: Adding Video

Module 37: Animating with Bookmarks

Module 38: Adding Hyperlinks

Module 39: Inserting Sections

Module 40: Using Presenter View

Check Your Understanding 18

Check Your Understanding 19

Check Your Understanding 20

Course Completion

Learning PowerPoint 2019 - Productive (TOSA)

Module 01: View and Navigate a Presentation

Module 02: Create and Save

Module 03: Working with Themes

Module 04: Formatting Characters

Module 05: Alignment and Spacing

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 06: Text Options

Module 07: Setting Tab Stops

Module 08: Using Find and Replace

Module 09: Format Text Boxes

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 10: Insert Images

Module 11: Insert and Edit Shapes

Module 12: Working with Images, Icons, and Pictures

Module 13: Inserting and Modifying Complex Shapes

Module 14: Edit Pictures

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 15: Arrange Objects

Module 16: Align Objects

Module 17: Animate Objects, Part 1

Module 18: Animate Objects, Part 2

Module 19: Creating SmartArt

Module 20: Modifying SmartArt

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Module 21: Table Design

Module 22: Creating a Chart

Check Your Understanding 13

Check Your Understanding 14

Module 23: Review Your Presentation

Module 24: Printing Your Presentation

Module 25: Exporting Presentations

Module 26: Apply Transitions

Module 27: Adding Comments

Check Your Understanding 15

Check Your Understanding 16

Check Your Understanding 17

Module 28: Delivering Your Presentation

Module 29: Using Presenter View

Module 30: Using Set Up Slide Show

Check Your Understanding 18

Check Your Understanding 19

Check Your Understanding 20

Course Completion

Learning PowerPoint 2019 - Basics (TOSA)

Module 01: The PowerPoint Interface

Module 02: View and Navigate a Presentation

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 03: Slideshow Options

Module 04: Create and Save

Module 05: Select a Presentation Type

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 06: Editing Text, Part 1

Module 07: Editing Text, Part 2

Module 08: Arranging Slides

Module 9: Working with Themes

Module 10: Formatting Characters

Module 11: Lists

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 12: Format Text Boxes

Module 13: Alignment and Spacing

Module 14: Insert Images

Module 15: Insert and Edit Shapes

Check Your Understanding 10

Check Your Understanding 11

Module 16: Animate Objects, Part 1

Module 17: Animate Objects, Part 2

Check Your Understanding 12

Check Your Understanding 13

Module 18: Add a Table

Module 19: Table Layout

Check Your Understanding 14

Check Your Understanding 15

Module 20: Inserting a Chart from Excel

Module 21: Review Your Presentation

Module 22: Printing Your Presentation

Check Your Understanding 16

Check Your Understanding 17

Course Completion

Learning PowerPoint 2019 - Beginner (TOSA)

Module 01: Opening PowerPoint

Module 02: The PowerPoint Interface

Module 03: Create and Save

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 04: Formatting Characters

Module 05: Lists

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 06: Insert Images

Module 07: Add a Table

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9
Course Completion

Mastering Excel 365 - Basics (2022)

Module 01: Introduction

Module 02: Open and Save a Workbook

Module 03: Modifying Rows and Columns, Part 1

Module 04: Modifying Rows and Columns, Part 2

Module 05: Managing Worksheets, Part 1

Module 06: Managing Worksheets, Part 2

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 07: Using Absolute References

Module 08: Creating Named Ranges

Module 09: Using Named Ranges in Functions

Module 10: Working with IF Functions

Module 11: Working with Logical Functions

Module 12: Creating Functions Based on Conditions

Module 13: Tracing Formulas

Module 14: Addressing Formula Errors

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 15: Aligning Cell Contents

Module 16: Adding Borders and Shading

Module 17: Applying Number and Date Formats

Module 18: Using Format Painter

Module 19: Applying Cell Styles and Themes

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 20: Changing Chart Types

Module 21: Changing Chart Source Data

Module 22: Creating a Table

Module 23: Creating a PivotTable

Check Your Understanding 10
Check Your Understanding 11
Check Your Understanding 12

Module 24: Setting Page Layout Options

Module 25: Changing Page Breaks and Scaling

Module 26: Configuring Headers and Footers

Check Your Understanding 13
Check Your Understanding 14
Check Your Understanding 15
Course Completion

Mastering Word 2019 - Advanced

Module 01: Introduction

Module 02: Integrating Pictures and Text

Module 03: Removing Image Backgrounds

Module 04: Adjusting Image Appearance

Module 05: Applying Image Effects and Styles

Module 06: Compressing an Image

Module 07: Inserting a Video Link or Screenshot

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 08: Emphasizing Content with Text Boxes

Module 9: Inserting WordArt

Module 10: Creating Custom Graphics

Module 11: Inserting SmartArt

Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6

Module 12: Configuring Document Properties

Module 13: Using Track Changes

Module 14: Reviewing Track Changes

Module 15: Comparing and Merging

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 16: Adding Captions

Module 17: Using Cross-References

Module 18: Using Bookmarks

Module 19: Inserting Hyperlinks

Module 20: Inserting Footnotes and Endnotes

Module 21: Adding Citations

Module 22: Adding a Bibliography

Check Your Understanding 10
Check Your Understanding 11
Check Your Understanding 12

Module 23: Hiding Confidential Information

Module 24: Restricting Edits

Module 25: Restricting Access

Module 26: Using Digital Signatures

Check Your Understanding 13
Check Your Understanding 14
Check Your Understanding 15

Module 27: Adding Content Controls

Module 28: Editing Content Controls

Check Your Understanding 16
Check Your Understanding 17
Check Your Understanding 18

Module 29: Recording Macros

Module 30: Using External Macros

Module 31: Editing Macros

Check Your Understanding 19
Check Your Understanding 20
Check Your Understanding 21
Course Completion

Creating Word Templates

Module 01: Introduction

Module 02: Design Principles

Module 03: Themes

Module 04: Headings

Module 05: Headers and Footers

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 06: Section Title Pages

Module 07: Adding Visual Elements

Module 08: Using and Modifying Templates

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3
Check Your Understanding 4
Check Your Understanding 5
Check Your Understanding 6
Course Completion

Mastering PowerPoint 2019

Module 1: Introduction

The PowerPoint Interface
Views and Navigation
Slideshow Options
Create and Save
Select a Presentation Type
Editing Text, Part 1
Editing Text, Part 2
Arranging Slides
Working with Themes
Formatting Characters
Lists
Alignment and Spacing
Text Options
Format Text Boxes
Insert Images
Creating Photo Albums
Insert and Edit Shapes
Edit Pictures, Part 1
Edit Pictures, Part 2
Picture Styles
Group Objects
Arrange Objects
Animate Objects, Part 1
Animate Objects, Part 2
Add a Table
Table Layout
Table Design
Insert a Table from Other Applications
Creating a Chart
New Chart Types
Designing a Chart
Formatting a Chart
Inserting a Chart from Excel
Review your Presentation, Part 1
Review your Presentation, Part 2
Accessibility
Apply Transitions
Morph Transition
Printing Your Presentation
Delivering your Presentation
Exporting Presentations
PowerPoint Online
View Options Online
Editing in PowerPoint Online
Online Feature Review
Customizing the Interface
Customizing the Ribbon
Setting Windows Options
Setting PowerPoint Options
Modifying Slide Masters, Part 1
Modifying Slide Masters, Part 2
Inserting Headers and Footers
Modifying Notes and Handouts Masters
Creating SmartArt
Modifying SmartArt
Inserting 3D Models
Inserting SVGs and Icons
Inking, Part 1
Inking, Part 2
Writing Math Equations
Adding Audio
Editing Audio
Adding Video, Part 1
Adding Video, Part 2
Customizing Animations
Animating with Bookmarks
Timing Slide Transitions
Inserting Sections
Adding Comments
Using Compare and Merge
Inserting a Form
Viewing Form Responses
Sharing on the Web
Annotating a Presentation
Using Presenter View
Using Set Up Slide Show
Creating a Custom Slide Show
Adding Captions and Subtitles
Using Translation and Dictation
Adding Hyperlinks
Inserting Action Buttons
Using Zoom
Recording a Presentation, Part 1
Recording a Presentation, Part 2
Securing a Presentation
Broadcasting a Presentation
Creating a Video of a Presentation
Creating a CD of a Presentation
Course Completion

Mastering Word 2019 - Intermediate

Module 01: Introduction

Module 02: Sorting Table Data

Module 03: Controlling Cell Layout

Module 04: Performing Table Calculations

Module 05: Creating Charts

Module 06: Adding an Excel Table

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 07: Creating Text Styles

Module 08: Applying Text Effects

Module 9: Customizing List Styles

Module 10: Customizing Table Styles

Module 11: Applying Document Themes

Module 12: Customizing a Document Theme

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 13: Inserting Building Blocks

Module 14: Inserting a Database Building Block

Module 15: Using the Building Blocks Organizer

Check Your Understanding 7

Check Your Understanding 8

Module 16: Using Templates

Module 17: Creating Templates

Module 18: Managing Custom Templates

Check Your Understanding 9

Check Your Understanding 10

Check Your Understanding 11

Module 19: Controlling Paragraph Flow

Module 20: Inserting Section Breaks

Module 21: Inserting Columns

Module 22: Linking Text Boxes

Check Your Understanding 12

Check Your Understanding 13

Check Your Understanding 14

Module 23: Inserting Blank and Cover Pages

Module 24: Inserting an Index

Module 25: Inserting a Table of Contents

Module 26: Inserting a Table of Figures

Module 27: Inserting a Table of Authorities

Module 28: Creating an Outline

Module 29: Creating a Master Document

Check Your Understanding 15

Check Your Understanding 16

Check Your Understanding 17

Module 30: Creating a Mail Merge

Module 31: Adding a Mail Merge Rule

Module 32: Merging Envelopes and Labels

Check Your Understanding 18

Check Your Understanding 19

Check Your Understanding 20

Course Completion

Learning Excel 2019 - Basics (TOSA)

Module:

Inserting Functions
Using Absolute References
Check Your Understanding 1
Check Your Understanding 2
Inserting and Deleting Cells
Applying Text Formats
Applying Number Formats
Aligning Cell Contents
Applying Themes
Using Templates
Check Your Understanding 3
Check Your Understanding 4
Setting the Page Layout
Inserting Page Breaks
Configuring Headers and Footers, Part 1
Configuring Headers and Footers, Part 2
Check Your Understanding 5
Check Your Understanding 6
Managing Worksheets, Part 1
Managing Worksheets, Part 2
Creating a Custom View
Using Named Ranges
Check Your Understanding 7
Check Your Understanding 8
Working with Logical Functions
Working with Conditional Functions
Check Your Understanding 9
Check Your Understanding 10
Sorting Data
Creating Charts
Using Chart Types
Tracing Formulas
Addressing Formula Errors
Check Your Understanding 11
Check Your Understanding 12
Course Completion

Learning Excel 2019 - Expert (TOSA)

Module 01: Customizing General Options

Module 02: Customizing the Ribbon

Module 03: Customizing the Quick Access Toolbar

Check Your Understanding 1

Check Your Understanding 2

Module 04: Working with Logical Functions

Module 05: Working with Conditional Functions

Module 06: Multiple Criteria Functions

Module 07: Using Nested Functions

Module 08: Using IFS and SWITCH Functions

Module 09: Working with Text Functions, Part 1

Working with Text Functions, Part 2

Working with Text Functions, Part 3

Working with Text Functions, Part 4

Working with Math Functions

More Lookup Functions

Check Your Understanding 3

Check Your Understanding 4

Creating a PivotTable

Summarizing Data in a Pivot Table

Grouping Data in a PivotTable

Formatting a PivotTable

Selecting and Moving PivotTables

Changing PivotTable Options

Adding Calculated Fields

Presenting Data with PivotCharts

Check Your Understanding 5

Check Your Understanding 6

Co-Authoring, Part 1

Co-Authoring, Part 2

Protecting a Workbook File

Applying Data Validation

Check Your Understanding 7

Check Your Understanding 8

Addressing Formula Errors

Watching and Evaluating Formulas

Adding Error Handling

Working with Information Functions

Check Your Understanding 9

Check Your Understanding 10

Forecasting with Data Tables

Using Solver

Forecasting with Scenarios

Forecasting Data Trends

Creating Sparklines

Check Your Understanding 11

Check Your Understanding 12

Using Paste Special

Summarizing Data in Tables

Creating Custom Lists

Working with Forms

Using ActiveX Controls

Check Your Understanding 13

Check Your Understanding 14

Course Completion

Learning Excel 2019 - Productive (TOSA)

Module 01: Using Flash Fill

Module 02: Searching and Replacing

Module 03: Using Proofing and Research Tools

Module 04: Aligning Cell Contents

Module 05: Inserting Hyperlinks

Check Your Understanding 1

Check Your Understanding 2

Module 06: Applying Conditional Formatting to Numbers

Module 07: Applying Conditional Formatting to Text and Dates

Module 08: Applying Comparative Analysis Formatting

Module 09: Customizing Conditional Formatting

Using Formulas with Conditional Formatting

Check Your Understanding 3

Check Your Understanding 4

Managing Worksheet Views

Managing Workbook Views

Managing Workbook Properties

Check Your Understanding 5

Check Your Understanding 6

Sorting Data

Filtering Data

Check Your Understanding 7

Check Your Understanding 8

Creating Tables

Modifying Table Styles

Creating Charts

Changing Chart Data Source

Adding Chart Elements

Formatting a Chart

Creating a PivotTable

Summarizing Data in a Pivot Table

Check Your Understanding 9

Check Your Understanding 10

Grouping Data in a PivotTable

Check Your Understanding 11

Check Your Understanding 12

Adding Comments

Tracking Changes

Preparing to Share

Check Your Understanding 13

Check Your Understanding 14

Using Goal Seek

Creating Sparklines

Creating a Map Chart

Creating 3D Maps

Check Your Understanding 15

Check Your Understanding 16

Importing and Exporting Data

Creating a Web Query

Using the Quick Analysis Shortcut

Using Group Mode

Using 3D References

Check Your Understanding 17

Check Your Understanding 18

Course Completion

Learning Excel 2019 - Advanced (TOSA)

Module 01: Using AutoFill

Module 02: Copying Formulas and Functions

Module 03: Using Named Ranges, Part 1

Module 04: Using Named Ranges, Part 2

Module 05: Using Named Ranges, Part 3

Module 06: Working with Date Functions, Part 1

Module 07: Working with Date Functions, Part 2

Module 08: Working with Date Functions, Part 3

Module 09: Working with Time Functions

Module 10: Working with Conditional Functions

Module 11: Multiple Criteria Functions

Check Your Understanding 1

Check Your Understanding 2

Module 12: Filtering Data, Part 1

Module 13: Filtering Data, Part 2

Module 14: Querying with Database Functions

Module 15: Filtering Data

Module 16: Using the Subtotal Feature

Check Your Understanding 3

Check Your Understanding 4

Module 17: Using Advanced Chart Features

Module 18: Applying Trendlines

Module 19: Creating a Chart Template

Check Your Understanding 5

Check Your Understanding 6

Module 20: Inserting Graphics

Module 21: Modifying Graphics, Part 1

Module 22: Modifying Graphics, Part 2

Check Your Understanding 7

Check Your Understanding 8

Module 23: Creating a PivotTable

Module 24: Summarizing Data in a Pivot Table

Module 25: Grouping Data in a PivotTable

Module 26: Formatting a PivotTable

Module 27: Selecting and Moving PivotTables

Module 28: Changing PivotTable Options

Module 29: Adding Calculated Fields

Module 30: Using Slicers

Module 31: Using Timeline Slicers

Check Your Understanding 9

Check Your Understanding 10

Module 32: Creating Internal Links

Module 33: Creating External Links

Module 34: Using Paste Special

Module 35: Consolidating Data

Check Your Understanding 11

Check Your Understanding 12

Module 36: Co-Authoring, Part 1

Module 37: Co-Authoring, Part 2

Module 38: Using Compare and Merge

Module 39: Adding Digital Signatures

Module 40: Protecting Worksheets

Module 41: Protecting Workbook Structure

Module 42: Protecting a Workbook File

Module 43: Applying Data Validation

Check Your Understanding 13

Check Your Understanding 14

Module 44: Adding a Dropdown List

Module 45: Customizing Data Validation

Module 46: Recording a Macro

Module 47: Running a Macro

Module 48: Editing a Macro

Check Your Understanding 15

Check Your Understanding 16

Module 49: Using VLOOKUP, Part 1

Module 50: Using VLOOKUP, Part 2

Module 51: More Lookup Functions

Module 52: Using Array Formulas

Check Your Understanding 17

Check Your Understanding 18

Module 53: Using Goal Seek

Module 54: Inserting Symbols and Characters

Module 55: Working with Forms

Check Your Understanding 19

Check Your Understanding 20

Course Completion

Learning Excel 2019 - Beginner (TOSA)

Module 01: Navigating the Interface

Module 02: Selecting Data

Module 03: Using Commands

Module 04: Creating a New Workbook

Module 05: Entering Cell Data

Module 06: Using Excel Help

Check Your Understanding 1

Check Your Understanding 2

Module 07: Creating Formulas

Module 08: Inserting Functions

Module 09: Using Absolute References

Check Your Understanding 3

Check Your Understanding 4

Check Your Understanding 5

Applying Text Formats

Applying Number Formats

Customizing Number Formats

Applying Cell Styles

Applying Conditional Formatting to Numbers

Applying Conditional Formatting to Text and Dates

Check Your Understanding 6

Check Your Understanding 7

Printing Workbooks

Setting the Page Layout

Check Your Understanding 8

Check Your Understanding 9

Sorting Data

Filtering Data

Check Your Understanding 10

Check Your Understanding 11

Using Chart Types

Ideas in Office 365

Check Your Understanding 12

Check Your Understanding 13

Course Completion

Microsoft To Do Essentials (2020)

Module 01: Introduction

Module 02: Working with Tasks

Check Your Understanding

Module 03: Creating Lists

Module 04: Sharing Lists

Module 05: Integrating with Outlook, Part 1

Module 06: Integrating with Outlook, Part 2

Module 07: Integrating with Planner

Module 08: Using My Day

Module 09: Customizing and Searching

Check Your Understanding

Course Completion

Mastering Excel 2019 - Advanced

Module 01: Introduction

Module 02: Creating Internal Links

Module 03: Creating External Links

Module 04: Using Paste Special

Module 05: Using Group Mode

Module 06: Using 3D References

Module 07: Consolidating Data

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 08: Adding Comments

Module 09: Tracking Changes

Module 10: Co-Authoring, Part 1

Module 11: Co-Authoring, Part 2

Module 12: Using Compare and Merge

Module 13: Preparing to Share

Module 14: Adding Digital Signatures

Module 15: Protecting Worksheets

Module 16: Protecting Workbook Structure

Module 17: Protecting a Workbook File

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 18: Applying Data Validation

Module 19: Adding a Dropdown List

Module 20: Customizing Data Validation

Module 21: Recording a Macro

Module 22: Running a Macro

Module 23: Editing a Macro

Check Your Understanding 7

Check Your Understanding 8

Module 24: Using VLOOKUP, Part 1

Module 25: Using VLOOKUP, Part 2

Module 26: More Lookup Functions

Module 27: Using Array Formulas

Check Your Understanding 9

Check Your Understanding 10

Module 28: Tracing Formulas

Module 29: Addressing Formula Errors

Module 30: Watching and Evaluating Formulas

Module 31: Adding Error Handling

Module 32: Working with Information Functions

Check Your Understanding 11

Check Your Understanding 12

Module 33: Using Goal Seek

Module 34: Forecasting with Data Tables

Module 35: Using Solver

Module 36: Forecasting with Scenarios

Module 37: Forecasting Data Trends

Check Your Understanding 13

Check Your Understanding 14

Check Your Understanding 15

Module 38: Inserting Symbols and Characters

Module 39: Creating Sparklines

Module 40: Creating a Map Chart

Module 41: Creating a 3D Map

Module 42: Creating Custom Lists

Module 43: Importing and Exporting Data

Module 44: Creating a Web Query

Module 45: Working with Forms

Module 46: Using ActiveX Controls

Module 47: Ideas in Office 365

Check Your Understanding 16

Check Your Understanding 17

Check Your Understanding 18

Check Your Understanding 19

Course Completion

Microsoft 365 Office Essentials (2020)

Module 01: Introduction

Module 02: Office 365 Home Page

Module 03: Office 365 Navigation Bar

Module 04: Microsoft Search

Module 05: Accessing Help

Module 06: Outlook Email Basics, Part 1

Module 07: Outlook Email Basics, Part 2

Module 08: Email Search and Filters

Module 09: Email Folders

Module 10: To Do and Flagged Emails

Module 11: To Do and My Day

Module 12: Outlook Calendar Basics

Module 13: Adding Calendar Events, Part 1

Module 14: Adding Calendar Events, Part 2

Module 15: Introduction to OneDrive

Module 16: Using OneDrive Online, Part 1

Module 17: Using OneDrive Online, Part 2

Module 18: Using OneDrive Online, Part 3

Module 19: Office Apps, Part 1

Module 20: Office Apps, Part 2

Module 21: Mobile Apps

Course Completion

Microsoft 365 Admin Tips And Tricks

Module 01: Introduction

Module 02: Navigating the Console

Module 03: Managing Users

Module 04: Managing Groups

Module 05: Managing Shared Mailboxes

Module 06: Viewing Usage Reports

Module 07: Using Services and Add-Ins

Module 08: Configuring Multi-Factor Authentication

Module 09: Configuring Email DNS Records

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3
Check Your Understanding 4

Module 10: Managing Azure AD, Part 1

Module 11: Managing Azure AD, Part 2

Module 12: Managing Microsoft Teams

Module 13: Managing SharePoint and OneDrive

Module 14: Managing Devices, Part 1

Module 15: Managing Devices, Part 2

Module 16: Managing Exchange, Part 1

Module 17: Managing Exchange, Part 2

Module 18: Managing Exchange, Part 3

Module 19: Configuring Audits and Alerts

Check Your Understanding 5

Check Your Understanding 6

Check Your Understanding 7

Check Your Understanding 8

Course Completion

Excel In 30 Minutes: Advanced PivotTables And Slicers (Intermediate 11 Of 11)

Module 01: Changing PivotTable Options

Module 02: Adding Calculated Fields

Module 03: Presenting Data with Pivot Charts

Module 04: Using Slicers

Module 05: Using Timeline Slicers

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Creating PivotTables (Intermediate 10 Of 11)

Module 01: Creating a PivotTable

Module 02: Summarizing Data in a PivotTable

Module 03: Grouping Data in a PivotTable

Module 04: Formatting a PivotTable

Module 05: Selecting and Moving PivotTables

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Advanced Charting, Trendlines, And Graphics (Intermediate 9 Of 11)

Module 01: Using Advanced Chart Features

Module 02: Applying Trendlines

Module 03: Creating a Chart Template

Module 04: Inserting Graphics

Module 05: Modifying Graphics, Part 1

Module 06: Modifying Graphics, Part 2

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Check Your Understanding 4

Course Completion

Excel In 30 Minutes: Visualizing Data With Charts (Intermediate 8 Of 11)

Module 01: Creating Charts

Module 02: Using Chart Types

Module 03: Changing the Data Source

Module 04: Adding Chart Elements

Module 05: Formatting a Chart

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Analyzing Data With Tables And Formatting (Intermediate 7 Of 11)

Module 01: Creating Tables

Module 02: Modifying Table Styles

Module 03: Summarizing Data in Tables

Module 04: Using the Quick Analysis Shortcut

Module 05: Customizing Conditional Formatting

Module 06: Using Formulas with Conditional Formatting

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Querying And Subtotals With Lists (Intermediate 6 Of 11)

Module 01: Querying with Database Functions

Module 02: Using the Subtotal Function

Module 03: Using the Subtotal Feature

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Mastering Excel 2019 - Intermediate

Module 01: Introduction

Module 02: Using Named Ranges, Part 1

Module 03: Using Named Ranges, Part 2

Module 04: Using Named Ranges, Part 3

Module 05: Working with Date Functions, Part 1

Module 06: Working with Date Functions, Part 2

Module 07: Working with Date Functions, Part 3

Module 08: Working with Time Functions

Module 09: Working with Logical Functions

Module 10: Working with Conditional Functions

Module 11: Multiple Criteria Functions

Module 12: Using Nested Functions

Module 13: Using IFS and SWITCH Functions

Module 14: Working with Text Functions, Part 1

Module 15: Working with Text Functions, Part 2

Module 16: Working with Text Functions, Part 3

Module 17: Working with Text Functions, Part 4

Module 18: Working with Math Functions

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3
Check Your Understanding 4

Module 19: Sorting Data, Part 1

Module 20: Sorting Data, Part 2

Module 21: Filtering Data, Part 1

Module 22: Filtering Data, Part 2

Module 23: Filtering Data, Part 3

Module 24: Querying with Database Functions

Module 25: Using the Subtotal Function

Module 26: Using the Subtotal Feature

Check Your Understanding 5

Check Your Understanding 6

Check Your Understanding 7

Check Your Understanding 8

Module 27: Creating Tables

Module 28: Modifying Table Styles

Module 29: Summarizing Data in Tables

Module 30: Using the Quick Analysis Shortcut

Module 31: Customizing Conditional Formatting

Module 32: Using Formulas with Conditional Formatting

Check Your Understanding 9

Check Your Understanding 10

Module 33: Creating Charts

Module 34: Using Chart Types

Module 35: Changing Chart Data Source

Module 36: Adding Chart Elements

Module 37: Formatting a Chart

Module 38: Using Advanced Chart Features

Module 39: Applying Trendlines

Module 40: Creating a Chart Template

Check Your Understanding 11

Check Your Understanding 12

Check Your Understanding 13

Module 41: Inserting Graphics

Module 42: Modifying Graphics, Part 1

Module 43: Modifying Graphics, Part 2

Check Your Understanding 14

Check Your Understanding 15

Module 44: Creating a Pivot Table

Module 45: Summarizing Data in a Pivot Table

Module 46: Grouping Data in a PivotTable

Module 47: Formatting a Pivot Table

Module 48: Selecting and Moving PivotTables

Module 49: Changing PivotTable Options

Module 50: Adding Calculated Fields

Module 51: Presenting Data with PivotCharts

Module 52: Using Slicers

Module 53: Using Timeline Slicers

Check Your Understanding 16
Check Your Understanding 17
Check Your Understanding 18
Course Completion

Excel In 30 Minutes: Sorting And Filtering Lists (Intermediate 5 Of 11)

Module 01: Sorting Data, Part 1

Module 02: Sorting Data, Part 2

Module 03: Filtering Data, Part 1

Module 04: Filtering Data, Part 2

Module 05: Filtering Data, Part 3

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Working With Text And Math Functions (Intermediate 4 Of 11)

Module 01: Working with Text Functions, Part 1

Module 02: Working with Text Functions, Part 2

Module 03: Working with Text Functions, Part 3

Module 04: Working with Text Functions, Part 4

Module 05: Working with Math Functions

Module 06: Calculation Options

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Working With Logical Functions (Intermediate 3 Of 11)

Module 01: Working with Logical Functions

Module 02: Working with Conditional Functions

Module 03: Multiple Criteria Functions

Module 04: Using Nested Functions

Module 05: Using IFS and SWITCH Functions

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Working With Date Functions (Intermediate 2 Of 11)

Module 01: Working with Date Functions, Part 1

Module 02: Working with Date Functions, Part 2

Module 03: Working with Date Functions, Part 3

Module 04: Working with Time Functions

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Using Named Ranges (Intermediate 1 Of 11)

Module 01: Using Named Ranges, Part 1

Module 02: Using Named Ranges, Part 2

Module 03: Using Named Ranges, Part 3

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Mastering PowerPoint 2019 - Advanced

Module 01: Customizing the Interface

Module 02: Customizing the Ribbon

Module 03: Setting Windows Options

Module 04: Setting PowerPoint Options

Check Your Understanding 1
Check Your Understanding 2
Check Your Understanding 3

Module 05: Modifying Slide Masters, Part 1

Module 06: Modifying Slide Masters, Part 2

Module 07: Inserting Headers and Footers

Module 08: Modifying Notes and Handouts Masters

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 09: Creating SmartArt

Module 10: Modifying SmartArt

Module 11: Inserting 3D Models

Module 12: Inserting SVGs and Icons

Module 13: Inking, Part 1

Module 14: Inking, Part 2

Module 15: Writing Math Equations

Check Your Understanding 7
Check Your Understanding 8
Check Your Understanding 9

Module 16: Adding Audio

Module 17: Editing Audio

Module 18: Adding Video, Part 1

Module 19: Adding Video, Part 2

Module 20: Customizing Animations

Module 21: Animating with Bookmarks

Module 22: Timing Slide Transitions

Check Your Understanding 10
Check Your Understanding 11
Check Your Understanding 12

Module 23: Inserting Sections

Module 24: Adding Comments

Module 25: Using Compare and Merge

Module 26: Inserting a Form

Module 27: Viewing Form Responses

Module 28: Sharing on the Web

Check Your Understanding 13
Check Your Understanding 14
Check Your Understanding 15

Module 29: Annotating a Presentation

Module 30: Using Presenter View

Module 31: Using Set Up Slide Show

Module 32: Creating a Custom Show

Module 33: Adding Captions and Subtitles

Module 34: Translation and Dictation

Module 35: Adding Hyperlinks

Module 36: Inserting Action Buttons

Module 37: Using Zoom

Check Your Understanding 16
Check Your Understanding 17
Check Your Understanding 18

Module 38: Recording a Presentation, Part 1

Module 39: Recording a Presentation, Part 2

Module 40: Securing a Presentation

Module 41: Creating a Video of a Presentation

Module 42: Creating a CD of a Presentation

Check Your Understanding 19
Check Your Understanding 20
Check Your Understanding 21
Course Completion

Word In 30 Minutes: Formatting Text (Basics 3 Of 7)

Module 01: Applying Character Formatting

Module 02: Controlling Paragraph Layout

Module 03: Indenting Paragraphs

Module 04: Controlling Spacing

Module 05: Aligning Text with Tabs

Module 06: Formatting Lists

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Word In 30 Minutes: Adding Text, Printing, And Customizing (Basics 2 Of 7)

Module:

Selecting Text

Copying and Moving Text

Editing Paragraphs

Previewing and Printing

Customizing Word

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Word In 30 Minutes: Preparing To Publish (Basics 7 Of 7)

Module:

Checking Grammar and Readability

Using Research Tools

Checking Accessibility

Saving to Other Formats

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Word In 30 Minutes: Graphics And Page Appearance (Basics 6 Of 7)

Module 01: Inserting Symbols

Module 02: Adding Images

Module 03: Formatting Pages

Module 04: Adding Headers and Footers

Module 05: Controlling Page Layout

Module 06: Adding a Watermark

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Word In 30 Minutes: Creating Lists And Tables (Basics 5 Of 7)

Module:

Sorting Lists

Formatting Lists

Re-sequencing Lists

Inserting a Table

Modifying a Table

Formatting a Table

Converting Text to a Table

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Word In 30 Minutes: Navigating And Creating Documents (Basics 1 Of 7)

Module:

Navigating in Microsoft Word, Part 1

Navigating in Microsoft Word, Part 2

Creating Documents

Saving Revised Documents

Managing Your Workspace

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

What’s New In Word 2019?

Module 01: SVG Images and Icons

Module 02: 3D Models

Module 03: Online Images

Module 04: Sharing and Co-Authoring

Module 05: Dictate and Translate

Module 06: LinkedIn Integration

Module 07: Ink and Drawing

Module 08: Using SharePoint Properties

Module 09: Tap

Module 10: Accessibility Enhancements

Module 11: Editor

Module 12: Researcher and Smart Lookup

Module 13: Other Enhancements

Course Completion

Outlook Online Essentials 2020

Module 01: Outlook Email Basics, Part 1

Module 02: Outlook Email Basics, Part 2

Module 03: Email Search and Filters

Module 04: Email Folders

Module 05: Categories and Mentions

Module 06: Focused Inbox and Clutter

Module 07: Sweep

Module 08: Email Archive

Check Your Understanding

Module 09: To Do and Flagged Emails

Module 10: To Do and MyDay

Module 11: Calendar Basics

Module 12: Adding Calendar Events, Part 1

Module 13: Adding Calendar Events, Part 2

Module 14: Calendar Search and Print

Module 15: People

Check Your Understanding

Module 16: Sharing Calendars

Module 17: Adding Calendars

Module 18: Delegate Calendar Access

Module 19: Sharing Email Folders

Check Your Understanding

Course Completion

OneDrive Essentials (2021)

Module 01: Introduction to OneDrive

Module 02: Using OneDrive Online, Part 1

Module 03: Using OneDrive Online, Part 2

Module 04: Using OneDrive Online, Part 3

Module 05: OneDrive and Office Apps

Module 06: OneDrive Sync

Module 07: OneDrive Files On-Demand

Module 08: OneDrive Sharing

Module 09: OneDrive Co-Authoring

Module 10: OneDrive Versioning and Backup

Module 11: OneDrive Recycle Bin

Check Your Understanding

Course Completion

Mastering Word 2016 - Intermediate

Module 01: Sorting Table Data (1A)

Module 02: Cell Layout (1B)

Module 03: Calculations and Equations (1C)

Module 04: Create a Chart (1D)

Module 05: Add Excel Tables and Objects (1E)

Check Your Understanding
Check Your Understanding
Check Your Understanding

Module 06: Text Styles (2A)

Module 07: Style Sets (2A)

Module 08: Custom List and Table Styles (2B)

Module 09: Apply Document Themes (2C)

Check Your Understanding
Check Your Understanding

Module 10: Inserting Building Blocks (3A)

Module 11: Create and Modify Building Blocks (3B)

Module 12: Insert Fields Using QuickParts (3C)

Check Your Understanding
Check Your Understanding

Module 13: Create a Document Using Templates (4A)

Module 14: Create a Template (4B)

Module 15: Modify Templates (4B)

Module 16: Template Organizer (4C)

Check Your Understanding
Check Your Understanding

Module 17: Control Paragraph Flow (5A)

Module 18: Insert Section Breaks (5B)

Module 19: Insert Columns (5C)

Module 20: Link Text Boxes (5D)

Check Your Understanding

Module 21: Insert Blank and Cover Pages (6A)

Module 22: Indexes and Concordances (6B)

Module 23: Insert a Table of Contents (6C)

Module 24: Ancillary Tables (6D)

Module 25: Table of Authorities (6D)

Module 26: Manage Outlines (6E)

Module 27: Master and Subdocuments (6F)

Check Your Understanding

Module 28: Mail Merge (7A)

Module 29: Advanced Mail Merge (7A)

Module 30: Merge Labels (7B)

Module 31: Merge Envelopes (7B)

Check Your Understanding

Course Completion

Mastering Word 2016 - Basics

Module 01: Overview and Navigation (1A)

Module 02: Create and Save Documents (1B)

Module 03: Save and Save As (1B)

Module 04: Manage your Workspace (1C)

Module 05: Text Selection and Mini Toolbar (1D)

Module 06: Cut, Copy and Paste (1D)

Module 07: Undo, Repeat, Redo (1D)

Module 08: Preview and Print (1E)

Module 09: Customizing the Word Environment (1F)

Check Your Understanding

Module 10: Applying Character Formatting (2A)

Module 11: Control Paragraph Layout (2B)

Module 12: Indents and Tabs (2B)

Module 13: Line and Paragraph Spacing (2B)

Module 14: Align Text Using Tabs (2C)

Module 15: Bullets and Numbered Lists

Module 16: Apply Borders and Shading (2E)

Check Your Understanding

Module 17: Using Find and Replace (3A)

Module 18: Format Painter and Redo (3B)

Module 19: Intro to Styles (3C)

Check Your Understanding

Module 20: Sorting a List (4A)

Module 21: Formatting a List (4B)

Check Your Understanding

Module 22: Inserting a Table (5A)

Module 23: Modifying a Table (5B)

Module 24: Formatting a Table (5C)

Module 25: Converting Text to a Table (5D)

Check Your Understanding

Module 26: Inserting Symbols & Special Characters (6A)

Module 27: Inserting Images

Check Your Understanding

Module 28: Apply Page Border and Color (7A)

Module 29: Header and Footers (7B)

Module 30: Controlling Page Layout (7C)

Module 31: Watermarks (7D)

Check Your Understanding

Module 32: Spellcheck and Grammar (8A)

Module 33: Using Research Tools (8B)

Module 34: Checking Accessibility

Module 35: Saving a Document to Other Formats (8D)

Check Your Understanding

Booster

Course Completion

Mastering PowerPoint 2019 - Basics

Module 01: Introduction

Module 02: The PowerPoint Interface

Module 03: View and Navigate

Module 04: Slideshow Options

Module 05: Create and Save

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 06: Select a Presentation Type

Module 07: Editing Text, Part 1

Module 08: Editing Text, Part 2

Module 09: Arranging Slides

Module 10: Working with Themes

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 11: Formatting Characters

Module 12: Lists

Module 13: Alignment and Spacing

Module 14: Text Options

Module 15: Format Text Boxes

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 16: Insert Images

Module 17: Creating Photo Albums

Module 18: Insert and Edit Shapes

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Module 19: Edit Pictures, Part 1

Module 20: Edit Pictures, Part 2

Module 21: Picture Styles

Module 22: Group Objects

Module 23: Arrange Objects

Module 24: Animate Objects, Part 1

Module 25: Animate Objects, Part 2

Check Your Understanding 13

Check Your Understanding 14

Check Your Understanding 15

Module 26: Add a Table

Module 27: Table Layout

Module 28: Table Design

Module 29: Insert a Table from Other Applications

Module 30: Creating a Chart

Module 31: New Chart Types - Funnel and Map

Module 32: Designing a Chart

Module 33: Formatting a Chart

Module 34: Inserting a Chart from Excel

Check Your Understanding 16

Check Your Understanding 17

Check Your Understanding 18

Module 35: Review your Presentation, Part 1

Module 36: Review your Presentation, Part 2

Module 37: Accessibility

Module 38: Apply Transitions

Module 39: Morph Transition

Module 40: Printing Your Presentation

Module 41: Delivering your Presentation

Module 42: Exporting Presentations

Check Your Understanding 19

Check Your Understanding 20

Check Your Understanding 21

Module 43: PowerPoint Online

Module 44: View Options Online

Module 45: Editing in PowerPoint Online

Module 46: Online Feature Review

Check Your Understanding 22

Check Your Understanding 23

Check Your Understanding 24

Course Completion

Mastering PowerPoint 2016 - Basics

Module 01: Intro to PowerPoint (1A)

Module 02: Views and Navigation (1B)

Module 03: Slideshow Options (1B)

Module 04: Create and Save (1C)

Module 05: Getting Help (1D)

Check Your Understanding 1

Check Your Understanding 2

Module 06: Select a Presentation Type (2A)

Module 07: Editing Text (2B)

Module 08: Arranging Slides (2C)

Module 09: Working with Themes (2C)

Module 10: Formatting Characters (3A)

Check Your Understanding 3

Check Your Understanding 4

Module 11: Lists (3B)

Module 12: Alignment and Spacing (3B)

Module 13: More Text Options (3B)

Module 14: Format Text Boxes (3C)

Check Your Understanding 5

Check Your Understanding 6

Module 15: Insert Images (4A)

Module 16: Creating Photo Albums (4A)

Module 17: Insert and Edit Shapes (4B)

Module 18: Edit Pictures, Part 1 (5A)

Module 19: Edit Pictures, Part 2 (5A)

Check Your Understanding 7

Check Your Understanding 8

Module 20: Group Objects (5C)

Module 21: Arrange Objects (5D)

Module 22: Animate Objects (5E)

Check Your Understanding 9

Check Your Understanding 10

Module 23: Add a Table (6A)

Module 24: Table Layout (6B)

Module 25: Table Design (6B)

Module 26: Insert a Table from Other Applications (6C)

Check Your Understanding 11

Check Your Understanding 12

Module 27: Creating a Chart (7A)

Module 28: Designing a Chart (7B)

Module 29: Formatting a Chart (7B)

Module 30: Inserting a Chart from Excel (7C)

Check Your Understanding 13

Check Your Understanding 14

Module 31: Review your Presentation (8A)

Module 32: Apply Transitions (8B)

Module 33: Printing your Presentation (8C)

Module 34: Delivering Your Presentation

Check Your Understanding 15

Check Your Understanding 16

Module 35: PowerPoint Online (9A)

Module 36: Viewing and Navigating Online (9B)

Module 37: Editing in PowerPoint Online (9C)

Module 38: Online Feature Review (9D)

Check Your Understanding 17

Check Your Understanding 18

Course Completion

Mastering PowerPoint 2016 - Advanced

Module 01: Customizing the User Interface (1A)

Module 02: Window Options (1A)

Module 03: Set PowerPoint Options (1B)

Check Your Understanding

Module 04: Slide Masters Part 1 (2A)

Module 05: Slide Masters Part 2 (2A)

Module 06: Headers and Footers (2B)

Module 07: Notes Master and Handout Master (2C)

Check Your Understanding
Check Your Understanding

Module 08: SmartArt (3A)

Module 09: Modify SmartArt Graphics (3B)

Module 10: Write Math Equations (3C)

Check Your Understanding
Check Your Understanding

Module 11: Adding Audio to a Presentation (4A)

Module 12: Adding Video to a Presentation, Pt 1 (4B)

Module 13: Adding Video to a Presentation, Pt 2 (4B)

Module 14: Customize Animations (4C)

Module 15: Animation with a Bookmark (4C)

Module 16: Timing Slide Transitions (4C)

Check Your Understanding
Check Your Understanding

Module 17: Sections (5A)

Module 18: Comments (5A)

Module 19: Compare and Merge Presentations (5A)

Module 20: Store and Share Presentations on the Web (5B)

Check Your Understanding
Check Your Understanding
Check Your Understanding

Module 21: Annotate a Presentation (6A)

Module 22: Presenter View (6B)

Module 23: Setup Show (6B)

Module 24: Create a Custom Slide Show (6B)

Module 25: Adding Hyperlinks (6D)

Module 26: Action Buttons (6D)

Module 27: Zoom (6D)

Module 28: Record a Presentation (6E)

Check Your Understanding
Check Your Understanding
Check Your Understanding
Check Your Understanding

Module 29: Secure a Presentation (7A)

Module 30: Broadcast a Slideshow (7B)

Module 31: Create a Video (7C)

Module 32: Create a CD (7C)

Check Your Understanding

Course Completion

Mastering OneNote 2016

Module 01: Intro to OneNote (1A)

Module 02: Basic Information Entry

Module 03: Page Templates (1B)

Module 04: Customizing the User Interface

Check Your Understanding 1

Check Your Understanding 2

Module 05: Applying Formatting (2A)

Module 06: Images and Screen Clipping (2B)

Module 07: Audio and Video (2B)

Module 08: Quicknotes and Links (2C)

Module 09: Drawing Tools (2D)

Check Your Understanding 1

Check Your Understanding 2

Module 10: Embedding Excel Spreadsheets (3A)

Module 11: Other Attachments (3B)

Check Your Understanding 1

Check Your Understanding 2

Module 12: Tags (4A)

Module 13: Organizing Notebooks (4B)

Module 14: Using Search (4B)

Check Your Understanding 1

Check Your Understanding 2

Module 15: Proofing and Printing 5A

Module 16: Passwords and Properties (5B)

Check Your Understanding 1

Check Your Understanding 2

Module 17: Exporting Content (6B)

Module 18: Backing up and Versions

Check Your Understanding 1

Check Your Understanding 2

Module 19: Outlook and Word Integration (7A)

Module 20: Sharing Notebooks (7B)

Check Your Understanding 1

Check Your Understanding 2

Course Completion

Mastering Excel 2019 - Basics

Module 01: Introduction

Module 02: Navigating the Interface

Module 03: Selecting Data

Module 04: Using Commands

Module 05: Creating a New Workbook

Module 06: Entering Cell Data

Module 07: Using AutoFill

Module 08: Using Flash Fill

Module 09: Using Excel Help

Check Your Understanding 1

Check Your Understanding 2

Module 10: Creating Formulas

Module 11: Inserting Functions

Module 12: Copying Formulas and Functions

Module 13: Using Absolute References

Check Your Understanding 3

Check Your Understanding 4

Check Your Understanding 5

Module 14: Inserting and Deleting Cells

Module 15: Searching and Replacing

Module 16: Using Proofing and Research Tools

Check Your Understanding 6

Check Your Understanding 7

Module 17: Applying Text Formats

Module 18: Applying Number Formats

Module 19: Customizing Number Formats

Module 20: Aligning Cell Contents

Module 21: Applying Cell Styles

Module 22: Applying Themes

Module 23: Inserting Hyperlinks

Module 24: Applying Conditional Formatting to Numbers

Module 25: Applying Conditional Formatting to Text and Dates

Module 26: Applying Comparative Analysis Formatting

Module 27: Using Templates

Check Your Understanding 8

Check Your Understanding 9

Module 28: Printing Workbooks

Module 29: Setting the Page Layout

Module 30: Inserting Page Breaks

Module 31: Configuring Headers and Footers, Part 1

Module 32: Configuring Headers and Footers, Part 2

Check Your Understanding 10

Check Your Understanding 11

Module 33: Managing Worksheets, Part 1

Module 34: Managing Worksheets, Part 2

Module 35: Creating a Custom View

Module 36: Managing Worksheet Views

Module 37: Managing Workbook Views

Module 38: Managing Workbook Properties

Module 39: Customizing General Options

Module 40: Customizing the Ribbon

Module 41: Customizing the Quick Access Toolbar

Check Your Understanding 12

Check Your Understanding 13

Check Your Understanding 14

Booster

Course Completion

Excel - Data Analysis With PivotTables

Module 01: Preparing Data

Module 02: Creating a Pivot Table from a Local Data Source

Module 03: Create from Multiple Local Data Sources

Module 04: Create from External Data Sources

Check Your Understanding

Module 05: Summarize Pivot Table Data

Module 06: Organize Pivot Table Data

Module 07: Filter Pivot Table Data, Part 1

Module 08: Filter Pivot Table Data, Part 2

Module 09: Format a Pivot Table

Check Your Understanding

Module 10: Refresh and Change Pivot Table Data

Module 11: Pivot Table Options, Part 1

Check Your Understanding

Module 13: Creating a Pivot Chart

Module 14: Manipulate Pivot Chart Data

Module 15: Formatting a Pivot Chart

Check Your Understanding

Course Completion

Mastering Outlook 2016 - Basics

Module 01: Intro to Outlook (1A)

Module 02: Working with Email (1B)

Module 03: Outlook Help (1C)

Check Your Understanding

Module 04: Add Message Recipients (2A)

Module 05: Check Spelling and Grammar (2B)

Module 06: Formatting Message Content (2C)

Check Your Understanding

Module 07: Attach Files and Items (3A)

Module 08: Add Illustrations to Messages (3B)

Module 09: Message Styles (3B)

Module 10: Illustrations in Messages (3B)

Module 11: Automatic Message content (3C)

Check Your Understanding

Module 12: Customize Reading Options (4A)

Module 13: Track Messages (4B)

Module 14: Recall and Resend (4C)

Check Your Understanding

Module 15: Mark Messages (5A1)

Module 16: Folders (6B1)

Check Your Understanding

Module 17: Contacts (6A1)

Module 18: Manage Contacts (6B1)

Check Your Understanding

Module 19: View the Calendar (7A1)

Module 20: Create Appointments (7B1)

Module 21: Scheduling Meetings, Part 1 (7C1)

Module 22: Scheduling Meetings, Part 2 (7C2)

Module 23: Print the Calendars (7D1)

Check Your Understanding

Module 24: Create Tasks (8A1)

Module 25: Notes (8B1)

Check Your Understanding

Booster

Course Completion

Mastering Outlook 2016 - Advanced

Module 01: Insert Advanced Characters and Objects (1A)

Module 02: Inserting Charts (1A)

Module 03: Modify Message Options

Module 04: Configure Global Outlook Options (1C)

Module 05: Customizing the Outlook Interface (1D)

Check Your Understanding 1

Check Your Understanding 2

Module 06: Group and Sort Messages (2A)

Module 07: Filters and Clutter (2B)

Module 08: Search Outlook Items (2C)

Check Your Understanding 1

Check Your Understanding 2

Module 09: Junk Email Filter (3A)

Module 10: Manage your Mailbox (3B)

Check Your Understanding 1

Check Your Understanding 2

Module 11: Using Automatic Replies (4A)

Module 12: Conditional Formatting (4B)

Module 13: Using the Rules Wizard (4B)

Module 14: Quick Steps (4C)

Check Your Understanding 1

Check Your Understanding 2

Module 15: Advanced Calendar Options (5A)

Module 16: Managing Additional Calendars (5B)

Module 17: Manage Meeting Responses (5C)

Check Your Understanding 1

Check Your Understanding 2

Module 18: Import and Export Contacts (6A)

Module 19: Electronic Business Cards (6B)

Module 20: Forward Contacts (6C)

Check Your Understanding 1

Check Your Understanding 2

Module 21: Assign and Manage Tasks (7A)

Check Your Understanding 1

Check Your Understanding 2

Module 22: Delegate Access (8A)

Module 23: Sharing Calendars (8B)

Module 24: Sharing Contacts (8C)

Check Your Understanding 1

Check Your Understanding 2

Module 25: Archiving (9A)

Module 26: Outlook Data Files (9B)

Module 27: Data File Settings (9C)

Check Your Understanding 1

Check Your Understanding 2

Course Completion

Mastering Outlook 2016

Module 01: Intro to Outlook (1A)

Module 02: Working with Email (1B)

Module 03: Outlook Help (1C)

Check Your Understanding 1

Check Your Understanding 2

Module 04: Add Message Recipients (2A)

Module 05: Check Spelling and Grammar (2B)

Module 06: Formatting Message Content (2C)

Check Your Understanding 3

Check Your Understanding 4

Check Your Understanding 5

Module 07: Attach Files and Items (3A)

Module 08: Add Illustrations to Messages (3B)

Module 09: Message Styles (3B)

Module 10: Illustrations in Messages (3B)

Module 11: Automatic Message Content (3C)

Check Your Understanding 6

Check Your Understanding 7

Check Your Understanding 8

Module 12: Customize Reading Options (4A)

Module 13: Track Messages (4B)

Module 14: Recall and Resend (4C)

Check Your Understanding 9

Check Your Understanding 10

Check Your Understanding 11

Module 15: Mark Messages (5A1)

Module 16: Folders (5B1)

Check Your Understanding 12

Check Your Understanding 13

Check Your Understanding 14

Module 17: Contacts (6A1)

Module 18: Manage Contacts (6B1)

Check Your Understanding 15

Check Your Understanding 16

Check Your Understanding 17

Module 19: View the Calendar (7A1)

Module 20: Create Appointments (7B1)

Module 21: Scheduling Meetings, Part 1 (7C1)

Module 22: Scheduling Meetings, Part 2 (7C2)

Module 23: Print the Calendars (7D1)

Check Your Understanding 18

Check Your Understanding 19

Check Your Understanding 20

Module 24: Create Tasks (8A1)

Module 25: Notes (8B1)

Check Your Understanding 21

Check Your Understanding 22

Check Your Understanding 23

Module 26: Insert Advanced Characters and Objects (1A)

Module 27: Inserting Charts (1A)

Module 28: Modify Message Options

Module 29: Configure Global Outlook Options (1C)

Module 30: Customizing the Outlook Interface

Check Your Understanding 24

Check Your Understanding 25

Check Your Understanding 26

Module 31: Group and Sort Messages (2A)

Module 32: Filters and Clutter (2B)

Module 33: Search Outlook Items (2C)

Check Your Understanding 27

Check Your Understanding 28

Check Your Understanding 29

Module 34: Junk Email Filter (3A)

Module 35: Manage your Mailbox (3B)

Check Your Understanding 30

Check Your Understanding 31

Check Your Understanding 32

Module 36: Using Automatic Replies (4A)

Module 37: Conditional Formatting (4B)

Module 38: Using the Rules Wizard (4B)

Module 39: Quick Steps (4C)

Check Your Understanding 33

Check Your Understanding 34

Check Your Understanding 35

Module 40: Advanced Calendar Options (5A)

Module 41: Managing Additional Calendars (5B)

Module 42: Manage Meeting Responses (5C)

Check Your Understanding 36

Check Your Understanding 37

Check Your Understanding 38

Module 43: Import and Export Contacts (6A)

Module 44: Electronic Business Cards (6B)

Module 45: Forward Contacts (6C)

Check Your Understanding 39

Check Your Understanding 40

Check Your Understanding 41

Module 46: Assign and Manage Tasks (7A)

Check Your Understanding 42

Check Your Understanding 43

Module 47: Delegate Access (8A)

Module 48: Sharing Calendars (8B)

Module 49: Sharing Contacts (8C)

Check Your Understanding 44

Check Your Understanding 45

Module 50: Archiving (9A)

Module 51: Outlook Data File(9B)

Module 52: Data File Settings (9C)

Check Your Understanding 46

Check Your Understanding 47

Check Your Understanding 48

Course Completion

What’s New In Excel 2019?

Module 01: New Chart and Image Options

Module 02: Sharing

Module 03: TextJoin and Concat

Module 04: Max Ifs and Min Ifs

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Check Your Understanding 4

Module 05: Switch

Module 06: Ink and Drawing

Module 07: New in Backstage View

Module 08: Extra Features

Check Your Understanding 5

Check Your Understanding 6

Check Your Understanding 7

Check Your Understanding 8

Course Completion

Mastering Excel 2016 - Intermediate

Module 01: Working with Named Ranges (1A)

Module 02: Using Named Ranges in Formulas (1A)

Module 03: Using Specialized Functions

Module 04: Working with Logical Functions (1C)

Module 05: Displaying Formulas

Module 06: Nesting Functions (1C)

Module 07: Date and Time Functions (1D)

Module 08: Working With Text Functions (1E)

Check Your Understanding

Module 09: Sorting Data (2A)

Module 10: Filtering Data (2B)

Module 11: Using Database Functions (2C)

Module 12: Using Subtotals (2D)

Check Your Understanding

Module 13: Create and Modify Tables (3A)

Module 14: Manipulating Table Data (3A)

Module 15: Conditional Formatting Rules (3B)

Module 16: Using Logical Functions with Conditional Formatting (3C)

Check Your Understanding

Module 17: Creating Charts (4A)

Module 18: Modifying and Formatting Charts (4B)

Module 19: Creating a Dual Axis Chart (4C)

Module 20: Chart Templates (4C)

Module 21: Formatting Shapes and Objects

Check Your Understanding

Module 22: Creating a PivotTable (5A)

Module 23: Analyzing PivotTable Data (5B)

Module 24: Pivot Charts (5C)

Module 25: Slicers and Timelines (5D)

Check Your Understanding

Course Completion

Mastering Excel 2016 - Basics

Module 01: Intro (1A)

Module 02: Selecting and Navigating (1A)

Module 03: Keyboard Navigation and Basic Data Entry (1A)

Module 04: The Ribbon (1B)

Module 05: The Quick Access Toolbar (1B)

Module 06: Creating a New Spreadsheet (1C)

Module 07: Compatibility Issues

Module 08: Cell Data & Data Types (1D)

Module 09: Accessing Help (1E)

Check Your Understanding

Module 10: Creating Worksheet Formulas (2A)

Module 11: Insert Functions (2B)

Module 12: Re-using Formulas and Functions (2C)

Check Your Understanding

Module 13: Insert, Delete & Adjust Columns & Rows (3A)

Module 14: Find and Replace (3B)

Module 15: Use Proofing and Research Tools (3A)

Check Your Understanding

Module 16: Apply Text Formats (4A)

Module 17: Apply Number Formats (4B)

Module 18: Align Cell Contents (4C)

Module 19: Applying Styles and Themes (4D)

Module 20: Conditional Formatting (4E)

Module 21: Creating and Using Templates (4F)

Check Your Understanding

Module 22: Preview and Print a Notebook (5A)

Module 23: Page Layout (5B)

Module 24: Configure Headers and Footers (5C)

Check Your Understanding

Module 25: Managing Worksheets (6A)

Module 26: View Options (6B)

Module 27: Managing Workbook Properties (6C)

Check Your Understanding

Course Completion

Mastering Excel 2016 - Advanced

Module 01: Using Links and External References

Module 02: Using 3D References

Module 03: Consolidating Data

Check Your Understanding 1

Check Your Understanding 2

Module 04: Using Lookup Functions, Part 1

Module 05: Using Lookup Functions, Part 2

Module 06: Tracing Precedent and Dependent Cells

Module 07: Watching and Evaluating Formulas

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 08: Comments and Track Changes

Module 09: Comparing and Merging Workbooks

Module 10: Accessibility Checker

Module 11: Protecting Worksheets and Workbooks

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 12: Applying Data Validation

Module 13: Search for Invalid Data

Module 14: Working with Macros, Part 1

Module 15: Working with Macros, Part 2

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 16: Creating Sparklines

Module 17: 3D Maps

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 18: Data Tables

Module 19: Using Scenarios

Module 20: Goal Seek

Module 21: Forecasting Data Trends

Module 22: Changing Your Display

Module 23: Importing Delimited Text Files

Module 24: Data Forms and Form Controls

Module 25: Calculated Fields and Cube Functions

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Mastering Excel 2016

Module 01: Intro (1A)

Module 02: Selecting and Navigating (1A)

Module 03: Keyboard Navigation and Basic Data Entry

Module 04: The Ribbon (1B)

Module 05: The Quick Access Toolbar (1B)

Module 06: Creating a New Spreadsheet (1C)

Module 07: Compatibility Issues

Module 08: Cell Data & Data Types (1D)

Module 09: Accessing Help (1E)

Module 10: Creating Worksheet Formulas (2A)

Module 11: Insert Functions (2B)

Module 12: Re-using Formulas and Functions (2C)

Module 13: Insert, Delete, & Adjust Columns & Rows (3A)

Module 14: Find and Replace (3B)

Module 15: Use Proofing and Research Tools (3A)

Module 16: Apply Text Formats (4A)

Module 17: Apply Number Formats (4B)

Module 18: Align Cell Contents (4C)

Module 19: Applying Styles and Themes (4D)

Module 20: Conditional Formatting (4E)

Module 21: Creating and Using Templates (4F)

Module 22: Preview and Print a Notebook (5A)

Module 23: Page Layout (5B)

Module 24: Configure Headers and Footers (5C)

Module 25: Managing Worksheets (6A)

Module 26: View Options (6B)

Module 27: Managing Workbook Properties (6C)

Module 28: Working With Named Ranges (1A)

Module 29: Using Named Ranges in Formulas (1A)

Module 30: Using Specialized Functions

Module 31: Working With Logical Functions (1C)

Module 32: Displaying Formulas

Module 33: Nesting Functions (1C)

Module 34: Date and Time Functions (1D)

Module 35: Working With Text Functions (1E)

Module 36: Sorting Data (2A)

Module 37: Filtering Data (2B)

Module 38: Using Database Functions (2C)

Module 39: Using Subtotals (2D)

Module 40: Create and Modify Tables (3A)

Module 41: Manipulating Table Data (3A)

Module 42: Conditional Formatting Rules (3B)

Module 43: Using Logical Functions with Conditional Formatting

Module 44: Creating Charts (4A)

Module 45: Modifying and Formatting Charts (4B)

Module 46: Creating a Dual Axis Chart (4C)

Module 47: Chart Templates (4C)

Module 48: Formatting Shapes and Objects

Module 49: Creating a PivotTable (5A)

Module 50: Analyzing PivotTable Data (5B)

Module 51: Pivot Charts (5C)

Module 52: Slicers and Timelines (5D)

Module 53: Using Links and External References

Module 54: Using 3D References

Module 55: Consolidating Data

Module 56: Using Lookup Functions, Part 1

Module 57: Using Lookup Functions, Part 2

Module 58: Tracing Precedent and Department Cells

Module 59: Watching and Evaluating Formulas

Module 60: Comments and Track Changes

Module 61: Comparing and Merging Workbooks

Module 62: Accessibility Checker

Module 63: Protecting Worksheets and Workbooks

Module 64: Applying Data Validation

Module 65: Search for Invalid Data

Module 66: Working with Macros, Part 1

Module 67: Working with Macros, Part 2

Module 68: Creating Sparklines

Module 69: 3D Maps

Module 70: Data Tables

Module 71: Using Scenarios

Module 72: Goal Seek

Module 73: Forecasting Data Trends

Module 74: Changing Your Display

Module 75: Importing Delimited Text Files

Module 76: Data Forms and Form Controls

Module 77: Calculated Fields and Cube Functions

Course Completion

Windows 10 Essentials

Module 01: Introduction

Module 02: Getting Around in Windows 10

Module 03: Login Options

Module 04: Cortana

Module 05: Task View

Module 06: Edge

Module 07: Windows Apps and Store

Module 08: Customization

Check Your Understanding

Course Completion

Brain Bites - Using Windows 10

Module 01: Introduction

Module 02: Using Windows 10

Module 03: Cortana and Search

Module 04: File Explorer and Quick Access

Module 05: Snap, Task View, and Virtual Desktops

Module 06: Windows 10 Apps

Module 07: Customization and Tips

Check Your Understanding

Course Completion

SharePoint Online Basics

Module 01: Introduction

Module 02: Site Creation - Communication Sites

Module 03: Site Creation - Team Sites

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 04: Working With Documents

Module 05: Co-authoring, Check Out and Versions

Module 06: Major Versions

Module 07: Minor Versions and Content Approval

Module 08: Document Metadata

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 09: Classic Experience and Changing Views

Module 10: Navigation in SharePoint

Module 11: Lists

Module 12: List Apps and Calendars

Module 13: Search

Module 14: Customization

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Course Completion

SharePoint For Site Owners

Module 01: Introduction

Module 02: Creating a New Site

Module 03: Navigating to a Site

Module 04: Creating a Subsite

Check Your Understanding

Module 05: Adding a Document Library

Module 06: Versioning and Checkout

Module 07: Adding Alerts

Check Your Understanding

Module 08: Creating a Custom List

Module 09: Creating a Lookup Field

Module 10: Adding an Excel File as a List

Check Your Understanding

Module 11: Editing the Home Page

Module 12: Customizing the Look and Feel

Module 13: Customizing the Quick Launch Bar

Check Your Understanding

Module 14: Assigning Permissions

Course Completion

Secrets Of The Office Guru (2019)

Module 01: Text Selection and Mini Toolbar

Module 02: Microsoft Word: Create a Template

Module 03: Microsoft Word: WordArt and Text Effects

Module 04: Microsoft Word: Apply Document Themes

Module 05: Microsoft Word: Intro to Styles

Module 06: Microsoft Word: Text Styles

Module 07: Microsoft Word: Modifying a Table

Module 08: Microsoft Word: Inserting Images

Module 09: Microsoft Word: SmartArt

Module 10: Microsoft Excel: The Quick Access Toolbar

Module 11: Microsoft Excel: Use Proofing and Research Tools

Module 12: Microsoft Excel: Cell Data and Data Types

Module 13: Microsoft Excel: Create and Modify Tables

Module 14: Microsoft Excel: Manipulating Table Data

Module 15: Microsoft Excel: Sorting Data

Module 16: Microsoft Excel: Filtering Data

Module 17: Microsoft Excel: Modifying and Formatting Charts

Module 18: Microsoft Excel: Page Layout

Module 19: Microsoft Excel: Data Tables

Module 20: Microsoft Excel: Goal Seek

Module 21: Microsoft Excel: New Charts and Image Options

Module 22: Microsoft PowerPoint: Arranging Slides

Module 23: Microsoft PowerPoint: Edit Pictures

Module 24: Microsoft PowerPoint: Animate Objects

Module 25: Microsoft PowerPoint: Customize Animations

Module 26: Microsoft PowerPoint: Animation with a Bookmark

Module 28: Microsoft PowerPoint: Insert Images

Module 29: Microsoft PowerPoint: Picture Styles

Module 30: Microsoft OneNote: Intro to OneNote

Module 31: Microsoft OneNote: Outlook and Word Integration

Module 32: Microsoft OneNote: Sharing Notebooks

Module 33: Cloud Sharing History

Module 34: Microsoft Outlook: Automatic Message Content

Module 35: Microsoft Outlook: Track Messages

Module 36: Microsoft Outlook: Recall and Resend

Module 37: Microsoft Outlook: Folders

Module 38: Microsoft Outlook: Scheduling Meetings Part 1

Module 39: Microsoft Outlook: Scheduling Meetings Part 2

Module 40: Microsoft Outlook: Modify Message Options

Module 41: Microsoft Outlook: Advanced Calendar Options

Module 42: Microsoft Outlook: Using Automatic Replies

Module 43: Microsoft Outlook: Assign and Manage Tasks

Course Completion

Power BI Essentials

Module 01: Introduction

Module 02: Using Power BI

Module 03: Creating Data Connections

Check Your Understanding 1

Check Your Understanding 2

Module 04: Modifying Data Relationships

Module 05: Working with the Power Query Editor

Module 06: Transforming Data

Check Your Understanding 3

Check Your Understanding 4

Check Your Understanding 5

Module 07: Creating Visualizations

Module 08: Customizing Visualizations and Pages

Module 09: Creating Calculations with DAX

Module 10: Creating Calculated Measures

Check Your Understanding 6

Check Your Understanding 7

Check Your Understanding 8

Module 11: Filtering and Splicing Reports

Module 12: Publishing Reports

Check Your Understanding 9

Check Your Understanding 10

Course Completion

Mastering Word 2019 - Basics

Module 01: Introduction

Module 02: Navigating in Microsoft Word, Part 1

Module 03: Navigating in Microsoft Word, Part 2

Module 04: Creating Documents

Module 05: Saving Revised Documents

Module 06: Managing Your Workspace

Module 07: Selecting Text

Module 08: Copying and Moving Text

Module 09: Editing Paragraphs

Module 10: Previewing and Printing

Module 11: Customizing Word

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 12: Applying Character Formatting

Module 13: Controlling Paragraph Layout

Module 14: Indenting Paragraphs

Module 15: Controlling Spacing

Module 16: Aligning Text with Tabs

Module 17: Formatting Lists

Module 18: Applying Borders and Shading

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 19: Using Find and Replace

Module 20: Applying Repetitive Formatting

Module 21: Using Styles

Module 22: Creating a Style

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 23: Sorting Lists

Module 24: Formatting Lists

Module 25: Resequencing Lists

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Module 26: Inserting a Table

Module 27: Modifying a Table

Module 28: Formatting a Table

Module 29: Converting Text to a Table

Check Your Understanding 13

Check Your Understanding 14

Check Your Understanding 15

Module 30: Inserting Symbols

Module 31: Adding Images

Check Your Understanding 16

Check Your Understanding 17

Check Your Understanding 18

Module 32: Formatting Pages

Module 33: Adding Headers and Footers

Module 34: Controlling Page Layout

Module 35: Adding a Watermark

Check Your Understanding 19

Check Your Understanding 20

Check Your Understanding 21

Module 36: Checking Grammar and Readability

Module 37: Using Research Tools

Module 38: Checking Accessibility

Module 39: Saving to Other Formats

Check Your Understanding 22

Check Your Understanding 23

Check Your Understanding 24

Booster

Course Completion

Mastering Word 2016 - Advanced

Module 01: Manipulating Images (1A)

Module 02: Adjust Image Appearance (1B)

Module 03: Insert Video and Screenshots (1C)

Check Your Understanding 1

Check Your Understanding 2

Module 04: Text Boxes and Pull Quotes (2A)

Module 05: WordArt and Text Effects (2B)

Module 06: Shapes (2C)

Module 07: SmartArt (2D)

Check Your Understanding 1

Check Your Understanding 2

Module 08: Sharing Documents (3A)

Module 09: Co-Authoring (3A)

Module 10: Track Changes (3B)

Module 11: Combining Changed Documents (3C)

Module 12: Merge Changes From Other Documents (3D)

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 13: Captions (4A)

Module 14: Cross-References (4B)

Module 15: Bookmarks (4C)

Module 16: Hyperlinks (4D)

Module 17: Footnotes and Endnotes (4E)

Module 18: Citations and Bibliography (4F)

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 19: Suppressing Information (5A)

Module 20: Formatting and Editing Restrictions (5B)

Module 21: Restrict Document Access (5C)

Module 22: Digital Signatures (5D)

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 23: Using Forms (6A)

Module 24: Modifying Forms (6B)

Check Your Understanding 1

Check Your Understanding 2

Module 25: Using Macros (7A)

Module 26: Creating Macros (7B)

Check Your Understanding 1

Check Your Understanding 2

Course Completion

Mastering Word 2016

Module 01: Overview and Navigation (1A)

Module 02: Create and Save Documents (1B)

Module 03: Save and Save As (1B)

Module 04: Manage your Workspace (1C)

Module 05: Text Selection and Mini Toolbar (1D)

Module 06: Cut, Copy and Paste (1D)

Module 07: Undo, Repeat, Redo (1D)

Module 08: Preview and Print (1E)

Module 09: Customizing the Word Environment (1F)

Module 10: Applying Character Formatting (2A)

Module 11: Control Paragraph Layout (2B)

Module 12: Indents and Tabs (2B)

Module 13: Line and Paragraph Spacing (2B)

Module 14: Align Text Using Tabs (2C)

Module 15: Bullets and Numbered Lists

Module 16: Apply Borders and Shading (2E)

Module 17: Using Find and Replace (3A)

Module 18: Format Painter and Redo (3B)

Module 19: Intro to Styles (3C)

Module 20: Sorting a List (4A)

Module 21: Formatting a List (4B)

Module 22: Inserting a Table (5A)

Module 23: Modifying a Table (5B)

Module 24: Formatting a Table (5C)

Module 25: Converting Text to a Table (5D)

Module 26: Inserting Symbols & Special Characters (6A)

Module 27: Inserting Images

Module 28: Apply Page Border and Color (7A)

Module 29: Header and Footers (7B)

Module 30: Controlling Page Layout (7C)

Module 31: Watermarks (7D)

Module 32: Spellcheck and Grammar (8A)

Module 33: Using Research Tools (8B)

Module 34: Checking Accessibility (8C)

Module 35: Saving a Document to Other Formats (8D)

Module 36: Sorting Table Data (1A)

Module 37: Cell Layout (1B)

Module 38: Calculations and Equations (1C)

Module 39: Create a Chart (1D)

Module 40: Add Excel Tables and Objects (1E)

Module 41: Text Styles (2A)

Module 42: Style Sets (2A)

Module 43: Custom List and Table Styles (2B)

Module 44: Apply Document Themes (2C)

Module 45: Inserting Building Blocks (3A)

Module 46: Create and Modify Building Blocks (3B)

Module 47: Inset Fields Using QuickParts (3C)

Module 48: Create a Document Using Templates (4A)

Module 49: Create a Template (4B)

Module 50: Modify Templates (4B)

Module 51: Template Organizer (4C)

Module 52: Control Paragraph Flow (5A)

Module 53: Insert Section Breaks (5B)

Module 54: Insert Columns (5C)

Module 55: Link Text Boxes (5D)

Module 56: Insert Blank and Cover Pages (6A)

Module 57: Indexes and Concordances (6B)

Module 58: Insert a Table of Contents (6C)

Module 59: Ancillary Tables (6D)

Module 60: Table of Authorities (6D)

Module 61: Manage Outlines (6E)

Module 62: Master and Subdocuments (6F)

Module 63: Mail Merge (7A)

Module 64: Advanced Mail Merge (7A)

Module 65: Merge Labels (7B)

Module 66: Merge Envelopes (7B)

Module 67: Manipulating Images (1A)

Module 68: Adjust Image Appearance (1B)

Module 69: Insert Video and Screenshots (1C)

Module 70: Text Boxes and Pull Quotes (2A)

Module 71: WordArt and Text Effects (2B)

Module 72: Shapes (2C)

Module 73: SmartArt (2D)

Module 74: Sharing Documents (3A)

Module 75: Co-Authoring (3A)

Module 76: Track Changes (3B)

Module 77: Combining Changed Documents (3C)

Module 78: Merge Changes From Other Documents (3D)

Module 79: Captions (4A)

Module 80: Cross-References (4B)

Module 81: Bookmarks (4C)

Module 82: Hyperlinks (4D)

Module 83: Footnotes and Endnotes (4E)

Module 84: Citations and Bibliography (4F)

Module 85: Suppressing Information (5A)

Module 86: Formatting and Editing Restrictions (5B)

Module 87: Restrict Document Access (5C)

Module 88: Digital Signatures (5D)

Module 89: Using Forms (6A)

Module 90: Modifying Forms (6B)

Module 91: Using Macros (7A)

Module 92: Creating Macros (7B)

Course Completion

Mastering PowerPoint 2016

Module 01: Intro to PowerPoint (1A)

Module 02: Views and Navigation (1B)

Module 03: Slideshow Options (1B)

Module 04: Create and Save (1C)

Module 05: Getting Help (1D)

Module 06: Select a Presentation Type (2A)

Module 07: Editing Text (2B)

Module 08: Arranging Slides (2C)

Module 09: Working with Themes (2C)

Module 10: Formatting Characters (3A)

Module 11: Lists (3B)

Module 12: Alignment and Spacing (3B)

Module 13: More Text Options (3B)

Module 14: Format Text Boxes (3C)

Module 15: Insert Images (4A)

Module 16: Creating Photo Albums (4A)

Module 17: Insert and Edit Shapes (4B)

Module 18: Edit Pictures, Part 1 (5A)

Module 19: Edit Pictures, Part 2 (5A)

Module 20: Group Objects (5C)

Module 21: Arrange Objects (5D)

Module 22: Animate Objects (5E)

Module 23: Add a Table (6A)

Module 24: Table Layout (6B)

Module 25: Table Design (6B)

Module 26: Insert a Table from Other Applications (6C)

Module 27: Creating a Chart (7A)

Module 28: Designing a Chart (7B)

Module 29: Formatting a Chart (7B)

Module 30: Inserting a Chart from Excel (7C)

Module 31: Review your Presentation (8A)

Module 32: Apply Transitions (8B)

Module 33: Printing your Presentation (8C)

Module 34: Delivering Your Presentation

Module 35: PowerPoint Online (9A)

Module 36: Viewing and Navigating Online (9B)

Module 37: Editing in PowerPoint Online (9C)

Module 38: Online Feature Review (9D)

Module 39: Customizing the User Interface

Module 40: Window Options

Module 41: Set PowerPoint Options

Module 42: Slide Masters, Part 1

Module 43: Slide Masters, Part 2

Module 44: Headers and Footers

Module 45: Notes Master and Handout Master

Module 46: SmartArt

Module 47: Modify SmartArt Graphics

Module 48: Write Math Equations

Module 49: Adding Audio to a Presentation

Module 50: Adding Video to a Presentation, Pt 1

Module 51: Adding Video to a Presentation, Pt 2

Module 52: Customize Animations

Module 53: Animation with a Bookmark

Module 54: Timing Slide Transitions

Module 55: Sections

Module 56: Comments

Module 57: Compare and Merge Presentations

Module 58: Store and Share Presentations on the Web

Module 59: Annotate a Presentation

Module 60: Presenter View

Module 61: Setup Show

Module 62: Create a Custom Slide Show

Module 63: Adding Hyperlinks

Module 64: Action Buttons

Module 65: Zoom

Module 66: Record a Presentation

Module 67: Secure a Presentation

Module 68: Broadcast a Slideshow

Module 69: Create a Video

Module 70: Create a CD

Course Completion

Mastering Outlook 2019 - Basics

Module 01: Introduction

Module 02: Navigating the Interface

Module 03: Working with Messages, Part 1

Module 04: Working with Messages, Part 2

Module 05: Accessing Help

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 06: Adding Message Recipients

Module 07: Checking Spelling and Grammar

Module 08: Formatting Message Content

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 09: Attaching Files and Items

Module 10: Receiving Attachments

Module 11: Adding Illustrations

Module 12: Managing Automatic Message Content

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 13: Customizing Reading Options

Module 14: Tracking Messages

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Module 15: Marking Messages: Categories

Module 16: Marking Messages: Flags

Module 17: Organizing with Folders

Check Your Understanding 13

Check Your Understanding 14

Check Your Understanding 15

Module 18: Managing Contacts

Module 19: Managing Contact Groups

Module 20: Viewing Contacts

Check Your Understanding 16

Check Your Understanding 17

Check Your Understanding 18

Module 21: Viewing the Calendar

Module 22: Creating Appointments

Module 23: Scheduling Meetings

Check Your Understanding 19

Check Your Understanding 20

Check Your Understanding 21

Module 24: Creating Tasks

Module 25: Creating Notes

Check Your Understanding 22

Check Your Understanding 23

Check Your Understanding 24

Booster

Course Completion

Mastering Outlook 2019 - Advanced

Module 01: Introduction

Module 02: Modifying Message Properties

Module 03: Adding Email Accounts

Module 04: Customizing Options

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 05: Sorting Messages

Module 06: Filtering Messages

Module 07: Searching and Search Folders

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 08: Managing Junk Email

Module 09: Managing Mailbox Size

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 10: Using Automatic Replies

Module 11: Using Message Rules

Module 12: Creating and Using Quick Steps

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Module 13: Setting Advanced Calendar Options

Module 14: Create and Manage Additional Calendars

Module 15: Managing Meeting Responses

Check Your Understanding 13

Check Your Understanding 14

Check Your Understanding 15

Module 16: Importing and Exporting Contacts

Module 17: Using Electronic Business Cards

Module 18: Assign and Manage Tasks

Check Your Understanding 16

Check Your Understanding 17

Check Your Understanding 18

Module 19: Delegating Access to Outlook Folders

Module 20: Sharing Your Calendar

Module 21: Sharing Your Contacts

Check Your Understanding 19

Check Your Understanding 20

Check Your Understanding 21

Module 22: Archive and Clean Up

Module 23: Online Archive

Check Your Understanding 22

Check Your Understanding 23

Check Your Understanding 24

Booster

Course Completion

Mastering Outlook 2019

Module 01: Introduction

Module 02: Navigating the Interface

Module 03: Working with Messages, Part 1

Module 04: Working with Messages, Part 2

Module 05: Accessing Help

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 06: Adding Message Recipients

Module 07: Checking Spelling and Grammar

Module 08: Formatting Message Content

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 09: Attaching Files and Items

Module 10: Receiving Attachments

Module 11: Adding Illustrations

Module 12: Managing Automatic Message Content

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 13: Customizing Reading Options

Module 14: Tracking Messages

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Module 15: Marking Messages: Categories

Module 16: Marking Messages: Flags

Module 17: Organizing with Folders

Check Your Understanding 13

Check Your Understanding 14

Check Your Understanding 15

Module 18: Managing Contacts

Module 19: Managing Contact Groups

Module 20: Viewing Contacts

Check Your Understanding 16

Check Your Understanding 17

Check Your Understanding 18

Module 21: Viewing the Calendar

Module 22: Creating Appointments

Module 23: Scheduling Meetings

Check Your Understanding 19

Check Your Understanding 20

Check Your Understanding 21

Module 24: Creating Tasks

Module 25: Creating Notes

Check Your Understanding 22

Check Your Understanding 23

Check Your Understanding 24

Module 26: Modifying Message Properties

Module 27: Adding Email Accounts

Module 28: Customizing Options

Check Your Understanding 25

Check Your Understanding 26

Check Your Understanding 27

Module 29: Sorting Messages

Module 30: Filtering Messages

Module 31: Searching and Search Folders

Check Your Understanding 28

Check Your Understanding 29

Check Your Understanding 30

Module 32: Managing Junk Email

Module 33: Managing Mailbox Size

Check Your Understanding 31

Check Your Understanding 32

Check Your Understanding 33

Module 34: Using Automatic Replies

Module 35: Using Message Rules

Module 36: Creating and Using Quick Steps

Check Your Understanding 34

Check Your Understanding 35

Check Your Understanding 36

Module 37: Setting Advanced Calendar Options

Module 38: Create and Manage Additional Calendars

Module 39: Managing Meeting Responses

Check Your Understanding 37

Check Your Understanding 38

Check Your Understanding 39

Module 40: Importing and Exporting Contacts

Module 41: Using Electronic Business Cards

Module 42: Assign and Manage Tasks

Check Your Understanding 40

Check Your Understanding 41

Check Your Understanding 42

Module 43: Delegating Access to Outlook Folders

Module 44: Sharing Your Calendar

Module 45: Sharing Your Contacts

Check Your Understanding 43

Check Your Understanding 44

Check Your Understanding 45

Module 46: Archive and Clean Up

Module 47: Online Archive

Check Your Understanding 46

Check Your Understanding 47

Check Your Understanding 48

Course Completion

Mastering Access 2016 - Intermediate

Module 01: Relational Database Design

Module 02: Creating a Table

Module 03: Creating Table Relationships

Module 04: Creating Query Joins

Module 05: Relating Data within a Table

Module 06: Working with Subdata Sheets

Module 07: Using Field Validation part 1

Module 08: Using Field Validation part 2

Module 09: Using Forms and Record Validation

Module 10: Creating Parameter Queries

Module 11: Summarizing Data

Module 12: Creating Subqueries

Module 13: Creating Action Queries

Module 14: Creating Unmatched and Duplicate Queries

Module 15: Data Normalization

Module 16: Creating a Junction Table

Module 17: Creating a Table Structure

Module 18: Including Control Formatting in a Report

Module 19: Adding a Calculated Field to a Report

Module 20: Adding a Sub-Report to an Existing Report

Course Completion

Excel - Creating Dashboards

Module 01: Creating Range Names (1A)

Module 02: Using Defined Names in a Formula (1B)

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 03: Using Specialized Functions, Part 1 (1C)

Module 04: Using Specialized Functions, Part 2 (1C)

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 05: Applying Data Validation (2A)

Module 06: Using a Data Form (2B)

Module 07: Adding Form Controls (2C)

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Module 08: Using Lookup Functions (3A)

Module 09: Combining Functions (3B)

Check Your Understanding 10

Check Your Understanding 11

Module 10: Creating a Chart

Module 11: Formatting and Modifying Charts (4B)

Module 12: Dual Axis Charts (5A)

Module 13: Forecasting with Trendlines (5B)

Module 14: Creating Chart Templates (5B)

Module 15: Creating Sparklines (5B)

Check Your Understanding 12

Check Your Understanding 13

Check Your Understanding 14

Module 16: Inserting Pivot Tables (6A)

Module 17: Analyzing Pivot Table Data (6B)

Module 18: Analyzing Pivot Table Data, Part 2 (6B)

Module 19: Presenting Data with Pivot Charts (6C)

Module 20: Filtering Data with Slicers (6D)

Check Your Understanding 15

Check Your Understanding 16

Check Your Understanding 17

Excel In 30 Minutes: Worksheets And Workbooks (Basics 9 Of 10)

Module 01: Managing Worksheets, Part 1

Module 02: Managing Worksheets, Part 2

Module 03: Creating a Custom View

Module 04: Managing Worksheet Views

Module 05: Managing Workbook Views

Module 06: Managing Workbook Properties

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Text And Number Formats (Basics 5 Of 10)

Module 01: Applying Text Formats

Module 02: Applying Number Formats

Module 03: Customizing Number Formats

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Printing And Page Layout (Basics 8 Of 10)

Module 01: Printing Workbooks

Module 02: Setting the Page Layout

Module 03: Inserting Page Breaks

Module 04: Configuring Headers and Footers, Part 1

Module 05: Configuring Headers and Footers, Part 2

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Modifying Worksheets (Basics 4 Of 10)

Module 01: Inserting and Deleting Cells

Module 02: Searching and Replacing

Module 03: Using Proofing and Research Tools

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Getting Started (Basics 1 Of 10)

Module 01: Navigating the Interface

Module 02: Selecting Data

Module 03: Using Commands

Module 04: Using Excel Help

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Formatting Cell Contents (Basics 6 Of 10)

Module 01: Aligning Cell Contents

Module 02: Applying Cell Styles

Module 03: Applying Themes

Module 04: Inserting Hyperlinks

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Entering Data (Basics 2 Of 10)

Module 01: Creating a New Workbook

Module 02: Entering Cell Data

Module 03: Using AutoFill

Module 04: Using Flash Fill

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Customizing Options (Basics 10 Of 10)

Module 01: Customizing General Options

Module 02: Customizing the Ribbon

Module 03: Customizing the Quick Access Toolbar

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Conditional Formatting (Basics 7 Of 10)

Module 01: Applying Conditional Formatting to Numbers

Module 02: Applying Conditional Formatting to Text and Dates

Module 03: Applying Comparative Analysis Formatting

Module 04: Using Templates

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel In 30 Minutes: Calculations (Basics 3 Of 10)

Module 01: Creating Formulas

Module 02: Inserting Functions

Module 03: Copying Formulas and Functions

Module 04: Using Absolute References

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

Excel For Project Management

Module 01: Project Charter

Module 02: Requirement Document/Scope

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 03: Issues Log

Module 04: Work Breakdown Structure

Check Your Understanding 4

Check Your Understanding 5

Module 05: Risk Register

Module 06: Communications Plan and Stakeholder Register

Check Your Understanding 6

Check Your Understanding 7

Course Completion

Excel For Mac Basics

Module

Getting started with Excel

Excel for Mac vs Excel for Windows

Data Entry Shortcuts

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Using Formulas and Functions

Copying Formulas and Functions

Relative, Absolute and Worksheet References

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Modifying Cells Columns & Rows

Search & Replace & Spellcheck

Applying Text Formatting

Number Formats & Cell Alignment

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Styles and Themes

Applying Conditional Formatting

Creating a Template

Check Your Understanding 10

Check Your Understanding 11

Check Your Understanding 12

Preview a Workbook

Page Layout & Printing, Part 1

Page Layout & Printing, Part 2

Working with Worksheets

Check Your Understanding 13

Check Your Understanding 14

Check Your Understanding 15

Using Custom Views

Course Completion

Excel – Power Functions

Module 01: Syntax, Criteria, and Wildcards

Module 02: DATEDIF

Module 03: EDATE and EOMONTH

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Check Your Understanding 4

Module 04: CONVERT

Module 05: INDEX and MATCH

Module 06: INDEX MATCH MATCH

Module 07: OFFSET and COUNTA

Check Your Understanding 5

Check Your Understanding 6

Check Your Understanding 7

Check Your Understanding 8

Module 08: SUMPRODUCT

Course Completion

Excel - Intro To Power Pivot

Module 01: Enable and Navigate Power Pivot

Module 02: Managing Data Relationships

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 03: Creating a Power Pivot Report

Module 04: Creating Calculations in Power Pivot

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 05: Creating Key Performance Indicators

Module 06: Creating a Date Table

Module 07: Working with Dates and Time

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Course Completion

Mastering Microsoft Teams - Basics (2022)

Module 01: Introduction

Module 02: Overview and Navigation

Module 03: Chats

Module 04: Status

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 05: Call Basics

Module 06: Teams and Channels

Check Your Understanding 4

Check Your Understanding 5

Module 07: Channel Posts and Conversations

Module 08: Formatting a Post

Module 09: Joining or Creating a Team

Check Your Understanding 6

Check Your Understanding 7

Module 10: Organizing Teams and Channels

Module 11: Teams Meetings

Module 12: Meeting Functions

Check Your Understanding 8

Check Your Understanding 9

Module 13: File Basics

Module 14: Managing Multiple Teams Environments

Module 15: Activity Feed and Notifications

Module 16: Search and Find

Check Your Understanding 10

Check Your Understanding 11

Mastering Visio - Basics

Module 01: Introduction

Module 02: Navigating the Interface

Module 03: Using Help

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 04: Using Drawing Components

Module 05: Modifying a Drawing

Module 06: Working with Callouts and Groups

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 07: Creating a Basic Organization Chart

Module 08: Doing More With Organizational Charts

Module 09: Creating an Organizational Chart Using the Wizard

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Microsoft Teams Fundamentals And Best Practices (2022)

Module 01: Teams and Channels

Module 02: Tags and Notifications

Module 03: Chat, Calls, and Meetings

Module 04: Best Practices - Teams and Channels

Module 05: Best Practices - Notifications and Tagging

Module 06: Best Practices - Conversations and Meetings

Module 07: Best Practices - Files

Course Completion

Saving Time In Outlook

Module 01: Introduction

Module 02: Taking Quick Action

Module 03: Saving Time with AutoText

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 04: Getting Organized with Color

Module 05: Setting Up Daily Tasks

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 06: Automating Email Management

Module 07: Searching in Outlook

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Course Completion

Microsoft Teams In 30 Minutes (2021)

Module 01: Teams and Channels

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 02: Chat and Meetings

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Module 03: Updates

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Course Completion

Word In 30 Minutes: Working Efficiently (Basics 4 Of 7)

Module 01: Using Find and Replace

Module 02: Applying Repetitive Formatting

Module 03: Using Styles

Module 04: Creating a Style

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Course Completion

What’s New In PowerPoint 2019?

Module 01: Morph Transition

Module 02: 3D Models

Module 03: Vector Graphics

Module 04: Updated Inking, Part 1

Module 05: Updated Inking, Part 2

Module 06: Several Small Updates

Module 07: Zoom

Module 08: Recording, Part 1

Module 9: Recording, Part 2

Module 10: Translation and Dictation

Module 11: Accessibility

Course Completion

SharePoint Online Essentials (2018)

Module 01: Intro to SharePoint Online

Module 02: SharePoint - Creating Team Sites

Module 03: SharePoint - Communication Sites

Module 04: SharePoint - Adding Pages

Check Your Understanding

Course Completion

Mastering Microsoft Project Part 2 - Managing A Project (2016)

Module 01: Enter Task Progress (1A)

Module 02: Update Task Progress with SharePoint (1B)

Module 03: Update Work (1C)

Module 04: Update Costs (1D)

Check Your Understanding 1

Check Your Understanding 2

Module 05: View Project Progress (2A)

Module 06: Enter Task Progress (2B)

Module 07: Create Custom Views (2C)

Module 08: Create a Network Diagram (2D)

Module 9: Analyze a Project Plan (2E)

Check Your Understanding 3

Check Your Understanding 4

Check Your Understanding 5

Module 10: Edit a Task List (3A)

Module 11: Reschedule Tasks (3B)

Module 12: Update a Baseline (3C)

Lesson 10: Edit a Task List (3A)

Lesson 11: Reschedule Tasks (3B)

Lesson 12: Update a Baseline (3C)

Module 13: Format and Share a Chart View (4A)

Module 14: View Existing Reports (4B)

Module 15: Create Custom Reports (4C)

Module 16: Create a Visual Report (4D)

Check Your Understanding 9

Check Your Understanding 10

Check Your Understanding 11

Module 17: Change Project Options (5A)

Module 18: Create a Project Plan Template (5B)

Module 19: Share Resources (5C)

Module 20: Link Project Plans (5D)

Check Your Understanding 12

Check Your Understanding 13

Check Your Understanding 14

Course Completion

Mastering Microsoft Project Part 1 - Creating A Project (2016)

Module 01: Project Management Concepts Pt 1 (1A)

Module 02: Project Management Concepts, Pt 2 (1A2)

Module 03: Navigating Around MS Project (1B)

Check Your Understanding 1

Check Your Understanding 2

Module 04: Create a New Project Plan (2A)

Module 05: Define a Project (2B)

Module 06: Assign a Project Calendar (2C)

Check Your Understanding 3

Check Your Understanding 4

Check Your Understanding 5

Module 07: Add Tasks to a Project Plan (3A)

Module 08: Importing Tasks from Other Programs (3B)

Module 9: WBS, Notes, and Milestones (3C)

Module 10: Define Task Relationships (3D)

Module 11: Schedule Tasks (3E)

Check Your Understanding 6

Check Your Understanding 7

Check Your Understanding 8

Module 12: Add Resources to Plan (4A)

Module 13: Create a Resource Calendar (4B)

Module 14: Enter Costs for Resources (4C)

Module 15: Assign Resources to Tasks (4D)

Module 16: Resolve Resource Conflicts (4E)

Check Your Understanding 9

Check Your Understanding 10

Check Your Understanding 11

Module 17: Optimize a Project Plan (5A)

Module 18: Set a Baseline (5B)

Module 19: Share a Project Plan (5C)

Check Your Understanding 12

Check Your Understanding 13

Check Your Understanding 14

Course Completion

OneNote For Windows 10 Essentials

Module:

Introduction

Getting Started

Creating a Notebook

Customizing the Interface

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Editing Pages

Inserting Tables

Embedding Files

Inserting Pictures

Inserting Links

Recording Audio

Inserting Meeting Details

Using the Researcher Tool

Using Math Functions

Using Drawing Tools

Using Immersive Reader

Dictating Text

Page Format and Accessibility

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Searching

Sending to OneNote

Deleting a Notebook

Inserting Screen Clippings

Sharing a Notebook

Check Your Understanding 7

Check Your Understanding 8

Check Your Understanding 9

Course Completion

Mastering Access 2016 - Basics

Module 01: Introduction (1A)

Module 02: Database Objects (1A)

Module 03: Creating a Simple Access Database (1B)

Module 04: Getting Help and Configuring Options (1C)

Module 05: Modifying Table Data (2A)

Module 06: Sorting and Filtering Records (2B)

Module 07: Creating Basic Queries (3A)

Module 08: Filtering Data in a Query (3B)

Module 9: Sorting Data in a Query (3B)

Module 10: Performing Calculations in a Query (3C)

Module 11: Creating Basic Access Forms

Module 12: Working with Data on Access Forms

Module 13: Lookup Fields on a Form

Module 14: Creating a Report

Module 15: Adding Controls to a Report

Module 16: Adding Logos and Colors

Module 17: Preparing a Report for Print

Module 18: Organizing Report Information

Module 19: Formatting Reports

Course Completion

What’s New In Outlook 2019?

Module 01: New Integration with OneDrive

Module 02: Focused Inbox

Module 03: Icons

Check Your Understanding 1

Check Your Understanding 2

Check Your Understanding 3

Module 04: Accessibility Features

Module 05: New Calendar Features

Module 06: Additional New Features

Module 07: Groups

Check Your Understanding 4

Check Your Understanding 5

Check Your Understanding 6

Check Your Understanding 7

Course Completion