Microsoft Office Excel 2007 Inside Out by Mark Dodge, Craig Stinson

From Barnes & Noble

The Barnes & Noble Review
Whatever 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

From the Publisher

Conquer Microsoft Office Excel 2007—from the inside out!

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

Product Details