Font size:

Introducing Microsoft Office

  • Comparing differences between Office versions
  • Integrating Office with the cloud
  • Retrieving documents using SkyDrive

Developing documents in Microsoft Word

Preparing the document

  • Formatting legacy documents quickly
  • Maintaining consistency with Themes
  • Navigating and globally formatting text using Styles

Controlling the document setup

  • Managing documents with Sections
  • Creating custom Section headers and footers

Speeding up document creation

  • Applying reusable content with AutoText
  • Maintaining content with the Building Block Organizer

Finishing Documents with Microsoft Word

Managing graphics within a document

  • Inserting images using Guides
  • Manipulating images with graphic tools

Adding hyperlinks, references and tables of contents (TOC)

  • Creating hyperlinks to internal and external documents
  • Adding and modifying an automatic TOC
  • Navigating the document using the TOC and hyperlinks

Proofing and protecting the final document

  • Avoiding mistakes with AutoCorrect
  • Preparing the document for multiple devices
  • Managing document versions
  • Storing the document on SkyDrive

Configuring Microsoft Excel

Customizing the user interface

  • Navigating the worksheet with shortcut keys
  • Personalizing the Ribbon and Quick Access Toolbar

Patterning data with AutoFill and Flash Fill

  • Filling list-based information with AutoFill
  • Interpreting data with Flash Fill

Refining data with functions and formulas

  • Applying cell references and Named Ranges
  • Implementing conditional logic using the IF function

Presenting Data with Microsoft Excel

Filtering data with conditional formatting

  • Displaying data via text or cell formatting and Filter Search
  • Interpreting data using data bars, color scales and Icon sets

Graphing and charting data

  • Analyzing data rapidly with advanced charting tools
  • Changing chart displays via data selection

Collaborating with Mail Merge in Word

  • Preparing requirements for variable data documents
  • Creating a Mail Merge

Setting up a PowerPoint Presentation

Customizing the work area

  • Leveraging views to maximize PowerPoint effectiveness
  • Implementing good presentation design with Slide Master, Master Layouts and Notes Master

Developing a presentation

  • Managing large presentations with Sections
  • Reusing slides from external files
  • Editing content quickly using outlines from Word

Presenting multimedia options

  • Formatting default text boxes
  • Facilitating presentation creation with Alignment guides
  • Turning bulleted lists into graphics via SmartArt
  • Inserting video, audio and tables

Finishing a PowerPoint Presentation

Drawing attention to graphics

  • Intensifying a presentation with Transitions, Animations and Motion paths
  • Emphasizing graphics with dynamic custom Motion paths
  • Timing the Slide Show with transitions and animations

Packaging the presentation

  • Protecting the presentation
  • Sharing the presentation via SkyDrive

You Will Learn How To
  • Leverage the extensive features in Word, Excel and PowerPoint
  • Build professional documents in Word with enhanced functionality
  • Quickly present and summarize data with Excel using PivotTables and PivotCharts
  • Easily incorporate external data sources
  • Create visually dynamic and effective presentations in PowerPoint
  • Safeguard documents from viruses and unauthorized access with the Trust Center

Course 972 Content

Introducing Microsoft Office

Discovering the Fluent User Interface

  • Navigating the Ribbon and Dialog Launcher
  • Setting defaults with the Office button
  • Customizing the Quick Access Toolbar

Exploring file formats

  • Reviewing supported file extensions
  • Discovering the Compatibility Pack

Creating Professional Documents in Word

Establishing the document setup

  • Configuring the status bar
  • Working with sections
  • Handling multiple headers and footers

Formatting the document

  • Implementing styles
  • Condensing the document to an outline and viewing the document map
  • Discovering themes

Automating documents and text

  • Exploring templates
  • Inserting and modifying Quick Parts and Building Blocks

Referencing and Navigating Documents

Streamlining document tasks

  • Customizing document properties
  • Inserting cover pages
  • Creating the TOC
  • Adding watermarks

Implementing revision control

  • Creating comments
  • Managing multiple versions of a document
  • Reviewing and tracking changes

Producing Rapid Results with Excel

Leveraging Excel functionality

  • Taking advantage of the Function Wizard
  • Absolute versus relative addressing

Optimizing graphical objects

  • Graphing data with charts
  • Visually enhancing data with conditional formatting

Creating interactive PivotTables and PivotCharts

  • Generating, editing and formatting PivotTable fields
  • Filtering, sorting and pivoting charts and tables

Integrating Data Sources

Retrieving external data

  • Connecting to MS Access using MS Query
  • Extracting and correcting data types with formulas

Assembling mass mailings

  • Connecting to Excel data
  • Working with a template document
  • Producing the result documents: letters, envelopes and labels

Developing PowerPoint Presentations

Building a dynamic slide show

  • Best practices for creating presentations
  • Designing effective slides
  • Incorporating animation and sound
  • Exploring slide show options

Enhancing the slides

  • Applying themes
  • Setting up and refining master layouts

Enhancing documents with graphics

  • Leveraging SmartArt graphics
  • Employing text to create SmartArt graphics

Finalizing and adding special effects

  • Adding slide transitions
  • Customizing animation panes
  • Publishing the presentation

Document Security and Collaboration

Protecting documents

  • Setting
    Hands-On Training
    Exercises provide you with practical experience using Microsoft Office. Exercises include:
    • Customizing Microsoft Office
    • Designing documents with styles, themes and sections
    • Implementing the TOC, headers and footers in Word
    • Analyzing data with PivotTables and PivotCharts
    • Applying conditional formatting and SmartArt
    • Refining the data with formulas in Excel
    • Creating PowerPoint presentations with Master layouts and design masters
    • Securing documents using visible and invisible digital signatures and the Trust Center


Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live2/7/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days2650.001807597
VA ALEXANDRIA2/7/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>3 days2650.001804627
VA SAINT STEPHENS CHURCH2/7/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>3 days2650.001816761
Virtual Live2/28/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days2650.001807601
NY New York2/28/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>3 days2650.001804631
MD LAUREL2/28/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>3 days2650.001816742
Virtual Live6/27/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days2650.001807596
VA ALEXANDRIA6/27/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>3 days2650.001804628
VA WINCHESTER6/27/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>3 days2650.001816708
Virtual Live8/15/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days2650.001807600
NY New York8/15/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>3 days2650.001804632
VA SAINT STEPHENS CHURCH8/15/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>3 days2650.001816693
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 12 of 12 items