RSFH Outlines
All courses are hands-on and live with an instructor. The course content outlines are shown below. To view the training schedule and how to register, click here.
Length: Full day
Course Content
Lesson 1: Creating a Basic Document
Topic 1A: Explore the User Interface
Topic 1B: Open and View a Document
Topic 1C: Customize the Word Environment
Topic 1D: Obtain Help
Topic 1E: Enter Text
Topic 1F: Save a Document
Topic 1G: Preview and Print a Document
Lesson 2: Editing a Document
Topic 2A: Navigate and Select Text in a Document
Topic 2B: Insert, Delete, or Rearrange Text
Topic 2C: Undo Changes
Topic 2D: Search and Replace Text
Lesson 3: Formatting Text
Topic 3A: Change Font Appearance
Topic 3B: Highlight Text
Lesson 4: Formatting Paragraphs
Topic 4A: Set Tabs to Align Text
Topic 4B: Control Paragraph Layout
Topic 4C: Add Borders and Shading
Topic 4D: Apply Styles
Topic 4E: Create Lists
Topic 4F: Manage Formatting
Lesson 5: Adding Tables
Topic 5A: Create a Table
Topic 5B: Modify the Table Structure
Topic 5C: Format a Table
Topic 5D: Convert Text to a Table or Tables to Text
Lesson 6: Inserting Graphic Objects
Topic 6A: Add Visual Effects Using Symbols &Special Characters
Topic 6B: Insert Illustrations
Lesson 7: Controlling Page Appearance
Topic 7A: Control Page Layout
Topic 7B: Apply a Page Border and Color
Topic 7C: Add Watermarks
Topic 7D: Add Headers and Footers
Lesson 8: Proofing a Document
Topic 8A: Check Spelling, Grammar, and Word Count
Topic 8B: Enhance Textual Meaning
Topic 8C: Customize AutoCorrect Options
Length: Full day
Course Content
Lesson 1: Managing Lists
Topic 1A: Sort a List
Topic 1B: Renumber a List
Topic 1C: Customize Lists
Lesson 2: Customizing Tables and Charts
Topic 2A: Sort Table Data
Topic 2B: Control Cell Layout
Topic 2C: Perform Calculations in a Table
Topic 2D: Create Charts
Lesson 3: Customizing Formatting with Styles and Themes
Topic 3A: Create or Modify a Text Style
Topic 3B: Create a Custom List or Table Style
Topic 3C: Apply Default and Customized Document Themes
Lesson 4: Modifying Pictures
Topic 4A: Resize a Picture
Topic 4B: Adjust Picture Appearance Settings
Topic 4C: Wrap Text Around a Picture
Lesson 5: Creating Customized Graphic Elements
Topic 5A: Create Text Boxes and Pull Quotes
Topic 5B: Draw Shapes
Topic 5C: Add WordArt and Other Special Effects to Text
Topic 5D: Create Complex Illustrations with SmartArt
Lesson 6: Inserting Content Using Quick Parts
Topic 6A: Insert Building Blocks
Topic 6B: Create Building Blocks
Topic 6C: Modify Building Blocks
Topic 6D: Insert Fields Using Quick Parts
Lesson 7: Controlling Text Flow
Topic 7A: Control Paragraph Flow
Topic 7B: Insert Section Breaks
Topic 7C: Insert Columns
Topic 7D: Link Text Boxes to Control Text Flow
Lesson 8: Using Templates to Automate Document Creation
Topic 8A: Create a Document Based on a Template
Topic 8B: Create a Template
Lesson 9: Automating Mail Merges
Topic 9A: Perform a Mail Merge
Topic 9B: Mail Merge Envelopes and Labels
Topic 9C: Use Word to Create a Data Source
Lesson 10: Using Macros to Automate Tasks
Topic 10A: Perform a Task Automatically Using a Macro
Topic 10B: Create a Macro
Length: Full day
Course Content
Lesson 1: Using Microsoft® Office Word with Other Programs
Topic 1A: Link to a Microsoft® Office Excel® Worksheet
Topic 1B: Link a Chart to Excel Data
Topic 1C: Send a Document Outline to Microsoft® Office PowerPoint®
Topic 1D: Extract Text from a Fax
Topic 1E: Send a Document as an Email Message
Lesson 2: Collaborating on Documents
Topic 2A: Modify User Information
Topic 2B: Send a Document for Review
Topic 2C: Review a Document
Topic 2D: Compare Document Changes
Topic 2E: Merge Document Changes
Topic 2F: Review Track Changes and Comments
Lesson 3: Managing Document Versions
Topic 3A: Create a New Version of a Document
Topic 3B: Compare Document Versions
Topic 3C: Merge Document Versions
Lesson 4: Adding Reference Marks and Notes
Topic 4A: Insert Bookmarks
Topic 4B: Insert Footnotes and Endnotes
Topic 4C: Add Captions
Topic 4D: Add Hyperlinks
Topic 4E: Add Cross-References
Topic 4F: Add Citations and a Bibliography
Lesson 5: Making Long Documents Easier to Use
Topic 5A: Insert Blank and Cover Pages
Topic 5B: Insert an Index
Topic 5C: Insert Table of Figures
Topic 5D: Insert Table of Authorities
Topic 5E: Insert Course Content
Topic 5F: Create a Master Document
Topic 5G: Automatically Summarize a Document
Lesson 6: Securing a Document
Topic 6A: Update a Document's Properties
Topic 6B: Hide Text
Topic 6C: Remove Personal Information from a Document
Topic 6D: Set Formatting and Editing Restrictions
Topic 6E: Add a Digital Signature to a Document
Topic 6F: Set a Password for a Document
Topic 6G: Restrict Document Access
Appendix A: Creating Forms
Supplemental Lesson Creating Forms
Topic 1A: Add Form Fields to a Document
Topic 1B: Protect a Form
Topic 1C: Save Form Data as Plain Text
Topic 1D: Automate a Form
Appendix B: Using XML in Word
Supplemental Lesson Using XML in Word
Topic 1A: Tag an Existing Doc
Topic 1B: Transform an XML Document
Length: Full day
Course Content
Lesson 1: Getting Started with PowerPoint
Topic 1A: Explore the User Interface
Topic 1B: Navigate and View a Presentation
Topic 1C: Use Microsoft PowerPoint Help
Topic 1D: Enter Text
Topic 1E: Save a Presentation
Lesson 2: Creating a Presentation
Topic 2A: Create a Presentation
Topic 2B: Edit Text
Topic 2C: Add Slides to a Presentation
Topic 2D: Arrange Slides
Topic 2E: Work with Themes
Lesson 3: Formatting Text on Slides
Topic 3A: Apply Character Formats
Topic 3B: Apply Paragraph Formats
Topic 3C: Format Text Placeholders
Lesson 4: Adding Graphical Objects to a Presentation
Topic 4A: Insert Clip Art and Pictures
Topic 4B: Draw Shapes
Topic 4C: Insert WordArt
Lesson 5: Modifying Objects
Topic 5A: Work with Objects
Topic 5B: Change Object Orientation
Topic 5C: Format Objects
Topic 5D: Group and Ungroup Objects
Topic 5E: Arrange Objects
Lesson 6: Adding Tables to a Presentation
Topic 6A: Create a Table
Topic 6B: Format Tables
Topic 6C: Insert a Table from Microsoft Word
Lesson 7: Inserting Charts in a Presentation
Topic 7A: Create a Chart
Topic 7B: Edit Chart Data
Topic 7C: Modify a Chart
Topic 7D: Paste a Chart from Microsoft Excel
Lesson 8: Preparing to Deliver a Presentation
Topic 8A: Review Content
Topic 8B: Add Transitions
Topic 8C: Apply an Animation Effect
Topic 8D: Create Speaker Notes
Topic 8E: Print a Presentation
Length: Full day
Course Content
Lesson 1: Customizing the PowerPoint Environment
Topic 1A: Customize the Quick Access Toolbar
Topic 1B: Personalize the PowerPoint Interface
Topic 1C: Customize Save Options
Topic 1D: Apply Advanced Customization Options
Lesson 2: Customizing a Design Template
Topic 2A: Set Up a Slide Master
Topic 2B: Customize Slide Layouts
Topic 2C: Create Custom Themes
Topic 2D: Add Headers and Footers
Topic 2E: Modify the Notes Master
Topic 2F: Modify the Handout Master
Lesson 3: Adding Diagrams to a Presentation
Topic 3A: Create Diagrams
Topic 3B: Modify Diagrams
Lesson 4: Adding Special Effects to Presentations
Topic 4A: Add Multimedia Elements
Topic 4B: Customize Slide Component Animations
Lesson 5: Customizing a Slide Show Presentation
Topic 5A: Set Up a Custom Show
Topic 5B: Annotate a Presentation
Topic 5C: Create a Presenter-Independent Slide Show
Topic 5D: Set Up a Slide Show to Repeat Automatically
Lesson 6: Collaborating on a Presentation
Topic 6A: Review a Presentation
Topic 6B: Publish Slides to a Slide Library
Topic 6C: Share a Presentation
Lesson 7: Securing and Distributing a Presentation
Topic 7A: Secure Presentations
Topic 7B: Package a Presentation
Topic 7C: Publish a Presentation as a Web Page
Length: Full day
Course Content
Lesson 1: Getting Started with Microsoft Office Excel 2016
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help
Lesson 2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions
Lesson 3: Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates
Lesson 5: Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers
Lesson 6: Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties
Length: Full day
Course Content
Lesson 1: Calculating Data with Advanced Formulas
Topic 1A: Manage Cell and Range Names
Topic 1B: Calculate Data Across Worksheets
Topic 1C: Use Specialized Functions
Topic 1D: Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort or Filter Worksheet or Table Data
Topic 2D: Calculate Data in a Table or Worksheet
Lesson 3: Presenting Data Using Charts
Topic 3A: Create a Chart
Topic 3B: Modify Charts
Topic 3C: Format Charts
Lesson 4: Analyzing Data Using PivotTables and PivotCharts
Topic 4A: Create a PivotTable Report
Topic 4B: Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
Topic 5A: Insert and Modify Pictures and ClipArt
Topic 5B: Draw and Modify Shapes
Topic 5C: Illustrate Workflow Using SmartArt Graphics
Topic 5D: Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing Workbooks & the Excel Environment
Topic 6A: Customize the Excel Environment
Topic 6B: Customize Workbooks
Topic 6C: Manage Themes
Topic 6D: Create and Use Templates
Length: Full day
Course Content
Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Apply Conditional Formatting
Topic 1D: Add Data Validation Criteria
Topic 1E: Update a Workbook's Properties
Topic 1F: Modify Excel's Default Settings
Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Administer Digital Signatures
Topic 2G: Restrict Document Access
Lesson 3: Auditing Worksheets
Topic 3A: Trace Cells
Topic 3B: Troubleshoot Errors in Formulas
Topic 3C: Troubleshoot Invalid Data and Formulas
Topic 3D: Watch and Evaluate Formulas
Topic 3E: Create a Data List Outline
Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
Topic 6A: Export Excel Data
Topic 6B: Import a Delimited Text File
Lesson 7: Using Excel with the Web
Topic 7A: Publish a Worksheet to the Web
Topic 7B: Import Data from the Web
Topic 7C: Create a Web Query
Lesson 8: Structuring Workbooks with XML
Topic 8A: Develop XML Maps
Topic 8B: Import and Export XML Data
Length: Half day
Course Content
Lab 1: Make it easy to read
Activity 1A: Begin with your raw data
Activity 1B: Create a PivotTable
Activity 1C: Group some data
Activity 1D: Apply some formatting
Lab 2: See sales trends
Activity 2A: What were sales by category by month?
Activity 2B: What were the trends?
Activity 2C: What products are doing well?
Activity 2D: How did each sales rep do?
Lab 3: Spot market patterns
Activity 3A: What did customers buy?
Activity 3B: Who were our biggest customers?
Activity 3C: What products do best in each region?
Lab 4: Analyze product surveys
Activity 4A: Are customers satisfied?
Activity 4B: What's the most important feature?
Length: Half day
Course Content
Lesson 1: Getting Started with Power Pivot
Topic A: Enable and Navigate Power Pivot
Topic B: Manage Data Relationships
Lesson 2: Visualizing Power Pivot Data
Topic A: Create a Power Pivot Report
Topic B: Create Calculations in Power Pivot
Lesson 3: Working with Advanced Functionality in Power Pivot
Topic A: Create a Key Performance Indicator
Topic B: Work with Dates and Time in Power Pivot
Appendix A: Commonly Used DAX Functions
Appendix A: Commonly Used DAX Functions