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.

Fast answers to frequently asked questions Excel 2007 essentials at your fingertips! If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you'll quickly find just what you need to know about navigating the new interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more.

From formulas to functions to the latest features - practice and plan Excel tasks with ease Confused by Excel? Want to make the most of its capabilities? No worries - this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas, working with charts and graphics, managing and securing data, and creating macros, you'll do it all with the help of practice files and more than 30 walk-throughs of Excel features on the CD-ROM. Plus, you get full coverage of all the new and enhanced features of Excel 2007! See how to * Set up, format, and edit basic spreadsheets * Manage and secure your Excel data * Create formulas and functions for finance, date and time, math, text, and more * Master data analysis with pivot tables * Save and share your spreadsheet data Quick refresher explanations Step-by-step procedures Hands-on practice exercises Tear-out Cheat Sheet A dash of humor and fun All this on the bonus CD-ROM * Dynamic video walk-throughs demonstrate Excel features and tasks * Practice files let you work through the exercises in the book For details and complete system requirements, see the CD-ROM appendix.

Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more. Discover how to Grasp essential programming concepts Use the Visual Basic Editor Navigate the new Excel user interface Communicate with your users Deal with errors and bugs

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

This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features Includes a valuable CD-ROM with templates and worksheets from the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Microsoft SharePoint now has a 10 percent share of the portal market, and the new release, which features enhanced integration with Office 2007, is sure to give SharePoint a boost Offers clear instructions and soup-to-nuts coverage of this complex product, focusing instead on practical solutions to real-world SharePoint challenges Features tips, tricks, and techniques for administrators who need to install and configure a SharePoint portal as well as ordinary users who need to populate and maintain the portal and use it for collaborative projects Topics covered include setting up a SharePoint portal, matching SharePoint to business needs, managing portal content, branding, collaborating on SharePoint sites, using a portal to improve employee relations and marketing, putting expense reports and other interactive forms on a portal, and monitoring and backing up SharePoint

Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentations Now revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XML Provides thorough coverage of Excel features that are critical to data analysis-working with external databases, creating PivotTables and PivotCharts, using Excel statistical and financial functions, sharing data, harnessing the Solver, taking advantage of the Small Business Finance Manager, and more

Includes cheat sheet perf-bound into book.

Happiness is an important part of life-no less than anger, sadness, and fear. It begins with life itself: What mother doesn't recognize the look of happiness on the face of her newborn? Human beings are wired with an innate, neurological potential for happiness, but whether this potential eventually becomes a reality depends on how we choose to live our lives. In other words, happiness isn't an accident, and it isn't a gift from the gods-it's the gift you give yourself! Unlike Shangri-La, a mythical paradise on Earth, happiness is not confined to a particular place, nor is it the result of any one specific activity or life circumstance. Happiness is a personal state of physical, spiritual, and emotional well-being that you can experience anywhere at any time. This morning, for example, before I began to work on this book, I spent a few happy moments sitting in my driveway quietly watching my two basset hounds, Max and Dixie, experiencing another day through the many divergent smells on a crisp fall morning in Virginia. If you're like me, you're far too passive when it comes to experiencing happiness. You wait for it to find you instead of exercising your right to pursue it. It's because most people are passive when it comes to happiness that happiness seems so elusive! Face it: We live in proactive times. People around the world don't wait for freedom-they fight for it. Wealth is no longer something you have to inherit (despite what Paris Hilton may think)-you can create it. People are living longer these days. Why? Because we're learning that we can improve quality of life through the everyday choices we make. Happiness For Dummies tells you how to fight for, create, and live a long and happy life. It makes you the master of your own happy destiny!