Learn how to conquer Microsoft Office Excel 2007—from the inside out! This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds, all in concise, fast-answer format.

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

The CD that accompanies the print edition of this book is not available with its eBook edition, although select CD content is available for download. A link to the content is included in your eBook.