This book is packed with advanced timesaving tips and troubleshooting methods to help you learn the smartest, simplest ways to create powerful documents. Discover how the experts approach document production—and reach new levels of mastery!Exploit the power of tables, Themes, and templates Produce professional-quality graphics using new SmartArt diagrams, custom shapes, and other drawing tools Customize and reuse content with Building Blocks and Content Controls Learn advanced techniques for managing slide masters and custom layouts for effective presentations Design PivotTables for more powerful data analysis and reporting Build sophisticated Excel 2007 chart types and customize chart elements Use Microsoft Visual Basic for Applications (VBA) to automate document production and customize templates Customize the Office Fluent Ribbon and troubleshoot your documents with Office Open XML CD includes:Fully searchable eBook Sample documents and templates VBA and Office Open XML code samples Author webcasts—see advanced techniques in action Tool for binding custom XML to content controls in Word 2007 Files for customizing the Fluent Ribbon Links to articles blogs, and developer learning resources Windows Vista Product Guide eReference and other eBooks A Note Regarding the CD or DVDThe 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 O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's 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.

    Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical guide—now updated for Excel 2007. Use Wayne’s proven practices and hands-on exercises to help you work smarter, make better decisions, and gain the competitive edge.Solve real-world business problems with Excel 2007!Maximize profits—determine NPV, optimize your product mix, calculate ROICreate best, worst, and most-likely case scenarios for salesAnalyze investment performance and help minimize riskTrack your personal finances, calculate loan terms, and plan for retirementUse trend and seasonality to forecast revenueEstimate a product’s demand curve and manage inventory with precision Interpret the effects of price and advertising on salesAssign a dollar value to customer loyaltySolve work scheduling problems and shorten wait times for customer service queuesPLUS—predict outcomes of sporting events, presidential elections, and more!CD Includes:Sample files from each chapterProblem-and-solution sets—build your expertise!Fully searchable eBookA Note Regarding the CD or DVDThe 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.