Microsoft Office Excel 2007

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 work

Your 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

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].

Excel provides an easy-to-use, powerful spreadsheet environment that helps you handle calculations and data more effectively - with simple ways to enter and edit data, work with formulas and functions for complex calculations, format worksheets and work with colorful charts, and publish documents to the Web. With Microsoft Excel 2007 Step By Step, you'll learn all the ins and outs of working with Excel features, including the exciting new interface for this latest version of Office. This information-packed guide provides numbered steps and hands-on examples that show you how to get the most out of Excel. With this book, you'll learn how to work with tools to make worksheet entry faster, make your Excel documents more attractive, present information visually with charts, sorting and filtering data, publish documents on the Web, and lots more. The companion CD provides all exercise source files so that you get hands-on with Excel right away.

The smart way to learn Office Excel 2007-one step at a time! Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting help to master the fundamentals of working with the latest version of Excel, including how to navigate the new user interface. You'll learn how to create a wide-variety of documents, how to present information visually with charts, and how to add graphics to your spreadsheets. You will discover how to work with features to make data entry faster, how sort and filter data, how to create dynamic lists with Pivot Tables, and even how to publish your documents to the Web-plus more! With Step By Step, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction-building and practicing the skills you need, just when you need them! Includes a companion CD with hands-on practice files.

Curtis D. Frye is a coauthor of Microsoft Office Excel 2003 Programming Inside Out and the author of Microsoft Office Excel 2007 Step by Step, Microsoft Excel Version 2007 Plain & Simple, Faster Smarter Home Networking, several books on Microsoft Access, and numerous online training courses.