Course Code: 5700

Microsoft Office 2016, 2019, 2021, Excel, Word, Outlook, PowerPoint - Basic

Class Dates:
1 Days
Class Time:
Instructor-Led Training, Virtual Instructor-Led Training


  • Course Overview
  • This course covers the Microsoft Office Suite including Excel, PowerPoint, Publisher , OneNote , Outlook , Windows Mobile Office Apps and Word.

    You will learn the new features and tools.
    You will learn how to edit Adobe Acrobat Files.
    You will learn the Office interface.
    You will learn how to Manage and Share Files.
  • Audience
  • This course is intended for individuals who are interested in the foundational knowledge and skills in Office.


  • No prerequisites are necessary.

Course Details

  • Introduction to the Office Application Suite
  • Getting Oriented to the Office Applications
  • New Features and Tools in Office
  • Saving and Sharing Files in the Cloud
  • Editing Adobe Acrobat Files
  • Navigating and Customizing the Office Interface
  • Working with the Ribbon
  • Customizing an Application Interface
  • Using Office Add-ins, Using the Trust Center
  • Creating, Managing and Sharing Files
  • Using and Creating Graphics, Working with Your Digital Pictures
  • Using the Office Apps, Word, Excel PowerPoint, Windows Online Apps
  • Introducing Word
  • Options for Creating a New Word Document
  • Using, Creating and Attaching a Templates
  • Navigating a Word Document, Moving Around a Document with the Keyboard
  • Understanding Document Formatting
  • Working with Fonts and Text Formatting
  • Working with Paragraph Formatting, Page Layout: Margins and Page Options
  • Printing Documents, Enhancing Word Documents
  • Working with Borders and Shading, Formatting with Themes
  • Creating Headers and Footers, Inserting Pictures, Clip Art, and Charts
  • Changing the Document Display, Using the Review Tools, Working with Quick Parts
  • Configuring AutoCorrect, Understanding Styles, Working with Tables, Columns, and Sections
  • Managing Mailings and Forms, Performing a Mail Merge
  • Introducing Excel
  • Navigating the Excel Workspace, The Excel Ribbon
  • Creating Workbooks and Worksheets, Managing Workbooks
  • Entering Data in a Worksheet, Filing and Entering
  • Copying, Moving, and Deleting Cell Contents, Editing Cell Content, Viewing and Printing Worksheets
  • Worksheet Formatting and Management, Formatting Text Entries, Formatting Values
  • Adding Comments to Cells, Using Themes, Formatting Cells Using Borders and Color
  • Using Cell Styles and the Format Painter, Using Conditional Formatting
  • Manipulating Cells and Cell Content, Working with Columns and Rows, Working with Worksheets
  • Naming Ranges, Formulas and Functions,Performing Calculations
  • Creating and Editing Formulas, Excel Functions, Entering a Function in a Cell
  • Creating Charts, Modifying, Chart Elements, Creating a Combination Chart
  • Using Excel Tables and Pivottables, Working with External Data Working with PivotTables
  • PowerPoint
  • Options for Creating a New Presentation, Creating a Template, Inserting New Slides
  • Working with Slides in Different Views
  • Advanced Presentation Formatting, Themes, and Masters
  • Better Slides with Clip Art, Pictures, and SmartArt
  • Inserting a Picture, Adding Online Images to Slides
  • Creating a Photo Album, Working with Shapes, Adding Charts to Slides
  • Enhancing Slides with Animation, Transitions, and Multimedia
  • Animations versus Transitions, Assigning Animation to a Slide Object,
  • Adding Sound to a Slide, Editing, Adding Video to a Slide
  • Delivering a Presentation and Creating Support Materials, Planning Your Presentation
  • Checking the Presentation for Spelling and Grammar Errors, Using the Presenter View
  • Creating a Custom Slide Show, Creating a Self-Running Presentation
  • Introducing Outlook
  • Outlook and Email Accounts, Configuring Outlook at First Star
  • Understanding Outlook Profiles, Understanding Outlook Data Files
  • Importing and Exporting Data, Navigating the Outlook Workspace, Printing Outlook Items
  • Managing Email in Outlook, Working in the Mail Folder
  • Creating an Email Message, Using the Outlook Address Book,
  • Attaching Files and Items to a Message, Using Themes and Email Stationery
  • Adding a Signature, Sending Mail, Recalling a Message
  • Managing Email, Setting Outlook Mail Options
  • Using the Calendar for Appointments and Tasks
  • Navigating the Calendar, Scheduling an Appointment, , Sharing Calendars, Working with Tasks
  • Working with Contacts and Planning Meetings
  • Creating a New Contact, Using the Journal and Notes, Securing and Maintaining Outlook
  • Introducing Publisher
  • Planning Your Publication, Working with Publication Templates, Creating a New Publication
  • Creating a Business Information Set, Working with Text
  • Inserting Illustrations, Printing Publications
  • Advanced Publisher Features
  • Adding Pages to a Publication, Configuring Page Settings
  • Working with Master Pages
  • Using Tables in Publications
  • Manipulating Publication Objects
  • Merging Data into a Publication
  • Fine-tuning Your Publications
  • Introducing OneNote
  • Navigating the OneNote Workspace
  • Creating a Notebook, Modifying Notebook Properties
  • Working with Sections, Working with Pages
  • Restoring Sections and Pages from the Notebook Recycle Bin
  • Inserting and Formatting Notes, Using Tags, Finding Tagged Notes, Using Tables to Store Information
  • Working with Notebook Pages, Managing Pages
  • Modifying the Page Setup and View
  • Viewing Page Versions, Viewing Recent Edits, Viewing Changes by Author, Adding Objects to Notebook Pages
  • Printing Notebook Pages,
  • Integrating OneNote with Other Office Applications
  • Taking Linked Notes, Using File Printout, Adding Links, Attaching Files
  • Inserting Screen Clips, Integrating OneNote and Outlook