Master the Ribbon, powerful graphics capabilities, and more! Your one-stop guide to great-looking spreadsheets that actually mean something Create colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more! Discover how to Create dynamic spreadsheets with style galleries Work with more than 40 new cell styles Automate formatting with Live Preview Share Excel data with other programs Use VBA to write custom Excel functions

Revised and updated to cover changes to all of Office's applications and productivity tools Offers beyond-the-basics coverage of Office word processing, spreadsheets, presentations, e-mail, databases, and desktop publishing Covers Word, Excel, Access, PowerPoint, Outlook, Publisher, productivity tools such as Microsoft OneNote, and SharePoint Thoroughly updated to cover the new Office interface as well as new features in each application

Make Excel do the math and make sense of your data Use the Insert Function dialog box, array formulas and functions, and 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? Here's the fun and easy way! Discover how to * Create worksheets to track costs and revenue * Tell the difference among average, median, and mode * Work with statistical functions * Develop forecasts and track trends * Manipulate strings and work with database functions

One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here! If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done. You’ll discover how to: Rearrange, delete and insert new information Keep track of and organize data in a single worksheet Transfer data between the sheets of different workbooks Create a chart using the data in a worksheet Add hyperlinks and graphics to worksheets And more! Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.

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.

AutoCAD is the leading software tool for creating technical and architectural drawings, but it definitely doesn't lead in the "easy to master" category. That's why there's AutoCAD and AutoCAD LT All-in-One Desk Reference For Dummies—the perfect way to break a complex topic into bite-size, easy-to-understand pieces. Once you get the hang of using AutoCAD and its slightly less feature-rich cousin, AutoCAD LT, you discover that it offers wonderful advantages. AutoCAD allows you to Create precision to 14 significant digits Re-use portions of your drawings by copying and pasting Draw things full size and print your drawings in any scale Produce drawings that are easier to read when reduced Electronically share and distribute drawings Design in 2D or 3D So obviously, the trick is to speed up that "getting the hang of it" process. That's where AutoCAD and AutoCAD LT All-in-One Desk Reference For Dummies comes in especially handy. Ten easy-to-follow minibooks cover every aspect of AutoCAD, including the latest features of AutoCAD 2007, so you can find just what you need to know quickly and easily. You'll get the scoop on AutoCAD basics, such as setting up drawings, finding your way around the interface, and using all the tools Drawing and modifying objects in 2D and annotating your drawings 3D modeling and viewing, working with solids and surfaces, and rendering Understanding how AutoCAD LT differs from AutoCAD and deciding which program you need Advanced drafting skills, including organizing drawings, working with blocks, and using AutoCAD utilities Setting up your drawings for plotting to paper and publishing Sharing your drawings online for collaboration Customizing and programming AutoCAD to make it work the way you want it to In the familiar, friendly For Dummies fashion, AutoCAD and AutoCAD LT All-in-One Desk Reference For Dummies gives you plain-English explanations and step-by-step directions. Written by a pair of AutoDesk Authorized Authors, this handy guide will help make your relationship with AutoCAD a happy and productive one.