Sharpen your data analysis and presentation skills--and increase your impact--with this two-in-one toolkit. Master Excel 2007 fundamentals at your own pace with STEP BY STEP. Then discover how to create more-powerful and compelling charts--and really distinguish yourself from the crowd. Microsoft Office Excel 2007 Step by Step: Teach yourself how to organize, analyze, and present data with Excel 2007--one step at a time! Create formulas, calculate values, and analyze data Use charts and graphics to present data visually Build PivotTable dynamic views Exchange data between Excel and other Office docs Protect workbooks you share over the Web Create macros to automate repetitive tasks CD includes: Skill-building practice files Fully searchable eBook Bonus eReferences Create Dynamic Charts with Microsoft Office Excel 2007 and Beyond: Maximize the impact of your ideas and data! Learn how to turn flat, static charts into dynamic solutions--where you can visualize and manipulate data countless ways with a simple mouse click. See how design decisions affect perception and comprehension Match the right chart type to your communication goal Use a five-step approach to visualize and build your solution Apply the science of color Add drop-down lists and scroll bars--no coding Dynamically highlight and analyze data Unleash your chart-making creativity! CD includes: 150+ customizable charts for various business scenarios Fully searchable eBook Bonus content and resources

Combine the power of Excel 2007, Microsoft Office SharePoint Server, and sound project management tools to boost your skill set and maximize your productivity. You’ll walk through a project and learn how to use these powerful tools to schedule jobs, create budgets, manage processes, and share project information. Whether new to project management or a veteran, you’ll discover techniques, hints, and examples you can use immediately.

Completely redesigned to help users finish tasks more quickly and manage information more effectively, Microsoft Office 2007 will offer users a new look and smarter ways of getting things done. From the expanded depth and power of Excel 2007 to the new graphics capabilities and formatting tools of PowerPoint, Microsoft has rethought and reworked the entire suite. And in this new edition of our Office Visual QuickStart Guide, author Steve Schwartz has rewritten from the ground up the entire book to better aid readers as they get up to speed with the new Office tools. The book is essential reference tool for the home and small business user, covering everything in the Office Basic, Home & Student, Standard, and Small Business suites. Software covered includes: Word, Excel, OneNote, Outlook, PowerPoint, and Publisher. Easy visual approach uses pictures to guide you through Microsoft Office and show you what to do. Concise steps and explanations let you get up and running in no time. Page for page, the best content and value around. Table of Contents: Part I: Introducing Microsoft Office 2007 Chapter 1: What's New in Office 2007? Chapter 2: Office Basics Part II: Microsoft Word Chapter 3: Getting Started with Word 2007 Chapter 4: Formatting Documents Chapter 5: Creating Outlines Chapter 6: Tables, Charts, and Art Chapter 7: Sharing Word Documents Part III: Microsoft Excel Chapter 8: Getting Started with Excel 2007 Chapter 9: Formatting Worksheets and Data Chapter 10: Formulas and Functions Chapter 11: Working with Tables Chapter 12: Creating Charts Part IV: Microsoft PowerPoint Chapter 13: Getting Started with PowerPoint 2007 Chapter 14: Creating a Presentation Chapter 15: Completing a Presentation Part V: Microsoft Outlook Chapter 16: Getting Started with Outlook 2007 Chapter 17: Using the Address Book Chapter 18: Composing and Sending Mail Chapter 19: Receiving Mail Chapter 20: Managing the Mail Chapter 21: Tasks and Appointments Part VI: Microsoft OneNote Chapter 22: Getting Started with OneNote 2007 Chapter 23: Creating Notes Chapter 24: Embellishing and Editing Notes Chapter 25: Managing Notes Part VII: Microsoft Publisher Chapter 26: Getting Started with Publisher 2007 Chapter 27: Distributing and Printing Index

Microsoft Office Excel 2007 is the biggest revision this industry standard software has undergone in years. It has a brand new interface, tons of new tools and even a suite of services called Excel Services to allow you to share your valuable data on the web. For the first time in years there is a lot to learn to make the most of this powerful new update. To take advantage of all of the new features in this powerful program (and to do so quickly), users need this Vi sual QuickStart Guide. In these pages, veteran author and trusted Excel teacher Maria Langer provides step-by-step instructions for the full gamut of Excel tasks: from worksheet basics like editing, using functions, formatting cells, and adding graphics objects, to more advanced topics like creating charts, working with databases, and Web publishing. As with all Visual QuickStart Gui de books, clear, concise instructions and lots of visual aids make learning easy and painless.

Brilliant guides allow you to find the info you need easily and without fuss and guide you through the task using a highly visual, step-by-step approach - providing exactly what you need to know, when you need it !! Brilliant Excel 2007 will show you how to .... · Create workbooks more efficiently using the new results-oriented interface · Use data analysis tools and techniques for better decision making · Use organizing, processing, and presenting tools to create data in Excel · Integrate data from external sources and add hyperlinks · Use conditional formatting to visualize results · Create your own macros to automate your work · Add impact to your data with PivotTable and PivotChart reports · Create organizational data reporting and publishing solutions · Organize information and impact with clip art, SmartArt diagrams, tables and charts · Use Groove and SharePoint Team Services to collaborate and share documents and information

This book looks at the new version of Microsoft Windows Office.

THE ONLY EXCEL BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Excel proficiency and use of more advanced features. If you buy only one book on Excel, Special Edition Using Microsoft® Office Excel® 2007 is the book you need. Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables? If you answered yes to any of these questions, Special Edition Using Microsoft® Office Excel® 2007 is the bookthat will make it all better. Learn quickly and efficientlyfrom a true Excel master using the tried and true SpecialEdition Using formula for success. Here, you’ll findinformation that’s undocumented elsewhere—even inMicrosoft’s own Help systems. You’ll learn from finelycrafted, real-life examples built by an author who livesand dies by the integrity of his spreadsheets. Excel’s backbone is its formulas and functions. Master those and you will master your spreadsheets. Special Edition Using Microsoft Office® Excel® 2007 provides more down and dirty help with your formulas and functions than you’ll find in any other book! See how it’s done in real life! Don’t settle for lame pivot table and chart examples found in other books… This book provides beautifully detailed examples that not only show you how it should be done, but how to be the local worksheet hero!