Experience learning made easy and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace building and practicing the skills you need, just when you need them! Create formulas, calculate values, and analyze data Present information visually with graphics, charts, and diagrams Build PivotTable dynamic views even easier with new data tables Reuse information from databases and other documents Share spreadsheets for review and manage changes Create macros to automate repetitive tasks and simplify your workYour all-in-one learning experience includes: Files for building skills and practicing the book s lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista Product Guide eReference plus other resources on CD

Table of Contents

What's new in Excel 2007? Setting up a workbook Working with data & data tables Performing calculations on data Changing document appearance Focusing on specific data using filters Re-ordering & summarizing data Combining data from multiple sources Analyzing alternative data sets Creating dynamic lists with PivotTables Creating charts & graphics Printing Automating repetitive tasks with macros Working with other Office system prograpms Collaborating with colleagues