Free Training for Excel 2007

Microsoft has made many modifications to the user interface for all Office 2007 applications, and that means relearning how to use most Excel features in Excel 2007. All menus and toolbars have been replaced with a new "Ribbon" interface and Tabs. These Ribbon and Tabs are located horizontally across the screen and graphically depict groups of features and functionality.

Here are Four Free Training Resources for Learning How to Use Excel 2007. The first one is an online course that will help you learn how to use the Ribbon, find familiar features, and understand and use the new XML file format. The second one is a reference for the locations of Excel 2003 commands in Excel 2007. The third learning resource is a 3 page Excel 2007 Charting tutorial. The fourth document is a spreadsheet that maps all Excel 2003 menu and toobar items to Excel 2007's ribbon interface.


1) Free Excel 2007 Online Course: Up to Speed with Excel 2007

Learn how to use the new user interface of Microsoft Excel 2007, and find out how to do the everyday tasks that you normally do in Excel.

Length: 30–40 minutes

Course Goals:

• Get a handle on the new look of Excel.
• Find everyday commands on the Ribbon: Cut, Copy, Paste, Insert Sheet Rows, Insert Sheet Columns, and Sum.
• Save workbooks in the new Excel file formats.

This course includes:

• Three self-paced lessons and two practice sessions for hands-on experience. Practices require Excel 2007.
• A short test at the end of each lesson; tests are not scored.
• A Quick Reference Card you can take away from the course.

Excel 2007 Course Contents:

Overview

What's changed, and why

• What's on the Ribbon?
• More commands, but only when you need them
• More options, if you need them
• Put commands on your own toolbar
• What about my favorite keyboard shortcuts?
• A new view
• Different screen resolutions can change what you see
• Practice
• Test yourself

Get to work in Excel

• Open your file
• Insert a column
• Format and edit data
• Enter a formula
• Add headers and footers
• Print
• The New Workbook window
• Practice
• Test yourself

A new file format

• How do I work with people who don't have Excel 2007 yet?
• Benefits of the new format
• New file formats, new options when you save
• Test yourself

Feedback

Quick Reference Card


2) Reference: Locations of Excel 2003 commands in Excel 2007

This tutorial describes the items of the new Microsoft Office Fluent user interface that are in Microsoft Excel 2007. It also shows you commands which you may already know how to use in Microsoft Excel 2003, and explains how to do the same tasks or features in Excel 2007.

• Introducing the new interface
• Adding commands to the Quick Access Toolbar
• New locations of familiar commands

3) Excel 2007 Tips for Creating Functional and Attractive Charts

This article explains the Top Ten Tips and Tricks for Excel 2007 Charts. Excel charts have been given a makeover in Excel 2007 and the Chart Wizard of earlier versions is now gone. Find out how to create functional and attractive charts using Excel 2007.

Excel Charting Tips - Pages 2 and 3:

• Top Ten Tips and Tricks for Excel 2007 Charts
• More Tips and Tricks for Creating Excel 2007 Charts

4) Excel 2007 Ribbon Mapping from Excel 2003

This spreadsheet (.xls) maps all of the menu and toolbar features and options in Excel 2003 to the equivalent in Excel 2007 for each of the following:

• Standard toolbar
• Formatting toolbar
• PivotTable toolbar
• Chart Toolbar toolbar
• Reviewing
• Forms
• Stop Recording
• External Data
• Formula Auditing
• Circular Reference
• Visual Basic
• Web
• Control Toolbox
• Exit Design Mode
• Watch Window
• Borders
• Protection
• Text to Speech
• List
• Compare Side by Side
• Drawing toolbar
• WordArt
• Pictures
• Organization Chart
• Diagram
• Ink Drawing and Writing
• Ink Annotations
• Shadow Settings
• 3D Settings
• File Menu
• Edit Menu
• View Menu
• Insert Menu
• Format Menu
• Tools Menu
• Data Menu
• Chart Menu
• Windows Menu
• Help Menu