MS OFFICE 2003 UPGRADE TO 2007 OR 2010

Course Length: 1/2 day session

Who should attend: Someone who is an experienced MS Office 2003 user and has recently upgraded their software to version 2007 or 2010.

Suggested Background: Should understand how to use basic Word or Excel.

This course covers the commonly used NEW features of version 2007 or 2010 for a typical user and introduces the new interface that supports commands in the Office applications.

Note: This course can be customized to meet a company’s specific employee needs.

Upon completion of this course, you will:

Work with the New Office Interface

Use the Office Button for file management (Open, Save, Print) 2007 only

Use Backstage View for file management 2010 only

Review the new Ribbon, Mini toolbar and Dialog Box Launchers

Customize the Quick Access toolbar

Save your work using new File formats (XML) & as a PDF

Understand Special Command tabs, (Contextual tabs)

Use the new Galleries to format data

New EXCEL Features (2007)

Create a quick charting using new Charting features

Preview Page Layout view for adding Headers/Footers

Define a data range as a table to enable filtering

Easily create a PivotTable & PivotChart

New EXCEL Features (2010)

Add Sparklines – a small chart added within a cell for trending

Add Slicers to a PivotTable for easy analyzing

New WORD Features (2007)

Work with the new Style gallery to format text

Insert charts from Excel into Word

Insert Quick Parts (reusable document components)

Work with the Building Blocks Organizer (library of quick parts)

New WORD Features (2010)

Work with new Text effects (format text as you format images)

Find info using the new Navigation pane

Take a look at the PowerPoint, Access & Outlook Interfaces, if necessary