Table of Contents

What’s New in Excel 2007?.- Customizing Excel.- Excel Essentials.- Styles and Formatting.- Sorting and Filtering.- Analyzing Data Using Subtotals, Consolidations, and Tables.- Creating PivotTables and PivotCharts.- Editing PivotTables and PivotCharts.- What-If Analysis.- Formulas and Functions.- Charts.- Adding Graphics to a Worksheet.- Preventing and Correcting Errors.- Protection and Security.- Getting Data from External Sources.- Sharing, Reviewing, and Distributing Data.- SharePoint and Excel Services.

About the Author

Helen Dixon works for Queen's University in Belfast, U.K., training staff and students in IT and providing a consultancy service for staff. Her qualifications include a bachelor's degree (with honors) in business studies and a master's in computing and information systems. She is studying for a Ph.D. in electronic commerce.