uCertify

Microsoft 365 Office

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.

(OFFICE-365.AE1) / ISBN : 979-8-90059-010-3
Lessons
Lab
AI Tutor (Add-on)
Get A Free Trial

About This Course

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.

Skills You’ll Get

  • 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. 
Download Course Outline

1

Introduction

  • About This Course
  • False Assumptions
  • Icons Used in This Course
2

Getting Your Bearings

  • Saying “Hello” to Office 365
  • Navigating the Office 365 Apps
  • Saving Your Files
  • Opening and Closing Files
3

Populating Documents with Text

  • 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
4

Becoming Enviously Efficient

  • 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
5

Making Office 365 Your Own

  • 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
6

Handling Graphics and Photos

  • 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
7

Getting Up to Speed with Word

  • Cranking Out a Shiny, New Word Document
  • Fussing with the View
  • Snappier Ways to Edit and Format Text
  • Navigating Like a Pro
8

Laying Out Pages Just So

  • 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
9

Making Looking Good Look Easy: Styles

  • Getting Acquainted with Styles
  • Making Your Documents Stylish
  • Concocting a New Style
  • Tweaking a Style
  • Creating and Managing Templates
10

Building a Table with Your Bare Hands

  • 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
11

Polishing Your Prose

  • Correcting Spelling Slip-Ups
  • Fixing Grammar Gaffes
  • Getting the Editor on the Job
  • Using the Splendiferous Thesaurus
  • Finding and Replacing Text
12

Designing Fancy-Schmancy Documents

  • 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
13

Printing Envelopes and Labels

  • Addressing an Envelope
  • Addressing a Label (or a Page of Labels)
  • Churning Out Letters, Envelopes, and Labels for Mass Mailings
14

Advanced (But Useful) Document Design

  • 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
15

Writing and Editing with Copilot at Your Side

  • 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
16

Excel: The 50-Cent Tour

  • Getting Comfy with the Excel Window
  • Creating Fresh Workbooks
  • Data Entry 101
17

Sprucing Up a Worksheet

  • Selecting Cells and Ranges
  • Adjusting Columns and Rows
  • Formatting Cells from the Ribbon
  • Formatting Numbers, Dates, and Time Values
  • Hiring Out the Format Painter
18

Fiddling with Your Worksheets

  • Editing a Cell
  • A Worksheet with a View
  • Copying and Moving Stuff Around
19

Taming Your Worksheets

  • Revamping a Worksheet
  • Overhauling a Workbook
20

Building Basic Formulas

  • Getting Started with Formulas
  • Augmenting Formulas with Functions
  • Copying Formulas
  • Adding Array Formulas
  • Naming Cells and Ranges
21

Analyzing Data

  • 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
22

Visualizing Data with Charts

  • Learning Some Crucial Chart Basics
  • Forging a Fresh Chart
  • Selecting Chart Elements
  • Dressing Up Your Charts
23

Automating Excel with Copilot

  • Getting Copilot on the Job
  • Analyzing Data
  • Creating Formulas
  • Highlighting Data
  • Sorting and Filtering Data
  • Visualizing Data
24

Putting Together a PowerPoint Presentation

  • 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
25

Formatting Slides

  • Applying a Slide Theme
  • Formatting Slide Text
  • Formatting Tips and Techniques
  • Slide Formatting Best Practices
26

Creating Dynamic Presentations

  • Animation Guidelines
  • Setting Up a Slide Transition
  • Defining Slide Animations
  • Setting Up Hyperlinks and Action Buttons
27

Delivering a Presentation

  • Rehearsing Slide Timings
  • Adding Voice and Video
  • Creating a Custom Slide Show
  • Running a Slide Show
28

Sending and Receiving Email

  • Setting Up Your Accounts
  • Getting Acquainted with Outlook
  • Shipping Out a New Message
  • Reading Incoming Mail
  • Using Rules to Process Messages Automatically
29

Managing Your Contacts

  • Exploring the People App
  • Adding a New Contact
  • Working with Your Contacts
  • Performing Contact Tasks
30

Keeping Track of Appointments

  • Getting Together with the Calendar App
  • Items You Can Schedule in Calendar
  • Setting Up an Event
  • Scheduling an All-Day Event
  • Requesting a Meeting
31

Forging Databases and Tables

  • 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
32

Entering, Sorting, and Filtering Data

  • 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
33

Querying Data

  • 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
34

Getting around in Teams

  • 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
35

Getting Up to Speed with Teams and Channels

  • 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
36

Chin-wagging with Channels and Chats

  • 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
37

Fiddling with Files in Teams

  • 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
38

Getting Together for Online Meetings

  • 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
39

Sharing Files

  • 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
40

Making the Most of OneDrive

  • 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
41

Collaborating in SharePoint

  • 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
42

Collaborating on Documents

  • 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

1

Getting Your Bearings

  • Changing the Heading Style
2

Populating Documents with Text

  • Changing the Capitalization of a Text
  • Inserting a Symbol
  • Copying and Saving a Text
  • Changing the Text Color
  • Changing the Font Style and Font Size
  • Formatting the Text to Italic
  • Formatting the Text to Bold
3

Becoming Enviously Efficient

  • Setting the Zoom Level of a Document
  • Checking the Spelling Automatically
4

Making Office 365 Your Own

  • Exporting Ribbon Customizations as a File
5

Handling Graphics and Photos

  • Inserting a Shape
  • Adding a SmartArt
  • Applying a Shape Style
  • Applying a Gradient Fill to the Shape
6

Getting Up to Speed with Word

  • Creating and Saving a Document
7

Laying Out Pages Just So

  • Indenting the First Line of a Paragraph
  • Creating a Bulleted List
  • Setting the Tab Stop
  • Enabling Automatic Hyphenation
8

Making Looking Good Look Easy: Styles

  • Creating a New Style
  • Modifying the Text Style
  • Creating a Document Using a Template
9

Building a Table with Your Bare Hands

  • Inserting a Table
  • Sorting the Contents of a Table
  • Creating and Applying the New Table Style
  • Merging the Cells and Alignment of the Column
10

Polishing Your Prose

  • Configuring Spelling and Grammar Options
  • Using the Thesaurus Tool
  • Using Find and Replace to Edit
11

Designing Fancy-Schmancy Documents

  • 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
12

Printing Envelopes and Labels

  • Creating an Envelope Document
  • Performing a Mail Merge
13

Advanced (But Useful) Document Design

  • Creating an Outline
  • Promoting and Demoting Topics
  • Inserting a Table of Contents
  • Creating a Table of Figures
  • Marking Legal Citations
  • Indexing a Document
14

Excel: The 50-Cent Tour

  • Creating and Saving a Workbook
15

Sprucing Up a Worksheet

  • Adjusting the Columns
  • Hiding the Rows
  • Hiding the Columns
16

Fiddling with Your Worksheets

  • Adding and Replacing Data in a Cell
  • Deleting a Row
  • Inserting a Cell Range
  • Freezing the Top Row
  • Copying and Pasting the Data
17

Taming Your Worksheets

  • 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
18

Building Basic Formulas

  • 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
19

Analyzing Data

  • Creating a Forecast Sheet
  • Converting the Data into a Table
  • Adding Fields to the PivotTable
20

Visualizing Data with Charts

  • Creating the Combo Chart
  • Changing the Chart Type
  • Changing the Labels of the Line Chart
21

Automating Excel with Copilot

  • 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
22

Putting Together a PowerPoint Presentation

  • Creating and Saving a Basic Presentation
  • Moving a Slide in the Normal View
  • Arranging a Slide in the Slide Sorter View
  • Inserting a New Slide into the Presentation
  • Reusing Slides from Another Presentation
  • Inserting Content into a Placeholder
  • Inserting an Image from the Desktop
  • Modifying the Slide Layout
  • Hiding a Slide
23

Formatting Slides

  • 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
24

Creating Dynamic Presentations

  • Applying the Morph Transition to a Shape
  • Applying and Modifying Animation Effects to a Graphic
  • Animating a SmartArt Graphic
  • Adding an Action Button
25

Delivering a Presentation

  • Recording a Presentation
  • Creating and Modifying a Custom Slide Show
  • Annotating a Presentation
26

Sending and Receiving Email

  • Logging into Microsoft Outlook
  • Marking Messages as Read/Unread in Microsoft Outlook
  • Creating an Email Signature in Microsoft Outlook
  • Working with Microsoft Teams Notifications and Appearance Settings
  • Setting Automatic Out-of-Office Replies in Microsoft Outlook
27

Managing Your Contacts

  • Sorting and Exporting Contacts in Microsoft Outlook
  • Sorting and Exporting Contacts in Microsoft Outlook
  • Managing and Importing Contacts in Microsoft Outlook
  • Exploring Copilot's Features
  • Creating and Managing Channels
28

Keeping Track of Appointments

  • Changing the Calendar Color
  • Creating an Appointment
  • Creating a Recurring Task
29

Forging Databases and Tables

  • Creating a New Database
  • Creating a New Table
  • Creating a Form by Using the Form Wizard
30

Entering, Sorting, and Filtering Data

  • Adding a Total Row to a Datasheet
  • Revising and Entering Table Data
  • Sorting and Filtering Records
  • Preparing Keys for Table Relationships
  • Establishing Table Relationships
31

Querying Data

  • 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
32

Getting around in Teams

33

Getting Up to Speed with Teams and Channels

  • Creating a Teams
34

Chin-wagging with Channels and Chats

35

Fiddling with Files in Teams

36

Getting Together for Online Meetings

  • Scheduling Meetings in Microsoft Teams
37

Sharing Files

  • Logging into OneDrive
38

Making the Most of OneDrive

  • Navigating and Sharing Files in OneDrive
39

Collaborating in SharePoint

  • Creating and Managing SharePoint Team Sites
40

Collaborating on Documents

  • Managing Comments in Microsoft Word

Any questions?
Check out the FAQs

  Want to Learn More?

Contact Us Now

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. 

Absolutely not! Only basic computer skills are required. We begin with beginner’s topic & then move forward to complex topics.

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. 

Related Courses

All Courses