Power Hour

Private Session only. Customers can choose between a minimum of 4 to a maximum of 6 Power Hour Sessions per day. Up to 30 people may attend each session. SATV eligible. SATV redemption is at a rate of one voucher per session.





 Excel

Choose from the following Excel Power Hour Sessions


Automating an Excel Import with Macros

  • Master the Import Wizard
  • Work with Text Functions to Clean up Imported Data
  • Design a Macro to Automate the Import Process

Introduction to Building Pivot Table Reports

  • Master the Field List and Building the Report
  • Design a Look that Answers you Questions
  • Filter Data to Drill-down into the Data

Calculating and Analyzing Data with Excel IF Statements

  • Building and Troubleshooting the IF Function
  • Nesting AND & OR Functions
  • All the Other IF Functions
  • Avoiding Mistakes by Catching Errors

Create Dynamic PowerPoint Presentations with Excel Data

  • Preparing Spreadsheets for Presentation
  • Design Charts
  • Adding the Final Touches to the Excel File
  • Moving Excel Data to PowerPoint

Creating Interactive Reports with Excel Pivot Charts

  • Building the Excel Report
  • Creating a PivotChart
  • Making your Chart Look its Best
  • Working with Chart Items
  • Modifying Chart Types

Discovering and Presenting Trends in Excel Data with Charts

  • Working with Column Charts
  • Creating Pie Charts
  • Building Custom Charts with Excel
  • Sparklines

Search Excel Data More Efficiently with Lookup Functions

  • Make Functions and Formulas Easier to Read with Named Ranges
  • Use Data Validation to Create a Drop Down Menu
  • The Power of VLOOKUP and HLOOKUP
  • The Basics of MATCH
  • Nesting Calculations

Using Excel PivotTables to Present Interactive Data

  • Building the Report
  • Modifying the Report Layout
  • Formatting PivotTable Reports
  • Working with Slicers
 Office 365

Choose from the following Office 365 Power Hour Session


Demystifying Office 365

  • What is Office 365?
  • General Overview of New Features
  • Word
  • Excel
  • Outlook
  • PowerPoint

Getting the Most from Office 365

  • Understanding Office 365
  • The basics of Office 365
  • Office 365 integration with services
  • Utilizing Outlook
  • Utilizing Word
  • Utilizing Excel
  • Utilizing PowerPoint
 Office 2013

Choose from the following Office 2013 Power Hour Sessions


Working With Microsoft Office

  • Getting Started with Word 2013, Excel 2013
  • Creating New Documents and Worksheets
  • Copying and Pasting
  • Using the AutoSum Feature in Excel
  • Saving Your Documents and Worksheets

Getting the Most from Office 2013

  • Office 2013 Overview
  • Utilizing Outlook
  • Utilizing Word
  • Utilizing Excel
  • Utilizing PowerPoint
  • Office 2013 integration with services

Using Office Graphics to Enhance Documents

  • Using Graphics in Office 2013
  • The Office 2013 Pictures and Online Pictures Tools
  • Removing Background
  • Working with Shapes
  • SmartArt Graphics
  • Screenshot Tool

Become a Power User with the Office 2013 Ribbon

  • Master the Office 2013 Ribbon
  • Build a Custom Environment to Match my Needs
 Office Web Apps

Office Web Apps Power Hour Session


Getting the Most from Office Web Apps

  • What’s new in Office Web Apps?
  • What’s new in the Word Web App?
  • What’s new in the Excel Word App?
  • What’s new in the PowerPoint Web App?
  • What’s new in the Outlook Web App?
 OneNote

Choose from the following OneNote Power Hour Sessions


Organizing with Microsoft OneNote and Outlook

  • Creating and Managing Shared Notebooks
  • Developing OneNote Pages
  • Adding Other Content to a OneNote Page

Team Collaboration with Microsoft Lync and One Note

  • Using Lync Online
  • Communicating the Right Way
  • Collaborating in a Variety of Ways
  • Seeing Everyone’s Real-Time Presence
  • Enjoying more Beautiful Connections in HD video
  • Being Quicker with the Quick Lync Bar
  • Taking and Sharing Notes using OneNote
  • Keeping your Favorites Close

Team Collaboration with Microsoft One Note

  • Creating and Managing Shared Notebooks
  • Developing OneNote Pages
  • Adding Other Content to a OneNote Page

OneNote 2013 – 5 Ways to be More Productive

  • Create and Share Your Notebook
  • Capture Audio, Video, and Screenshots
  • Sending Data to Your Notebook
  • Customize the View
  • Syncing Notebooks

OneNote 2013 Basics

  • Create and Share Your Notebook
  • Sending Data to your Notebook
  • Capture Audio, Video, and Screenshots
  • Customize Views
  • Syncing Notebooks
 Outlook

Choose from the following Outlook Power Hour Sessions


Building Automatic and One Click Emails in Outlook

  • Configure Out of Office to Take Care of Things
  • Design Custom Quick Parts to Write for Me
  • Create Automated Emails with Quick Steps

Performing an E-mail Merge Using the Mail Merge Wizard

  • The Mail Merge Process
  • Source Data Options
  • Working with Field Options
  • Performing a Document Mail Merge
  • Performing a Label Mail Merge
  • Finishing the Merge

Working with Rules

  • Creating a Rule Using a Built-in Template
  • Creating a Rule to Auto-organize Emails from a Specific Person
  • Creating a Rule to Apply Color Categories
  • The Out of Office Assistant
  • Out of Office Rules

The Most Valuable Organizational Tools of Outlook

  • Creating Custom Inbox Folders to Store your Email
  • Applying Email Flags before you Forget
  • Using Color Categories to Quickly Search and See Messages
  • The New Conversation View
  • Modifying the Reading Pane Layout
  • Managing Junk Mail
  • The Super Cool People Pane

Organizing with Microsoft OneNote and Outlook

  • Getting Started with OneNote
  • Note Taking in OneNote
  • The Power of Search
  • Integrating OneNote with Outlook

Outlook Power Views

  • Outlook Today
  • Conversation View
  • People Pane
  • Email Dashboard
  • Calendar Dashboard
  • Personal Contact Activities View
  • Email Category Group
  • Task Category Group
  • Calendar Overlay
  • Creating your own Custom Power View

Quick and Easy Ways to Find Messages in Outlook

  • Using the Basic Search
  • Creating Virtual Folders with Search Folders
  • Sorting, Filtering, and Grouping Information
  • The Other Search Tools

The Secrets to Sending Interesting Email with Outlook

  • Sending a Basic Email
  • Making the Message More Interesting and Readable
  • Sending Attachments
  • Applying Importance and Sensitivity
  • Requesting Receipts for your Records
  • The Other Email Options
  • Using Voting Buttons

The Time Management Tools of Outlook

  • Working with the Outlook Calendar
  • Creating a Manageable To-do List
  • The Time Management Dashboard
 PowerPoint

Choose from the following PowerPoint Power Hour Sessions


Create Dynamic PowerPoint Presentations with Excel Data

  • Preparing Spreadsheets for Presentation
  • Design Charts
  • Adding the Final Touches to the Excel File
  • Moving Excel Data to PowerPoint

Design Engaging PowerPoint Presentations with Animations

  • Adding Animation to Slide Bullets
  • Customizing Slide Animation with Effect Options
  • Animating Slide Graphics
  • Working with Transitions

Design Memorable PowerPoint Presentations with Media and Graphics

  • The New Picture and Clip Art Features
  • Building Diagrams with SmartArt
  • Adding Sound
  • Inserting and Customizing Video with the New Office Video Editing Tools

Developing a Custom PowerPoint Template

  • The Secrets to Master View
  • Creating Custom Slide Layouts
  • Using the Built-in Slide Designs
  • Building Custom Themes and Templates
 SharePoint 2013

SharePoint 2013 Power Hour Session


An Introduction to SharePoint 2013

  • Accessing your SharePoint Site
  • Navigating your SharePoint Site
  • Components of SharePoint
  • Performing a Search
  • Uploading Documents and Pictures to a SharePoint Library
  • Opening, Editing, and Saving a SharePoint file

Getting the Most from SharePoint 2013

  • What is SharePoint?
  • SharePoint 2013: The basics
  • Authoring and Organizing
  • Collaboration and Sharing
  • Integration with Office and Business Intelligence
 Skype for Business / Lync

Skype for Business/Lync Power Hour Session


Skype for Business – Team Collaboration with OneNote

  • Using Skype for Business
  • Communicating the Right Way
  • Collaborating in a Variety of Ways
  • Seeing Everyone’s Real-Time Presence
  • Enjoying HD Video
  • The Quick Skype Bar
  • Taking and Sharing Notes
  • Keeping Your Favorites Close

Skype for Business – Scheduling Meetings

  • Start a Conference Call
  • Start a Group IM
  • Share Your Screen
  • Share PowerPoint Slides
  • Send a File
 Word

Choose from the following Word Power Hour Sessions


Automate Document Creation with Quick Parts

  • Become Aware of all the Possible Quick Parts
  • Quickly Insert the Pre-built Content
  • Design Custom Quick Parts

Create Interesting and Organized Documents with Word Tables

  • Build Word Tables
  • Manipulate Table Layouts
  • Designing the Look and Feel
  • Reusing Tables

Managing Long Documents with Word

  • Creating and Managing a Table of Contents
  • Using Footnotes and Endnotes for that Extra Info
  • Managing the Graphics with Captions
  • Building an Index for Document Navigation
  • Working with Document Headers and Footers
  • Add a Finishing Touch with Cover Pages
  • Navigating Long Documents

Team Collaboration with Microsoft Word

  • Proofing a Document
  • Working with Word Comments
  • Keeping Track of Changes in a Document
  • Comparing Document Versions

Designing Word Style Guides for Fast and Consistent Formatting

  • Working with Quick Styles
  • Applying a Style Set
  • Features that Sync with Styles

Automatic Mail Merge

  • Starting the Mail Merge
  • Selecting a Data Source
  • Inserting the Greeting Line Field
  • Inserting Custom Fields
  • Previewing Messages
 Yammer

Yammer Power Hour Sessions


Getting Started with Yammer

  • Where Does Yammer Fit In?
  • How to Get Started
  • Getting to Your Yammer Site
  • Searching Yammer
  • Joining Yammer Groups
  • Yammer Posting
  • Setting Up Your User Profile

Yammer for Power Users

  • Developing a Yammer Culture
  • Creating and Managing Group Members and Posts
  • Starting a Dialogue with Polls, Files, and Notes
  • Yammer and SharePoint Integration
  • Yammer Deployment Basics

Request Information