You?re beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It?s all muscle and no fluff. Discover how the experts tackle Excel 2007?and challenge yourself to new levels of mastery!

• Learn expert techniques for designing powerful spreadsheets
• Apply built-in functions?or write your own?and carry out complex calculations
• Use rich charting capabilities and new SmartArt graphics to visually represent data
• Perform sophisticated data analysis: financial, statistical, and ?what-if?
• Design PivotTable reports to dynamically analyze data
• Share spreadsheets and collaborate with colleagues?and control access to sensitive data
• Link and embed Excel data into other documents
• Create macros with Microsoft Visual Basic for Applications

CD includes:

• Fully searchable eBook
• Sample spreadsheets from inside the book
• Add-ins and other resources to help you extend Microsoft Office programs
• Links to demos, user communities, and product support
• References for finding Excel 2003 commands in Excel 2007
• Windows Vista Product Guide eReference and other eBooks

A Note Regarding the CD or DVD

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 booktech@oreilly.com.