OFFICE-365.AE1
Microsoft Office 365
Get access to fun, practical & in-demand skills in the world’s most popular productivity suite with the comprehensive Microsoft 365 Office course. This Microsoft Office 365 course is designed to help you launch your career in any enterprise environment.
- Practice in 153 Hands-On Labs — nothing to install
- 42 Interactive Lessons and 347 topics mapped to the official exam objectives
Intermediate Self-paced · 1 year access
153 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
42Interactive Lessons
347Topics
153LiveLab
213Flashcards
213Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
Stop battling with confusing menus and realize the full power of the Microsoft 365 environment!
The comprehensive Microsoft 365 training course covers all you need, from fundamental document creation in Word to advanced data analysis in Excel, impactful presentations in PowerPoint, effective communication in Outlook and Teams, and basic database management in Access.
Get Office 365 online training to become a vital asset in today's corporate world. Take your career to the next level. Mastery of Microsoft 365 is a global standard and a necessary step toward advanced jobs and certifications.
This Microsoft 365 course will provide you with an excellent opportunity to advance your career by demonstrating your ability to operate successfully with the technologies that almost every business on the planet uses.
- Advanced Data & Analysis: Master Excel formulas, functions & robust pivot tables for quick & comprehensive data analytics & reporting.
- Professional Content Creation: Become a word expert by simply mastering the styles, templates, tables & advanced formatting for more polished, professional documents.
- Collaborative Communication: Manage your email seamlessly with the Outlook rules & learn more about Microsoft Teams for efficient channel conversations, file sharing & meetings.
- File Management & Cloud Use: Learn more about effective file synchronization, sharing & secure organization using OneDrive & basic database creation in Access.
- AI-Powered Efficiency: Opt for the power Co-Pilot to draft, edit & analyze data across the suite, boosting your productivity instantly.
Course Highlights
-
42 Structured Lessons Comprehensive coverage of core course objectives
-
153 Hands-On LiveLabs Interactive guided scenarios with instant evaluation
-
1 Year Full Access Self-paced learning accessible anytime on all devices
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
42 Interactive Lessons · 347 topics01 Introduction 3 topics +
- About This Course
- False Assumptions
- Icons Used in This Course
02 Getting Your Bearings 4 topics · 1 LiveLab +
- Saying “Hello” to Office 365
- Navigating the Office 365 Apps
- Saving Your Files
- Opening and Closing Files
1 LiveLab in this lesson — see the labs panel →
03 Populating Documents with Text 6 topics · 7 LiveLab +
- Messing with Capitalization
- Entering Symbols, Foreign Letters, and Other Oddball Characters
- Forging Hyperlinks
- Dictating the Words
- Manipulating Text Like a Pro
- Formatting Text for Fun and Profit
7 LiveLab in this lesson — see the labs panel →
04 Becoming Enviously Efficient 5 topics · 2 LiveLab +
- Undoing and Repeating Commands
- Zooming In, Zooming Out
- Viewing a File Through More Than One Window
- Correcting Typos on the Fly
- Entering Text Quickly with the AutoCorrect Command
2 LiveLab in this lesson — see the labs panel →
05 Making Office 365 Your Own 5 topics · 1 LiveLab +
- Giving the Ribbon a Facelift
- Refurbishing the Quick Access Toolbar
- Sprucing Up the Status Bar
- Changing the Screen Background and Office Theme
- Customizing Keyboard Shortcuts in Word
1 LiveLab in this lesson — see the labs panel →
06 Handling Graphics and Photos 8 topics · 4 LiveLab +
- Plopping a Shape into a Document
- Livening Up a Document with a Picture
- Sprucing Up Your Work with a Stock Image
- Cobbling Together a SmartArt Graphic
- Tossing In a Text Box
- Turning Text into a Work of Art with WordArt
- Creating a Drop Cap in Word
- Messing Around with Graphic Objects
4 LiveLab in this lesson — see the labs panel →
07 Getting Up to Speed with Word 4 topics · 1 LiveLab +
- Cranking Out a Shiny, New Word Document
- Fussing with the View
- Snappier Ways to Edit and Format Text
- Navigating Like a Pro
1 LiveLab in this lesson — see the labs panel →
08 Laying Out Pages Just So 8 topics · 4 LiveLab +
- Them's the Breaks
- Managing Margins
- Shifting Text Sideways with Indents
- Making Heads and Tails of Headers and Footers
- Breathing Room: Setting the Spacing
- Making Lists, Optionally Checking Them Twice
- Getting Things to Line Up Nice and Neat with Tabs
- Hyphenating Text
4 LiveLab in this lesson — see the labs panel →
09 Making Looking Good Look Easy: Styles 5 topics · 5 LiveLab +
- Getting Acquainted with Styles
- Making Your Documents Stylish
- Concocting a New Style
- Tweaking a Style
- Creating and Managing Templates
5 LiveLab in this lesson — see the labs panel →
10 Building a Table with Your Bare Hands 8 topics · 4 LiveLab +
- What Is a Table?
- Constructing a Table
- Selecting Table Bits and Pieces
- Populating the Table
- Messing with the Table Layout
- Refinishing Your Table
- Getting Your Geek on with Table Formulas
- Picking Up a Few Table Tricks
4 LiveLab in this lesson — see the labs panel →
11 Polishing Your Prose 5 topics · 3 LiveLab +
- Correcting Spelling Slip-Ups
- Fixing Grammar Gaffes
- Getting the Editor on the Job
- Using the Splendiferous Thesaurus
- Finding and Replacing Text
3 LiveLab in this lesson — see the labs panel →
12 Designing Fancy-Schmancy Documents 5 topics · 5 LiveLab +
- Giving a Document a Makeover with a Theme
- Adding Some Finishing Touches
- Corralling Text into Columns
- Laying Out Text in Linked Text Boxes
- Trying Out More of Word’s Page Setup Options
5 LiveLab in this lesson — see the labs panel →
13 Printing Envelopes and Labels 3 topics · 3 LiveLab +
- Addressing an Envelope
- Addressing a Label (or a Page of Labels)
- Churning Out Letters, Envelopes, and Labels for Mass Mailings
3 LiveLab in this lesson — see the labs panel →
14 Advanced (But Useful) Document Design 6 topics · 6 LiveLab +
- Keeping a Document Organized with an Outline
- The Bird's-Eye View: Creating a Table of Contents
- Organizing Images with Captions and Tables of Figures
- Supplementing Your Text with Footnotes and Endnotes
- Naming Names: Inserting Citations and Bibliographies
- Making an Index, Checking It Twice
6 LiveLab in this lesson — see the labs panel →
15 Writing and Editing with Copilot at Your Side 6 topics · 2 LiveLab +
- Getting to Know Copilot
- Drafting New Text
- Adding Text to an Existing Document
- Transforming Existing Text
- Referencing a File
- Getting Copilot's Help with a Document
2 LiveLab in this lesson — see the labs panel →
16 Excel: The 50-Cent Tour 3 topics · 2 LiveLab +
- Getting Comfy with the Excel Window
- Creating Fresh Workbooks
- Data Entry 101
2 LiveLab in this lesson — see the labs panel →
17 Sprucing Up a Worksheet 5 topics · 3 LiveLab +
- Selecting Cells and Ranges
- Adjusting Columns and Rows
- Formatting Cells from the Ribbon
- Formatting Numbers, Dates, and Time Values
- Hiring Out the Format Painter
3 LiveLab in this lesson — see the labs panel →
18 Fiddling with Your Worksheets 3 topics · 5 LiveLab +
- Editing a Cell
- A Worksheet with a View
- Copying and Moving Stuff Around
5 LiveLab in this lesson — see the labs panel →
19 Taming Your Worksheets 2 topics · 6 LiveLab +
- Revamping a Worksheet
- Overhauling a Workbook
6 LiveLab in this lesson — see the labs panel →
20 Building Basic Formulas 5 topics · 6 LiveLab +
- Getting Started with Formulas
- Augmenting Formulas with Functions
- Copying Formulas
- Adding Array Formulas
- Naming Cells and Ranges
6 LiveLab in this lesson — see the labs panel →
21 Analyzing Data 5 topics · 3 LiveLab +
- Getting Quick Analyses from Excel
- Eyeballing Trends and Outliers with Conditional Formatting
- Managing Information in Tables
- What If You Used What-If Analysis?
- Summarizing Data with PivotTables
3 LiveLab in this lesson — see the labs panel →
22 Visualizing Data with Charts 4 topics · 3 LiveLab +
- Learning Some Crucial Chart Basics
- Forging a Fresh Chart
- Selecting Chart Elements
- Dressing Up Your Charts
3 LiveLab in this lesson — see the labs panel →
23 Automating Excel with Copilot 6 topics · 7 LiveLab +
- Getting Copilot on the Job
- Analyzing Data
- Creating Formulas
- Highlighting Data
- Sorting and Filtering Data
- Visualizing Data
7 LiveLab in this lesson — see the labs panel →
24 Putting Together a PowerPoint Presentation 9 topics · 9 LiveLab +
- Producing a New PowerPoint Presentation
- Perusing the PowerPoint Window
- It's All About the Slides
- Adding a Slide to the Presentation
- Filling Out a Slide with Data
- Getting Copilot to Help
- Messing Around with Slides
- Building a Presentation from an Outline
- Peeking Behind the Curtain: The Slide Master
9 LiveLab in this lesson — see the labs panel →
25 Formatting Slides 4 topics · 5 LiveLab +
- Applying a Slide Theme
- Formatting Slide Text
- Formatting Tips and Techniques
- Slide Formatting Best Practices
5 LiveLab in this lesson — see the labs panel →
26 Creating Dynamic Presentations 4 topics · 4 LiveLab +
- Animation Guidelines
- Setting Up a Slide Transition
- Defining Slide Animations
- Setting Up Hyperlinks and Action Buttons
4 LiveLab in this lesson — see the labs panel →
27 Delivering a Presentation 4 topics · 3 LiveLab +
- Rehearsing Slide Timings
- Adding Voice and Video
- Creating a Custom Slide Show
- Running a Slide Show
3 LiveLab in this lesson — see the labs panel →
28 Sending and Receiving Email 5 topics · 1 LiveLab +
- Setting Up Your Accounts
- Getting Acquainted with Outlook
- Shipping Out a New Message
- Reading Incoming Mail
- Using Rules to Process Messages Automatically
1 LiveLab in this lesson — see the labs panel →
29 Managing Your Contacts 4 topics · 3 LiveLab +
- Exploring the People App
- Adding a New Contact
- Working with Your Contacts
- Performing Contact Tasks
3 LiveLab in this lesson — see the labs panel →
30 Keeping Track of Appointments 5 topics · 1 LiveLab +
- Getting Together with the Calendar App
- Items You Can Schedule in Calendar
- Setting Up an Event
- Scheduling an All-Day Event
- Requesting a Meeting
1 LiveLab in this lesson — see the labs panel →
31 Forging Databases and Tables 7 topics · 3 LiveLab +
- Understanding Access Databases
- Creating an Access Database
- Working in the Navigation Pane
- Designing a Table
- Creating a Table
- Importing External Data
- Creating and Using Forms
3 LiveLab in this lesson — see the labs panel →
32 Entering, Sorting, and Filtering Data 22 topics · 5 LiveLab +
- The Population Boom: Entering Data
- Getting comfy with the Datasheet view
- Navigating field-to-field
- Entering data
- Adding more records
- Navigating records
- Selecting a record
- Deleting a record
- Formatting the datasheet
- Putting Things in Apple-Pie Order: Sorting Records
- Sorting on a single field
- Sorting on multiple fields
- Knocking Things Down to Size: Filtering Data
- Filtering by field value
- Filtering by partial field value
- Filter excluding field value
- Filter excluding partial field value
- Filtering by form
- Creating an advanced filter
- Relating Multiple Tables
- Understanding referential integrity
- Relating tables
5 LiveLab in this lesson — see the labs panel →
33 Querying Data 18 topics · 6 LiveLab +
- Designing a Simple Query
- Adding fields to the query
- Specifying the query criteria
- Running the query
- Getting Comfy with Query Criteria
- Using operands in criteria expressions
- Using operators in criteria expressions
- Working with the Expression Builder
- Using Calculations in Queries Like a Pro
- Constructing a totals column
- Setting up a calculated column
- Getting Fancy with a Multiple-Table Query
- Adding multiple tables to a query
- Adding fields from multiple tables
- Modifying Table Data with an Update Query
- Removing Records from a Table with a Delete Query
- Creating a New Table with a Make Table Query
- Adding Records to a Table with an Append Query
6 LiveLab in this lesson — see the labs panel →
34 Getting around in Teams 19 topics · 4 LiveLab +
- Introducing Teams
- Taking a Look Around
- Personalizing Teams to Use It Effectively
- Adding a profile photo
- Setting your status
- Setting up priority access
- Customizing Teams via settings
- Noticing Notifications
- Filtering and Searching
- Filtering your Activity feed
- Searching for a post, message, or other content
- Saving time with slash commands
- Using Teams to Know Your Colleagues Better
- Viewing a person’s profile card
- Viewing the org chart
- Enhancing Your Teams Experience with Helpful Extras
- Using built-in apps
- Using tabs
- Using the Teams App store
4 LiveLab in this lesson — see the labs panel →
35 Getting Up to Speed with Teams and Channels 16 topics · 5 LiveLab +
- What’s All This About a Team? And a Channel?
- Managing and Working with a Team or Two
- Joining an existing team
- Opening a team and viewing its channels
- Creating a team
- Adding people to a team
- Sharing a team
- Managing team settings
- Leaving a team
- Getting to Know Channels
- Creating a channel
- Using private channels
- Renaming a channel
- Pinning a channel
- Taming channel notifications
- Hiding a channel
5 LiveLab in this lesson — see the labs panel →
36 Chin-wagging with Channels and Chats 16 topics · 2 LiveLab +
- Channels versus Chats
- Conversing in a Channel
- Configuring channel moderation
- Getting a conversation off the ground
- Getting in your two cents: replying to a conversation
- @mentioning in a conversation
- Reacting to conversations
- More conversation options to mess with
- Bouncing between Teams conversations and Outlook emails
- Chatting with Your Team
- Sending someone a quick message
- Starting a private or group chat
- Keeping the chat going: responding to a chat message
- Renaming a chat
- Adding and removing people (including yourself) from a chat
- Setting chat and message options
2 LiveLab in this lesson — see the labs panel →
37 Fiddling with Files in Teams 12 topics · 2 LiveLab +
- Getting to Know Teams’ Files Tools
- Sharing Files in a Team
- Attaching a file to a channel post
- Uploading a file or folder from the Files tab
- Creating a file or folder in a team
- Managing files and folders
- Understanding where channel files are stored
- Adding a new document library to access in Teams
- Sharing Files in a Chat
- Attaching a file to a chat post
- Using the Shared tab in a chat
- Understanding where files shared in a chat are stored
2 LiveLab in this lesson — see the labs panel →
38 Getting Together for Online Meetings 25 topics · 2 LiveLab +
- Getting a Meeting Off the Ground
- Scheduling a meeting
- Launching an immediate meeting
- Using dial-in conference lines
- Joining in the Meeting Fun
- Joining from a browser
- Joining a channel meeting
- Setting your meeting video, audio, and effects options
- Participating in a Meeting
- Adding people to the meeting
- Viewing the participants list
- Changing the view
- Pinning and spotlighting participants
- Muting yourself and others
- Sharing your screen and content
- Using PowerPoint Live
- Sharing files in a meeting
- Viewing the meeting chat
- Recording the meeting
- Using live captions and transcription
- Reacting and raising your hand
- Messing with meeting options
- Using breakout rooms
- Leaving and ending the meeting
- Finding Resources after a Meeting
2 LiveLab in this lesson — see the labs panel →
39 Sharing Files 16 topics · 2 LiveLab +
- Knowing when to Use OneDrive or SharePoint
- When to use OneDrive
- When to use SharePoint
- Syncing Office 365 Files to Your Devices
- Linking OneDrive to your Office 365 business account
- Keeping files always available on your device
- Syncing Teams and SharePoint files to your device
- Staying Sane When Editing Files
- Editing Office files in their desktop versus web versions
- Editing Office files with colleagues
- Keeping track of a file’s version history
- Using the Recycle Bin to Restore Deleted Files
- Copying and Moving Files between OneDrive and Teams
- Sharing Files Outside Your Organization
- Sharing a file
- Sharing a link
2 LiveLab in this lesson — see the labs panel →
40 Making the Most of OneDrive 11 topics · 5 LiveLab +
- Getting Started in OneDrive
- Navigating the navigation pane
- Viewing and locating stuff in OneDrive
- Managing Your OneDrive Content
- Selecting files and folders
- Performing actions on files and folders
- Creating a folder
- Creating a file
- Uploading files and folders
- Managing File and Folder Permissions
- Adding SharePoint and Teams Files to OneDrive
5 LiveLab in this lesson — see the labs panel →
41 Collaborating in SharePoint 17 topics · 4 LiveLab +
- Getting Oriented with SharePoint
- Managing SharePoint Team Sites
- Understanding the connection between SharePoint team sites and Microsoft 365 groups
- Finding your way around a team site
- Adding members
- Getting familiar with site permissions
- Working with SharePoint Pages
- Creating a page
- Enhancing a page with web parts
- Working with Document Libraries
- Creating a new document library
- Uploading files to a document library
- Opening and editing a file in a document library
- Sharing files from a document library
- Viewing file and folder options
- Working with columns and views
- Taking a Brief Look at Microsoft Lists
4 LiveLab in this lesson — see the labs panel →
42 Collaborating on Documents 19 topics · 4 LiveLab +
- Protecting a Document from Mischief
- Opening a document as read-only
- Marking a document as final
- Protecting a document with a password
- Commenting on a Word Document
- Entering comments
- Viewing and displaying comments
- Replying to and resolving comments
- Caring for and feeding comments
- Tracking Changes to Documents
- Telling Word to start marking changes
- Reading and reviewing a document with revision marks
- Accepting and rejecting changes to a document
- Marking changes when you forgot to turn on revision marks
- Documenting a Worksheet with Notes
- Collaborating on a Workcourse with Comments
- Keeping Others from Tampering with Worksheets
- Hiding a worksheet
- Protecting a worksheet
4 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
153 LiveLabs- Changing the Heading Style
- Changing the Capitalization of a Text
- Inserting a Symbol
- Copying and Saving a Text
- Formatting the Text to Bold
- Changing the Text Color
- Changing the Font Style and Font Size
- Formatting the Text to Italic
- Setting the Zoom Level of a Document
- Checking the Spelling Automatically
- Exporting Ribbon Customizations as a File
- Inserting a Shape
- Adding a SmartArt
- Applying a Shape Style
- Applying a Gradient Fill to the Shape
- Creating and Saving a Document
- Indenting the First Line of a Paragraph
- Creating Header and Footer
- Creating a Bulleted List
- Setting the Tab Stop
- Enabling Automatic Hyphenation
- Applying the Heading Style
- Creating a New Style
- Modifying the Text Style
- Creating a Document Using a Template
- Inserting a Table
- Sorting the Contents of a Table
- Creating and Applying the New Table Style
- Merging the Cells and Alignment of the Column
- Configuring Spelling and Grammar Options
- Using the Thesaurus Tool
- Using Find and Replace to Edit
- Applying a Customized Theme
- Adding a Watermark to a Document
- Formatting the Text into Columns
- Linking the Text Box to another Text Box
- Controlling Page Layout
- Creating an Envelope Document
- Creating and Customizing Labels
- Performing a Mail Merge
- Creating an Outline
- Promoting and Demoting Topics
- Inserting a Table of Contents
- Creating a Table of Figures
- Marking Legal Citations
- Indexing a Document
- Exploring Copilot's Features
- Referencing Files
- Creating and Saving a Workbook
- Creating Custom AutoFill Lists
- Adjusting the Columns
- Hiding the Rows
- Hiding the Columns
- Adding and Replacing Data in a Cell
- Deleting a Row
- Inserting a Cell Range
- Freezing the Top Row
- Copying and Pasting the Data
- Deleting a Column
- Adding Color to the Worksheet Tab
- Making a Copy of the Worksheet
- Adding a New Worksheet
- Hiding a Worksheet
- Deleting a Worksheet
- Creating Worksheet Formulas
- Calculating the Sum
- Using the TODAY Function
- Adding the Arguments for the IF Portion of the Nested Function
- Creating Named Ranges
- Editing Range Names
- Creating a Forecast Sheet
- Converting the Data into a Table
- Adding Fields to the PivotTable
- Creating the Combo Chart
- Changing the Chart Type
- Changing the Labels of the Line Chart
- Using the MATCH Function
- Using the INDEX Function
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the SORT Function
- Using the FILTER Function
- Creating Sparklines
- Creating and Saving a Basic Presentation
- Moving a Slide in the Normal View
- Arranging a Slide in the Slide Sorter View
- Reusing Slides from Another Presentation
- Inserting a New Slide into the Presentation
- Inserting Content into a Placeholder
- Inserting an Image from the Desktop
- Modifying the Slide Layout
- Hiding a Slide
- Applying a New Theme to the Slide Master
- Modifying the Background Style of the Slide Master
- Converting Text to a SmartArt Graphic
- Using Underline in the Title Text
- Using the Mini Toolbar to Change the Color of the Text on a Slide
- Applying the Morph Transition to a Shape
- Applying and Modifying Animation Effects to a Graphic
- Animating a SmartArt Graphic
- Adding an Action Button
- Recording a Presentation
- Creating and Modifying a Custom Slide Show
- Annotating a Presentation
- Creating an Email Signature in Microsoft Outlook
- Logging into Microsoft Outlook
- Managing and Importing Contacts in Microsoft Outlook
- Sorting and Exporting Contacts in Microsoft Outlook
- Marking Messages as Read/Unread in Microsoft Outlook
- Creating a New Database
- Creating a New Table
- Creating a Form by Using the Form Wizard
- Adding a Total Row to a Datasheet
- Revising and Entering Table Data
- Sorting and Filtering Records
- Preparing Keys for Table Relationships
- Establishing Table Relationships
- Creating a Query Using Query Design
- Using Queries
- Filtering a Query Using Dates
- Filtering a Query Using a Comparison Operator
- Performing Calculations in a Query
- Sorting a Query and Reordering Fields
- Setting Automatic Out-of-Office Replies in Microsoft Outlook
- Managing Priority Access in Microsoft Teams
- Working with Microsoft Teams Notifications and Appearance Settings
- Exploring and Integrating Apps in Microsoft Teams
- Joining an Existing Team
- Creating a Team
- Creating and Managing Channels
- Renaming and Managing Channels
- Customizing Channel Visibility and Names
- Configuring Channel Moderation
- Creating and Managing Posts
- Attaching and Sharing Files
- Creating and Integrating Document Libraries
- Scheduling Meetings in Microsoft Teams
- Sharing and Recording in Microsoft Teams Meetings
- Syncing Files from SharePoint to Your Device
- Sharing Files Securely in Microsoft 365
- Logging into OneDrive
- Creating and Organizing Folders in OneDrive
- Creating a File in Microsoft Teams
- Navigating and Sharing Files in OneDrive
- Managing Permissions and Shortcuts in OneDrive
- Creating and Managing SharePoint Team Sites
- Managing Site Permissions in SharePoint
- Creating and Designing Pages in SharePoint
- Granting and Managing Permissions in SharePoint Document Libraries
- Assigning Password Protection to Office Documents
- Managing Comments in Microsoft Word
- Managing and Reviewing Document Changes
- Working with Notes in Microsoft Excel
Labs run in your browser — nothing to install.
03 / FAQs
Questions before you start
Who should take this Microsoft Office 365 course?+
This course is perfect for those who want to master the productivity tools—students, office administrators, and sales & IT professionals seeking a boost to their skills through Microsoft 365 content.
Cisco now uses a core exam plus one concentration exam, streamlining the process compared to the old three-exam model.
Do I need to be tech-savvy to start the Microsoft 365 training?+
Absolutely not! Only basic computer skills are required. We begin with beginner’s topic & then move forward to complex topics.
What exactly will I learn about Copilot?+
You will learn how to take advantage of Copilot to draft new content, transform existing text, analyze data in Excel & streamline your workflow, which makes you incredibly efficient.
Keep going
You might also like
Master Productivity: Enroll Now!
Enroll in our Microsoft Office 365 Course today & start your professional Microsoft 365 training.
- 1 year of full access
- 153 LiveLab included
- Certificate of completion
No credit card required