Overview
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 [email protected].
Synopsis
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 [email protected].
Editorials
From Barnes & Noble
The Barnes & Noble ReviewWhatever you need or want to do with Microsoft Excel 2007, this big, authoritative book is almost certain to show you how.
Want to track a moving average? Make the most of Excel 2007's seriously improved conditional formatting? Format cells to display elapsed time? Project the future value of an investment? Format PivotTables to replace unsightly empty cells with text (such as "N/A")? Build queries to import data from external databases, or even from the Web? Mark Dodge and Craig Stinson will show you how.
Want to calculate regressions (and understand what they are)? That's in here. So is all manner of workbook collaboration, from integrating changes from multiple workbooks to working through SharePoint document workspaces. But our favorite feature: this book's extensive troubleshooting help. If you've ever wondered why your function returned values that were so weird, ask Dodge and Stinson: They know. Bill Camarda, from the May 2007 Read Only