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. Introduction PART I: CREATING SPREADSHEETS: Getting familiar with the Excel 2007 interface Entering the spreadsheet data Formatting the spreadsheet Printing the spreadsheet Modifying the spreadsheet PART II: USING FORMULAS AND FUNCTIONS: Building formulas Copying and correcting formulas Creating data and time formulas Financial formulas and functions Using math functions Using common statistical functions Using lockup functions Using logical functions Text formulas and functions PART III: WORKING WITH GRAPHICS: Charting spreadsheet data Adding graphics to spreadsheets PART IV: MANAGING AND SECURING DATA: Building and maintaining data lists Protecting the spreadsheet PART V: DOING DATA ANALYSIS: Performing what-if analysis Generating pivot tables PART VI: MACROS AND VISUAL BASIC FOR APPLICATIONS: Using macros Using the visual basic editor PART VII: THE PART OF TENS: Top ten features in Excel 2007 Top ten tips for using Excel like a pro Appendix: About the CD. 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 .. Completely rewritten to reflect the major changes Microsoft has made to Office, this reference includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, adding hyperlinks to worksheets, and more. Showcases Excel's updated features and new user interface while explaining how to use Excel 2007 to build and format spreadsheets, sort and analyze data, and integrate spreadsheets with Web documents and other Office applications.
