Sharpen your data analysis and presentation skills—and increase your impact!—with the MICROSOFT OFFICE EXCEL 2007 TOOLKIT. This set features two popular books—Microsoft Office Excel 2007 Step by Step and Create Dynamic Charts in Microsoft Office Excel 2007 and Beyond—at a terrific value. Twenty-three per cent off the suggested retail price! With STEP BY STEP, you set the pace for learning how to organize, analyze, and present data in Excel 2007—building and practicing the skills you need, just when you need them. Follow the easy numbered lessons and hands-on exercises to master the fundamentals, including how to: • Create formulas, calculate values, and analyze data • Present information visually with graphics, charts, and diagrams • Build PivotTable® dynamic views—even easier with new data tables • Reuse information from databases and other documents • Share worksheets for review and manage changes • Create macros to automate repetitive tasks and simplify your work Then, maximize the impact of your ideas and data with CREATE DYNAMIC CHARTS IN MICROSOFT OFFICE EXCEL 2007 AND BEYOND. Guided by an Excel expert, you’ll learn how to turn flat, static charts into dynamic solutions—where you can visualize and manipulate data countless ways with a simple mouse click. Get the hands-on practice and examples you need to produce your own, professional-quality results. No programming required! • Learn how your design decisions affect perception and comprehension • Match the right chart type to your communication objective • Visualize—then build—your solution using the author’s five-step approach • Apply the science of color to make the right things pop • Add controls—such as drop-down lists and scroll bars—without coding • Use conditional formatting to dynamically highlight and analyze data • Unleash your chart-making creativity—and bring numbers to life!