uCertify

Microsoft 365 Office

(OFFICE-365.AE1)
Lessons
Lab
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

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

Related Courses

All Courses