Learning Methods > Power Hour

Power Hour Training from New Horizons Cedar Rapids

Power Hour is 60 minutes of instructional adrenaline that will teach you precisely what you need to know in exactly the amount of time you can spare. Individual, task-focused sessions will transform your workforce into a super-powered productivity machine.

Task Focused Training

Power Hour is laser focused on improving the specific tasks that you perform every day. In 60 short minutes, a Power Hour session can turn a weakness into a strength to make you more productive than ever before.

Schedule multiple sessions per day to ensure that each team member is getting the custom training they need to crush the competition.

Each Power Hour session includes a Power Hour Student Card. These cards utilize a fresh mix of visuals and text to bring tools and tips to life. They serve as both the perfect companion during your 60 minute session and a great reference after your session is over.

Private Session only. Customers can choose up to a maximum of 4 Power Hour Sessions per day. Up to 30 people may attend each session.

Choose from the Following Sessions

Getting Started with Acrobat

  • Introducing Acrobat & PDFs
  • Accessing PDFs
  • Creating PDFs
  • Searching PDFs
  • Creating Bookmarks
  • Creating Links

Beyond the Basics

  • Advanced Document Tools
  • Creating Links
  • Enhancing Scans
  • Adding Rich Media
  • Automating with Action Words
  • Exporting PDFs
  • Redacting PDF Content
  • Creating Signatures and Certificates

Polishing and Perfecting PDFs

  • Creating Links
  • Working with Text and Images
  • Working with Headers and Footers
  • Using Watermarks
  • Working with Organize Pages
  • Optimizing PDFs
  • Restricting Editing of PDFs

Reviewing and Collaborating in Acrobat

  • Comparing Documents
  • Reviewing PDFs
  • Working with the Comment Tools Pane
  • Sending a PDF for Review
  • Adding Stamps
  • Protecting PDFs

Creating Interactive Forms

  • Creating Forms
  • Working with the Form Field
  • Adding Form Fields
  • Finalizing the Form

Choose from the Following Sessions

Email Etiquette

  • Overview of Email Etiquette
  • Setting Up a Message
  • Writing Style
  • Formatting and Proofing
  • Replying to Emails

Choose from the Following Versions: 2010, 2013, 2016

Analyzing Excel Data with Lookup Functions

  • Make Functions and Formulas Easier to Read with Named Ranges
  • The Power of VLOOKUP
  • The Power of HLOOKUP
  • Using INDEX and MATCH

Automating with Macros

  • Creating a Macro
  • Recording a Macro to Automate Formatting
  • Running a Macro
  • Exploring the VBA Environment

Building a Spreadsheet

  • Getting Started with Excel
  • Navigating and Selecting in an Excel Workbook
  • Entering Data in a Worksheet
  • Working with Basic Excel Functions
  • Understanding Cell and Range References

Calculating and Analyzing Data with Excel IF Statements

  • Summarize Data with SUMIF, AVERAGEIF, and COUNTIF
  • Analyzing with Logical Functions
  • Using Nested IF Functions
  • Handling Errors with the IFERROR Function

Check It & Protect It: Auditing & Protecting Workbooks

  • Auditing Workbooks
  • Applying Data Validation
  • Password Protecting a Workbook
  • Protecting Cells, Worksheets, and Workbooks

Creating Easy to Read Spreadsheets

  • Adjusting Worksheet Layout and Data
  • Modifying Text
  • Aligning Cell Contents
  • Formatting Numbers
  • Working with Borders and Fills
  • Format Quickly with Styles
  • Applying Themes
  • Automatically Format with Conditional Formatting
  • Create and Use Templates

Creating Interactive Reports with Pivot Charts

  • Analyzing with PivotCharts
  • Formatting a Chart
  • Modifying a PivotChart Design
  • Formatting PivotChart Elements
  • Filtering with Slicers and Timeline Slicers

Discovering and Presenting Trends Data with Charts

  • Types of Charts
  • Creating Charts and Graphs
  • Modifying and Formatting Charts
  • Advanced Charting Features
  • Displaying Trends with Sparklines

Ensuring Data Integrity

  • Converting Text to Columns
  • Locating Duplicates
  • Sharing Workbooks
  • Tracking Changes in a Workbook
  • Importing and Exporting Data

Managing and Delivering Workbooks

  • Use Find, Replace, and Go To
  • Proofing a Workbook
  • Previewing a Workbook
  • Preparing a Workbook for Printing
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

New Features of Excel 2016

  • New in Excel 2016
  • Using Flash Fill
  • New Chart Types
  • Using the Quick Analysis Tools
  • Working with Recommended PivotTables

PivotTables: Beyond the Basics

  • Adding Calculated Fields and Calculated Items
  • Applying Conditional Formatting to a PivotTable
  • Creating Filter Pages
  • Working with PowerPivot

Using Automated Analysis Tools

  • Determining Potential Outcomes Using Data Tables
  • Determining Potential Outcomes Using Scenarios
  • Using Goal Seek
  • Working with Solver
  • Analyzing Data with Analysis ToolPak

Using Excel PivotTables to Present Interactive Data

  • Analyzing with PivotTables
  • Using the PivotTable Fields Pane
  • Working with the PivotTable Tools Analyze Tab
  • Formatting the PivotTable
  • Filtering with Slicers and Timeline Slicers
  • Creating a PivotChart from a PivotTable

Working Together: Connecting Worksheets & Workbooks

  • The AutoFill Feature
  • Using Quick Analysis Tools
  • Switching Between Relative, Absolute, and Mixed References
  • Linking Worksheets and Workbooks
  • Working with Range Names

Choose from the Following Sessions

Getting Started with Office 2016

  • The Office 2016 Environment
  • Collaborating in Office 2016
  • New in Word 2016
  • New in Excel 2016
  • New in PowerPoint 2016
  • New in Outlook 2016

Excel 2016 New Features

  • New in Excel 2016
  • Using Flash Fill
  • New Chart Types
  • Using the Quick Analysis Tools
  • Working with Recommended PivotTables

Outlook 2016 New Features

  • New in Outlook 2016
  • Understanding the People View
  • Understanding the People Card
  • New in Outlook Mail

PowerPoint 2016 New Features

  • New Features Across Office Applications
  • New in PowerPoint 2016
  • Collaborating in Office 2016

Word 2016 New Features

  • New in Word 2016
  • New Features Across Office Applications
  • Word 2016 Enhancements
  • Collaborating in Office 2016

Choose from the Following Sessions

Getting Started with Office 365

  • What is Office 365?
  • Navigating in Office 365
  • Using Outlook in Office 365
  • Working with Word, Excel, and PowerPoint
  • Working with Comments
  • Printing and Sharing Documents in Office Online
  • Using Co-Authoring for Collaboration

Getting Started with Delve

  • Overview of Delve
  • Using Boards
  • Searching in Delve
  • Working with the Me or People View
  • Sharing Documents

Getting Started with Office 365 Video

  • Overview of Office 365 Video
  • Playing a Video
  • Working with Channels
  • Uploading a Video
  • Sharing Videos
  • Administrative Permissions

Getting Started with OneDrive

  • Overview of OneDrive
  • Opening and Saving Files in OneDrive
  • Creating and Rearranging Folders
  • Collaborating in OneDrive
  • Working with Files
  • Syncing Files

Getting Started with OneNote Online

  • OneNote for Business Overview
  • Creating a New Notebook
  • Adding Sections and Pages to a Notebook
  • Adding and Formatting Content
  • Working with OneNote
  • Printing and Sharing a Notebook

Getting Started with Outlook Online

  • Working with Mail
  • Folders and Views
  • Managing Outlook Mail
  • Working with the Calendar
  • Working with People
  • Working with Tasks

Getting Started with Planner

  • Working with Plans
  • Using Boards and Buckets
  • Working with Tasks
  • Working with Team Members
  • Using Notifications
  • Using the Charts View
  • Using the Notebook

Getting Started with SharePoint Sites

  • Sites Overview
  • Creating and Sharing a Site
  • Adding Content to a Site
  • Creating a Library
  • Inserting a Web Part
  • Working with Files
  • Creating a List
  • Document Collaboration
  • Using the Newsfeed
  • Setting an Alert

Getting Started with Skype for Business

  • Skype for Business Overview
  • Working with a User’s Presence Status
  • Working with Contacts
  • Sending an Instant Message (IM)
  • Using Desktop Sharing
  • Working with Skype Meetings
  • Sharing Files
  • Additional Skype Features

Getting Started with Sway

  • Overview of Sway
  • Creating a New Sway Presentation
  • Adding Content
  • Changing the Look of a Presentation
  • Sharing a Presentation
  • Co-Authoring in Sway

Getting Started with Teams

  • Overview of Teams
  • Working with Conversations
  • Overview of Channels
  • Working with Files
  • Integration with SharePoint
  • Working with Meetings
  • Adding a Tab
  • Adding a Connector

Getting Started with Yammer

  • Overview of Yammer
  • Editing a User Profile
  • Working with Groups
  • Working with Conversations
  • Working with Messages
  • Searching in Yammer

Skype for Business Collaborating with Meetings

  • The Basics of Using Skype for Business
  • Working with a User’s Presence Status
  • Working with Contacts
  • Collaborating with Skype Meetings
  • Sharing Content
  • Using OneNote to Collaborate

Skype for Business Team Collaboration with OneNote

  • The Basics Using Skype for Business
  • Working with a User’s Presence Status
  • Working with Contacts
  • Collaborating with Skype Meetings
  • Sharing Content
  • Using OneNote to Collaborate

Choose from the Following Versions: 2010, 2013, 2016

Become a Power User with the Office Ribbon

  • Understanding the Office Ribbon
  • Working with Ribbon Tabs
  • Working with Groups
  • Customizing the Quick Access Toolbar
  • Tailoring Backstage Options

Getting Started with Office 2016

  • The Office 2016 Environment
  • Collaborating in Office 2016
  • New in Word 2016
  • New in Excel 2016
  • New in PowerPoint 2016
  • New in Outlook 2016

Choose from the Following Versions: 2010, 2013, 2016

Be More Productive with OneNote

  • Building and Organizing Notebooks
  • Customizing the View
  • Working with Images, Audio and Video
  • Working with Data and Files
  • Syncing and Sharing Notebooks

Getting Started with OneNote

  • Understanding the Basics
  • Adding Content
  • Formatting a Notebook
  • Working with Tags
  • Working with Embedded Content

Organizing Meetings and Notes with OneNote and Outlook

  • Setting Up a Notebook
  • Sharing and Sending OneNote Content
  • Working with Tasks
  • Managing Outlook Meetings with OneNote

Team Collaboration

  • Creating and Managing a Shared Notebook
  • Syncing a Notebook
  • Developing OneNote Pages
  • Adding Additional Content Types
  • Inserting an Excel File

Choose from the Following Versions: 2010, 2013, 2016

Automating E-mail Merges Using Microsoft Word

  • Using Mail Merge to Send E-mails
  • Formatting E-mail Messages in Word
  • Start an E-mail Merge from Microsoft Word
  • Using Mail Merge to Create Labels

Automating Outlook—Let Outlook Work for You

  • Working with Email Templates
  • Replying with Features
  • Resending or Recalling a Message
  • Working with Signatures
  • Automating Outlook with Quick Steps
  • Utilizing Quick Parts
  • Creating and Managing Rules and Alerts
  • Using Conditional Formatting
  • Advanced Searching

Creating Attention Getting Emails

  • Using Tables, SmartArt, and AutoText
  • Working with Hyperlinks and Symbols
  • Inserting Pictures and Shapes
  • Using Stationery
  • Assigning Importance or Sensitivity Options
  • Using and Tracking Voting

Customizing the Outlook Experience

  • Modifying Preview Settings
  • Modifying Message Settings, Properties, and Options
  • Using and Tracking Voting
  • Modifying Contact Options
  • Modifying Calendar Options

Getting Started with Outlook

  • Understanding Outlook Components
  • Performing Basic Outlook Functions
  • Exploring the Mail Interface
  • Organizing and Formatting Emails
  • Exploring the New Message Tabs
  • Forwarding and Replying to Emails
  • Attaching and Inserting Files and Items
  • Checking Spelling and Grammar

Keeping in Touch - Managing People and Contacts

  • Contact Views
  • Searching for Contacts
  • Working with Contacts and Contact Groups
  • Creating a Contact
  • Creating Contact Groups
  • Working with Business Cards

Keeping Your Mailbox Clean

  • Cleaning up the Mailbox
  • Backing Up Data
  • Importing and Exporting Contacts
  • Working with Junk Mail

Manage Your Outlook Mailbox Like a Pro

  • Reading Options
  • Working with Attachments
  • Working with Color Categories and Flags
  • Sorting and Filtering Emails
  • Searching and Finding Emails
  • Organizing Emails with Folders
  • Printing Emails and Attachments
  • Deleting Emails

New Features in Outlook 2016

  • New in Outlook 2016
  • Understanding the People View
  • Understanding the People Card
  • New in Outlook Mail

Organizing Meetings and Notes with OneNote and Outlook

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

Quick and Easy Ways to Find Messages in Outlook

  • Working with Color Categories and Flags
  • Using Conditional Formatting
  • Sorting and Filtering Emails
  • Advanced Searching
  • Organizing Emails with Folders
  • Organizing Messages with Rules
  • Creating Advanced Rules

Using the Calendar and Time Management Tools

  • Exploring the Calendar Views
  • Creating an Appointment
  • Creating Meetings
  • Managing Meetings
  • Working with the Calendar
  • Printing the Calendar
  • Working with Tasks
  • Assigning Tasks
  • Working with Notes

Choose from the Following Versions: 2010, 2013, 2016

Building Your First Presentation

  • Understanding the User Interface
  • Elements of a Slide Layout
  • Working with PowerPoint Presentations
  • Creating Slides
  • Working with Slide Elements
  • Organizing Content with Slide Layouts
  • Working with Slides in Other Views

Collaboration in PowerPoint

  • Working with Existing Slides and Text
  • Using Excel Data in PowerPoint
  • Reviewing Presentations Using Comments
  • Compare and Merge Presentations

Creating Dynamic Presentations Using Excel Data

  • Preparing a Spreadsheet for Presentation
  • Creating a Chart in Excel
  • Modifying the Document Theme
  • Inserting the Chart into PowerPoint

Creating Organized and Dynamic Presentations

  • Adding Navigation with Hyperlinks
  • Adding Interactivity with Action Buttons
  • Creating Custom Slides Shows
  • Organizing Slides with Sections

Designing Engaging PowerPoint Presentations with Animations

  • Animating Objects and Text
  • Modifying Animation Effects
  • Applying Advanced Animation Effects
  • Using Slide Transitions
  • Modifying Transitions

Designing Memorable PowerPoint Presentations Using Media & Graphics

  • Adding Interest with Images
  • Working with Shapes
  • Enhancing with Smart Art
  • Working with Media

Enhancing Slides with Charts and Tables

  • Creating and Formatting Tables
  • Modifying Tables
  • Creating Charts

Essentials of Formatting Presentations

  • Character Formatting
  • Paragraph Formatting
  • Bullets and Numbering

Fundamentals of Delivering a Presentation

  • Proofing a Presentation
  • Customizing Print Options
  • Delivering a Presentation
  • Presenter View

New Features in PowerPoint 2016

  • New Features Across Office Applications
  • New in PowerPoint 2016
  • Collaborating in Office 2016

Present Like a Pro: Using Advanced SlideShow Features

  • Adding Annotations to Slides
  • Working with Hidden Slides
  • Recording Slide Timings
  • Recording with Voice Narration and Slide Timings
  • Configuring Advanced Presentation Formats
  • Presenting Online
  • Packaging a Presentation and Saving to a Folders

Using Slide Masters Effectively and Building Custom Templates

  • Working with PowerPoint Masters
  • Customizing Layout Masters
  • Working with Custom Themes and Templates
  • Working with Notes and Handout Masters

Choose from the Following Versions: 2013, 2016

An Introduction to SharePoint

  • 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

Creating Document Libraries for Site Owners/Power Users

  • Creating SharePoint Libraries
  • Customizing Name and Navigation Options
  • Configuring Version and Check Out Options
  • Working with Advanced Settings
  • Creating Alerts

Getting the Most from SharePoint

  • What is SharePoint?
  • Authoring and Organizing
  • Collaboration and Sharing
  • Integration with Office and Business Intelligence

Working with Libraries for the Site User

  • Working with the User Interface Tools
  • Organizing Files in a Document Library
  • Working in Different Views
  • Setting Alerts
  • Using Check Out and Check In
  • Understanding Versions

Working with Lists for the Site User

  • Types of SharePoint Lists
  • Working with the User Interface Tools
  • Using a SharePoint Calendar
  • Utilizing a SharePoint Task List
  • Exploring Additional List Options

Choose from the Following Sessions

Collaborating with Meetings

  • Scheduling Skype Meetings
  • Taking Part in a Meeting
  • Sharing Content
  • Working with Interactive Features

Getting Started with Skype for Business

  • Skype for Business Overview
  • Working with a User’s Presence Status
  • Working with Contacts
  • Sending an Instant Message (IM)
  • Using Desktop Sharing
  • Working with Skype Meetings
  • Sharing Files
  • Additional Skype Features

Team Collaboration with Skype for Business and OneNote

  • The Basics of Using Skype for Business
  • Working with a User’s Presence Status
  • Working with Contacts
  • Collaborating with Skype Meetings
  • Sharing Content
  • Using OneNote to Collaborate

Choose from the Following Sessions

Conquer the Windows 10 Apps

  • Cortana
  • Maps
  • Photos
  • Mail
  • People
  • Calendar
  • Weather

Customize Windows 10

  • Adjusting Account Settings
  • Personalizing Windows 10
  • Changing the Display Options
  • Modifying Additional Settings
  • Managing Devices

Go to the Edge - Learn to Use Microsoft's New Browser

  • Browsing the Web
  • Utilizing Favorites
  • Understanding the Reading List and Reading View
  • Using Web Notes
  • Downloading and Viewing Files
  • Clearing the Browsing History

Installing, Updating and Troubleshooting Windows 10

  • Working with Applications
  • Configuring Windows 10
  • Backing Up Windows 10
  • Troubleshooting Windows 10

Manage Your Files Like a Boss

  • Understanding Drive and Folder Structure
  • Managing Files
  • Customizing the File Explorer
  • Working with Libraries
  • Using OneDrive
  • Sharing and Syncing Files

Master the Essentials

  • Getting Started with Windows 10
  • Exploring the Desktop
  • Introducing the Action Center, Settings, and Control Panel
  • Interacting with Windows, Menus, and Ribbons
  • Using Tablet Mode
  • Using Applications
  • Customizing the Start Menu and Taskbar

Choose from the Following Versions: 2010, 2013, 2016

Advanced Document Layout

  • Controlling Layout with Page and Section Breaks
  • Changing Page Orientation
  • Working with Columns
  • Adding Borders and Shading
  • Working with Multiple Headers and Footers
  • Creating Signature Lines

Automatic Mail Merge

  • Using Mail Merge to Create Form Letters
  • Data Sources
  • Mailing Labels and Envelopes
  • Advanced Mail Merge

Automating Document Creation

  • Using the Building Blocks Organizer
  • Working with AutoText
  • Using Field Codes
  • Creating a Macro

Creating Documents Fast and Effectively

  • Understanding the Word User Interface
  • Navigating and Selecting Text
  • Editing Text
  • Opening and Editing a PDF
  • Understanding Word File Formats

Creating Forms

  • Working with Form Fields
  • Adding Content Controls
  • Using the Form
  • Enforce Restricted Editing
  • Entering Data in a Form

Creating Organized Documents with Tables and Lists

  • Using Bulleted and Numbered Lists
  • Customizing Lists
  • Inserting Tables
  • Modifying and Formatting Tables
  • Adjusting Cells, Rows, and Columns
  • Formatting Tables
  • Creating Tables from Existing Text
  • Embedding an Excel Object

Designing Style Guides for Fast and Consistent Formatting

  • Creating and Applying Styles
  • Modifying and Navigating with Styles
  • Using Style Sets
  • Using Themes
  • Using Themes with Templates

Embellishing Documents with Graphics and Special Elements

  • Working with Drop Caps and Special Characters
  • Inserting and Formatting Pictures
  • Resizing Images
  • Inserting Text Boxes and Shapes
  • Working with Page Elements

Finish Strong: Finalizing a Document for Printing

  • Using Find, Replace, and Go To
  • Proofing Documents
  • Inserting Pages and Breaks
  • Working with Headers & Footers
  • Preparing a Document for Printing
  • Previewing and Printing Documents

Let's Get Graphic: Working with Pictures and Shapes

  • Working with Pictures
  • Inserting Text Boxes and Shapes
  • Wrapping Text around Objects
  • Grouping and Aligning Objects
  • Inserting SmartArt
  • Modifying a SmartArt Graphic
  • Enhancing Text with Effects and WordArt

Making Your Words Sing with Formatting

  • Applying Character Formatting
  • Working with Live Preview
  • Applying Paragraph Formatting
  • Adding Paragraph Borders and Shading
  • Using the Format Painter

Managing Long Documents with Word

  • Creating a Table of Contents
  • Creating an Index
  • Creating Tables of Figures or Tables of Tables
  • Outline View
  • Creating Master Documents

New Features in Word 2016

  • New in Word 2016
  • New Features Across Office Applications
  • Word 2016 Enhancements
  • Collaborating in Office 2016

Reference and Citation Tools in Word

  • Using Bookmarks
  • Using Hyperlinks
  • Creating Cross-references
  • Creating Footnotes and Endnotes
  • Inserting Citations and Bibliographies

Team Collaboration with Microsoft Word

  • Tracking Changes
  • Accept and Reject Changes
  • Working with Comments
  • Comparing and Merging Documents

Choose from the Following 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

How Can We Help?