Search all of Office.com
 
Support / Excel / Excel 2007 Help and How-to
 
 

Training

Charts I: How to create a chart in Excel 2007

Training Overview Charts make data visual . Instead of having to analyze columns of worksheet numbers, you can see at a glance what the data means. After completing...

Excel 2007 training courses

Article A roadmap to Excel 2007 training: 1. Get familiar with Excel Up to speed with Excel 2007 The layout of the new design, how to accomplish everyday tasks...

Excel Services I: The basics

Training Overview Use Excel Services to publish an Excel 2007 spreadsheet to your SharePoint site , where multiple people can access the spreadsheet at the same...

Excel Services II: Requirements, recommendations, and permissions

Training Overview Learn the requirements for using Excel Services and how permissions can be set so that some people can edit spreadsheets, while others can only...

Excel Services III: Control what people see

Training Overview Control what people can see when you use Excel Services to publish an Excel 2007 spreadsheet to your SharePoint Server 2007 Enterprise site. After...

Excel Services IV: Allow user input

Training Overview Allow people to enter data for selected cells when you use Excel Services to publish an Excel 2007 spreadsheet to your Microsoft Office SharePoint...

Get to know Excel 2007: Create your first workbook

Training Overview Learn how to create a workbook in Microsoft Office Excel 2007, how to enter and edit text and numbers, and how to add and delete columns and rows...

Get to know Excel 2007: Enter formulas

Training Overview Get to know Microsoft Office Excel 2007 by learning how to enter formulas into worksheets and perform simple calculations. Then, ditch your calculator...

Keyboard shortcuts in the 2007 Office system

Training Overview Many of the programs in the 2007 Microsoft Office system have a brand-new look. Most menus and toolbars have gone away, and along with the new...

Learn how to figure out dates using formulas in Excel 2007

Training Overview Use formulas in your Microsoft Excel spreadsheet to figure out dates. After completing this course you will be able to: Use formulas to find...

Office Open XML I: Exploring the Office Open XML Formats

Training Overview By Stephanie Krieger, Document Production Expert The new Office Open XML Formats provide a wide range of functionality in the 2007 Office system...

PivotTable I: Get started with PivotTable reports in Excel 2007

Training Overview Make sense out of data . Learn about Microsoft Office Excel 2007 PivotTable reports, a fast and powerful way to analyze data and answer questions...

PivotTable II: Filter PivotTable report data in Excel 2007

Training Overview Learn how to filter data in PivotTable reports with Microsoft Office Excel 2007. After completing this course you will be able to: Filter to...

PivotTable III: Calculate data in PivotTable reports in Excel 2007

Training Overview Work with numbers in PivotTable reports in Microsoft Office Excel 2007 to help you see what your data means. After completing this course you...

Security I: How the 2007 Office system helps you to stay safer

Training Overview Find out about security risks to your computer and ways to help to protect it, as well as how the 2007 Microsoft Office system new file formats...

Share Excel data with others by exporting it to a SharePoint site

Training Overview Export Microsoft Office Excel 2007 data to your Microsoft Office SharePoint Server 2007 site or Windows SharePoint Services 3.0 site so that others...

Up to speed with Excel 2007

Training Overview Get a hands-on introduction to the new look of Microsoft Office Excel 2007, and see how to do what you're used to doing in Excel as you get up...

Up to speed with the 2007 Office system

Training Overview Get an introduction to the new look in familiar programs of the 2007 Microsoft Office system. Then try out the changes with a hands-on test drive...

Import data from Excel to a new table in Access 2007

Training Learn how to import data from Excel into a new table in Access. Importing is a faster way to put Access to work for you.

Security III: Sign your own macros for stronger security

Training Overview Learn why signing your own macros will reduce the number of security warnings you see while still maintaining a high security level, and find...

SharePoint document libraries I: Introduction to sharing files

Training Overview Does your company use a Windows SharePoint Services 3.0 site , or does it use Microsoft Office SharePoint Server 2007? If so, it's essential that...

SharePoint document libraries II: All about checkout

Training Overview Does your company use a Windows SharePoint Services 3.0 site, or does it use Microsoft Office SharePoint Server 2007? If so, you should take this...

SharePoint document libraries III: Work with version history

Training Overview Does your company use a Windows SharePoint Services 3.0 site, or does it use Microsoft Office SharePoint Server 2007? It's possible that your...

SharePoint document libraries IV: Tips and tricks

Training Overview Does your company use a Windows SharePoint Services 3.0 site, or does it use Microsoft Office SharePoint Server 2007? Do you use document libraries...

SharePoint document libraries V: How to download a library

Training Overview Does your company use a Windows SharePoint Services 3.0 site, or does it use Microsoft Office SharePoint Server 2007? Have you ever needed to...