Office 2010 New Features - Beginner

4 Hours, 29 Minutes


Delivery Method

UT Pro from New Horizons

This class is part of a 12‑month UT Pro Subscription

Course Overview

This course covers those features of Microsoft Office 2010 that are new to the Office system, with dedicated units for the new features of each application. In Word, students will learn to use the Navigation pane and apply new text effects. In Excel, they will use Sparklines, filter data with slicers, and create a PivotChart. In PowerPoint, they will organize slides into sections, edit movie clips, apply animation effects, and learn how to broadcast slide shows. In Outlook, they will manage email conversations, create Quick Steps, and use the People pane. In Access, they will learn how to use the tabbed document window, create Lookup list fields, and use the data type gallery. In addition, students will learn about Ribbon customization, the Backstage view, saving a file as a PDF, and the benefits and features of the new XML file format. This course includes everything needed to work effectively within the new suite of applications.

Course Objectives

What's New Across Office 2010, New Features in Microsoft Excel 2010, New Features in Outlook 2010, New Features in Microsoft PowerPoint 2010, New Features in Microsoft Word 2010, New Features in Microsoft Access 2010, What's New Across Office 2010, New Features in Microsoft Excel 2010, New Features in Outlook 2010, New Features in Microsoft PowerPoint 2010, New Features in Microsoft Word 2010, New Features in Microsoft Access 2010

Course Prerequisites

The recommended pre-requisite for this course is Familiarity with Office 2007.


1 - Introduction

  • Introduction

2 - What's New Across Office 2010

  • Using the Ribbon
  • Understanding Contextual Tabs
  • Understanding Galleries and Live Preview
  • Using Dialog Box Launchers
  • Using Zoom and Views
  • Customizing the Status Bar
  • Using the Mini Toolbar
  • Customizing the Quick Access Toolbar and the Ribbon
  • Using Backstage View
  • Printing and Print Preview
  • Understanding the New XML File Format

3 - New Features in Microsoft Excel 2010

  • Understanding the New Worksheet Size
  • Using Conditional Formatting
  • Creating Sparklines
  • Charting
  • Using the New Table Improvements
  • Creating PivotTables
  • Adding Slicers

4 - New Features in Outlook 2010

  • Unserstanfding the New Interface
  • Using Conversations
  • Utilizing Quick Steps
  • Using Outlook Search Features
  • Working with Calendars
  • Working with Color Categories
  • Using the Out of Office Assistant
  • Managing Contacts

5 - New Features in Microsoft PowerPoint 2010

  • Applying New Themes, Masters, and Layouts
  • Creating Sections
  • Working with Video
  • Creating SmartArt Graphics
  • Adding Animation and Transition Effects
  • Broadcasting a Slideshow

6 - New Features in Microsoft Word 2010

  • Working with Formatting
  • Using the Navigation Pane
  • Creating Quick Parts
  • Inserting Objects

7 - New Features in Microsoft Access 2010

  • Using the Backstage View
  • Utilizing New Database Templates Including Web Databases
  • Using New Table Features
  • Working with the Improved Macro Designer
  • Creating Data Macros (Table Triggers)
  • Understanding New Form and Report Features

8 - Conclusion

  • Course Recap

What is UT Pro?

UT Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your UT Pro subscription.

  • Unlimited enrollments into over 90 full-day and short-duration live training classes
  • Over 750 hours of on-demand video based content
  • A full library of digital quick reference cards for your favorite Office applications
  • Access to class recordings so you never have to worry about missing a scheduled class

Benefits of a UT Pro Subscription

Our UT Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

  • Ask questions and get immediate answers during our full-day and short-duration live classes
  • Learn how to perform specific tasks instead of wasting time learning things you already know
  • Collaborate with fellow students and gain insight into new ways to solve problems
  • View on-demand courses with instructors that never leave your screen
  • Utilize course assessments to validate new skills
  • Take full day training classes on your schedule by accessing our class recordings
  • Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about UT Pro.