Office 2007 New Features - Beginner

Duration
3 Hours, 9 Minutes

 

Delivery Method
Self-Paced

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 2007 that are new to the Office suite of products, with dedicated units for the new features of each application. In Word, you will learn to use Quick Parts and themes, review changes in paragraph styles, and see changes in inserting tables and formatting objects. In Excel, you will learn to use changes in PivotTables and data tables, apply new conditional formatting, and review enhancements in charting. In PowerPoint, you will understand the changes in slide layouts and slide masters, how to use and modify design themes, apply new effects to graphics, and work with SmartArt. In Outlook, you will review changes in tasks, learn to use search folders, add RSS feeds, and see changes in sharing calendars. In Access, you will learn how to use new templates, create a new table, understand changes in sorting and filtering, and work with new features in forms and reporting. In addition, you will learn how to navigate in the new user interface by working with the Ribbon and Quick Access Toolbar. You will also learn 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

New Features in PowerPoint 2007 , New Features in Outlook 2007 , New Features in Microsoft Excel 2007 , New Features in Access 2007 , Introduction , Conclusion , What's New in Office? , New Features in Word 2007

Course Prerequisites

Basic computer skills and familiarity with Microsoft Office 2003 or prior.

Agenda

1 - Introduction

  • Introduction

2 - What's New in Office?

  • Understanding the Ribbon
  • Introducing the Office Button
  • Using the Quick Access Toolbar
  • Using Help, Ruler, and Views
  • Using the Status Bar
  • Understanding Galleries and Live Preview
  • Using a Dialog Box Launcher
  • Understanding the XML File Format

3 - New Features in Word 2007

  • Working with Themes and Paragraph Styles
  • Using Quick Parts and the Building Blocks Organizer
  • Inserting Tables and Graphics
  • Applying Picture Effects

4 - New Features in PowerPoint 2007

  • Customizing Slide Layouts
  • Using the Slide Master
  • Charting
  • Applying Design Themes
  • Applying Graphic Effects
  • Using SmartArt

5 - New Features in Outlook 2007

  • Using the To Do Bar and Tasks
  • Searching Folders
  • Exploring the New Calendar Features
  • Using Categories
  • Adding RSS Feeds

6 - New Features in Microsoft Excel 2007

  • Working with the New Worksheet Size
  • Using Charts
  • Applying Conditional Formatting
  • Using Tables
  • Working with PivotTables

7 - New Features in Access 2007

  • Using Templates
  • Using the Ribbon
  • Creating a New Table
  • Sorting and Filtering
  • Creating Forms
  • Creating Reports

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.