wordpress.simplitrain.com

course

Home / Courses / Microsoft Office

Course Objectives

Upon successful completion of this course, students will be able to create, edit and enhance documents, spreadsheets, emails, presentations and files in Office and Windows 10.

Agenda

  • Topic A: Navigate the Windows 10 Desktop
  • Topic B: Manage the Start Menu
  • Topic C: Sign In to Windows 10

  • Topic A: Navigate Desktop Applications
  • Topic B: Navigate Windows Apps Features
  • Topic C: Navigate the Cortana Virtual Assistant App

  • Topic A: Manage Files and Folders with File Explorer
  • Topic B: Store and Share Files with OneDrive
  • Topic C: Multitask with Open Apps

  • Topic A: Use Microsoft Edge
  • Topic B: Customize Microsoft Edge

  • Topic A: Customize the Start Screen
  • Topic B: Customize the Desktop

  • Topic A: Manage Printers
  • Topic B: Manage Peripheral Devices

  • Topic A: Manage Passwords and Privacy Levels
  • Topic B: Use Windows Defender

  • Identify the Components of the Word Interface
  • Create a Word Document
  • Help

  • Navigate and Select Text
  • Modify Text
  • Find and Replace Text

  • Apply Character Formatting
  • Align Text Using Tabs
  • Display Text as List Items
  • Control Paragraph Layout
  • Apply Borders and Shading
  • Apply Styles
  • Manage Formatting

  • Insert a Table
  • Modify a Table
  • Format a Table
  • Convert Text to a Table

  • Sort a List
  • Renumber a List
  • Customize a List

  • Insert Symbols and Special Characters
  • Add Images to a Document

  • Apply a Page Border and Color
  • Add a Watermark
  • Add Headers and Footers
  • Control Page Layout

  • Check Spelling and Grammar
  • Other Proofing Tools

  • Customize the Word Interface
  • Additional Save Options

  • Sort Table Data
  • Control Cell Layout
  • Perform Calculations in a Table
  • Create a Chart

  • Create and Modify Text Styles
  • Create Custom List or Table Styles
  • Apply Document Themes

  • Resize an Image
  • Adjust Image Appearance
  • Integrate Pictures and Text
  • Insert and Format Screenshots
  • Insert Video

  • Create Text Boxes and Pull Quotes
  • Draw Shapes
  • Add WordArt and Other Text Effects
  • Create Complex Illustrations with SmartArt

  • Insert Building Blocks
  • Create and Modify Building Blocks
  • Insert Fields Using Quick Parts

  • Control Paragraph Flow
  • Insert Section Breaks
  • Insert Columns
  • Link Text Boxes to Control Text Flow

  • Create a Document Using a Template
  • Create a Template

  • The Mail Merge Features
  • Merge Envelopes and Labels
  • Create a Data Source Using Word

  • Automate Tasks Using Macros
  • Create a Macro

  • Modify User Information
  • Share a Document
  • Compare Document Changes
  • Review a Document
  • Merge Document Changes
  • Review Tracked Changes
  • Coauthor Documents

  • Add Captions
  • Add Cross-References
  • Add Bookmarks
  • Add Hyperlinks
  • Insert Footnotes and Endnotes
  • Add Citations and a Bibliography

  • Add Captions
  • Add Cross-References
  • Add Bookmarks
  • Add Hyperlinks
  • Insert Footnotes and Endnotes
  • Add Citations and a Bibliography

  • Suppress Information
  • Set Formatting and Editing Restrictions
  • Add a Digital Signature to a Document
  • Restrict Document Access

  • Create Forms
  • Manipulate Forms

  • Navigate the Outlook Interface
  • Perform Basic Email Functions
  • Use Outlook Help

  • Create an Email Message
  • Check Spelling and Grammar
  • Format Message Content
  • Attach Files and Items
  • Enhance an Email Message
  • Manage Automatic Message Content

  • Customize Reading Options
  • Work with Attachments
  • Manage Your Message Responses

  • Manage Messages Using Tags, Flags, and Commands
  • Organize Messages Using Folders

  • View the Calendar
  • Manage Appointments
  • Manage Meetings
  • Print Your Calendar

  • Create and Update Contacts
  • View and Organize Contacts

  • Manage Tasks
  • Manage Notes

  • Customize the Outlook Interface
  • Create and Manage Quick Steps

  • Insert Advanced Characters and Objects
  • Modify Message Settings, Properties, and Options
  • Use Automatic Replies

  • Sort Messages
  • Filter Messages
  • Organize Messages
  • Search Messages
  • Manage Junk Mail
  • Manage Your Mailbox

  • Manage Advanced Calendar Options
  • Create Calendar Groups
  • Manage Meeting Responses

  • Edit an Electronic Business Card
  • Manage Advanced Contacts Options
  • Forward Contacts
  • Export Contacts

  • Assign and Manage Tasks
  • Record and Modify Journal Entries

  • Delegate Access to Mail Folders
  • Share Your Calendar
  • Share Your Contacts

  • Back Up Outlook Items
  • Change Data File Settings

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

  • Modify Fonts
  • Add Borders and Colors to Worksheets
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

  • Preview and Print a Workbook
  • Define the Page Layout

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

  • Create Charts
  • Modify and Format Charts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers

  • Use 3-D References
  • Use Links and External References
  • Consolidate Data

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

  • Apply Data Validation
  • Work with Forms and Controls
  • Work with Macros

  • Use Lookup Functions
  • Combine Functions
  • Use Formulas and Functions to Apply Conditional Formatting

  • Trace Cells
  • Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Activate and Use the Solver Tool
  • Analyze Data with Analysis ToolPak Tools

  • Use Advanced Chart Features
  • Create Sparklines

  • Navigate the PowerPoint Environment
  • Create and Save a PowerPoint Presentation
  • Use Help

  • Select a Presentation Type
  • View and Navigate a Presentation
  • Edit Text
  • Build a Presentation

  • Format Characters
  • Format Paragraphs
  • ToFormat Text Boxes

  • Insert Clip Art and Images
  • Insert Shapes

  • Edit Objects
  • Format Objects
  • Group Objects
  • Arrange Objects
  • Animate Objects

  • Create a Table
  • Format a Table
  • Insert a Table from Other Microsoft Office Applications

  • Create a Chart
  • Format a Chart
  • Insert a Chart from Microsoft Excel

  • Review Your Presentation
  • Apply Transitions
  • Print Your Presentation
  • Deliver Your Presentation

  • Customize the User Interface
  • Set PowerPoint 2016 Options

  • Modify Slide Masters and Slide Layouts
  • Add Headers and Footers
  • Modify the Notes Master and the Handout Master

  • Create SmartArt
  • Modify SmartArt

  • Add Audio to a Presentation
  • Add Video to a Presentation
  • Customize Animations and Transitions

  • Review a Presentation
  • Store and Share Presentations on the Web

  • Annotate a Presentation
  • Set Up a Slide Show
  • Create a Custom Slide Show
  • Add Hyperlinks and Action Buttons
  • Record a Presentation

  • Secure a Presentation
  • Broadcast a Slide Show
  • Create a Video or a CD
Tags
Vendor: Logical Operations Technical Core Type: Core 5 Product Line: Microsoft Applications LoD Tier: Custom
FREE

Interested in course?

Buy Course

Course Type: Instructor Led