Make Excel do the math & make sense of your data Use the Insert Function dialog box array formulas & functions & more Excel 2007 has more than 500 built-in functions. This book looks at the top 150 so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing? Heres the fun & easy way! Discover how to Create worksheets to track costs & revenue Tell the difference among average median & mode Work with statistical functions Develop forecasts & track trends Manipulate strings & work with database functions ...

You re beyond the basics so dive in & really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions troubleshooting tips & workarounds. It s all muscle & no fluff. Discover how the experts tackle Excel 2007 & challenge yourself to new levels of mastery! Learn expert techniques for designing powerful spreadsheets Apply built-in functions or write your own & carry out complex calculations Use rich charting capabilities & new Smart Art graphics to visually represent data Perform sophisticated data analysis: financial statistical & what-if Design Pivot Table reports to dynamically analyze data Share spreadsheets & collaborate with colleagues & control access to sensitive data Link & embed Excel data into other documents Create macros with Microsoft Visual Basic for Applications CD
Includes:: Fully searchable e Book Sample spreadsheets from inside the book Add-ins & other resources to help you extend Microsoft Office programs Links to demos user communities & product support References for finding Excel 2003 commands in Excel 2007 Windows Vista Product Guide e Reference & other e Books
...

Step-by-Step Full-Color Graphics! Get started using Microsoft Office Excel 2007 right away--the Quick Steps way. Color screenshots & clear instructions show you how to use all the new & enhanced features available in this premier spreadsheet program. Follow along & learn to work with the new Office interface & ribbon create workbooks use Excel's XML file formats enter & edit data use formulas & functions create charts & tables analyze data & more. Plus it's easy to flip straight to the information you need using the color-coded tabs. Get the book that gets you started using Excel 2007 in no time. In each chapter: Shortcuts for accomplishing common tasks Need-to-know facts in concise narrative Helpful reminders or alternate ways of doing things Bonus information related to the topic being covered Errors & pitfalls to avoid ...

This title

Includes:: step-by-step full-color graphics! Start using Excel 2010 right away
- the Quick Steps


...

The smart way to learn Microsoft Office Home & Student 2013
- one step at a time! Experience learning made easy
- & quickly

...

Learn the simplest ways to get things done with Microsoft (R) Office 2013 Get the full-color visual guide that makes learning Microsoft Office 2013 plain & simple! Follow the book's easy steps & screenshots & clear concise language to learn the simplest ways to get things done with Microsoft Word Excel (R) Outlook (R) Power Point (R) Access (R) Publisher & One Note (R). Here's WHAT you'll learn: Navigate with mouse keyboard or touch Create documents reports databases & presentations Share your desktop worksheets & files Manage your email & organize your calendar Stay connected with online meetings & instant messaging Access your programs & your documents via the cloud Here's HOW you'll learn it: Jump in wherever you need answers Follow easy STEPS & SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques & shortcuts Use TRY THIS! exercises to apply what you learn right away ...

Create project plans that make the most of your money & time Get your projects on track manage resources & share information online Project 2007 helps you keep your projects on track by providing sophisticated tools for building task outlines & important timing relationships; efficiently assigning people cost & material resources; & keeping everyone & everything on schedule. Get an overview of the benefits of Project Server & Project Web Access for communicating with your team & managing your project online. All this on the bonus CD-ROM* Tools for creating enhanced graphics & reports* Strategic planning & brainstorming tools* Project add-ons that improve your time reporting & tracking capabilities* For details & complete system requirements see the CD-ROM appendix. Discover how to* Employ the powerful new features of Project 2007* Track down problems with Task Drivers* Explore Project's new Visual Reports* Get tips for saving time & money on your projects Note: CD-ROM/DVD & other supplementary materials are not included as part of e Book file. ...

Experience learning made easy & quickly teach yourself how to manage your projects with Project 2007. With Step By Step you set the pace building & practicing the skills you need just when you need them! Build a project plan & fine-tune the details Schedule tasks assign resources & manage dependencies Monitor progress & costs & keep your project on track Format Gantt charts & other views to communicate project data Begin exploring enterprise project management systems Your all-in-one learning experience
Includes:: Files for building skills & practicing the book s lessons Fully searchable e Book Bonus guide to the Ribbon the new Microsoft Office interface Quick course on project management in the Appendix Windows Vista Product Guide e Reference plus other resources on CD
...

Get the guide that makes learning Microsoft Outlook 2010 plain & simple! This full color no-nonsense book shows you the quickest ways to manage your email & schedule appointments using easy-to-follow steps & concise straightforward language. Youll learn how to stay productive & in touch with all of your personal & business networks. Heres WHAT youll learn: * Navigate the user interface with Backstage view & the customizable ribbon * Organize your inbox & calendar -- even manage large amounts of e-mail with ease * Send & receive e-mail & filter out the junk * Keep track of your contacts & stay in touch * Schedule appointments write notes & keep a journal * Read RSS feeds right from your inbox & heres HOW youll learn it: * Jump in wherever you need answers * Easy-to-follow STEPS & SCREENSHOTS show exactly what to do * Handy TIPS teach new techniques & shortcuts * Quick TRY THIS! exercises help you apply what you learn right away ...

Get the guide that makes learning Microsoft Power Point 2010 plain & simple! This full color no-nonsense book shows you the quickest ways to solve problems & learn the tools using easy-to-follow steps & concise straightforward language. Youll discover new & exciting ways to create & share dynamic presentations with any audience. Heres WHAT youll learn: * Navigate the user interface with Backstage view & the customizable ribbon * Create presentations from templates or from scratch * Add tables charts & other graphics * Use animation sound & other special effects * Apply themes layouts & master slides * Print slides & notes -- & deliver a polished presentation & heres HOW youll learn it: * Jump in wherever you need answers * Easy-to-follow STEPS & SCREENSHOTS show exactly what to do * Handy TIPS teach new techniques & shortcuts * Quick TRY THIS! exercises help you apply what you learn right away ...