excel-2007-the-missing-manual.jpg

Excel 2007: The Missing Manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. It’s a perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

This book teaches you not only how the program works, it also shows you how to use Excel’s tools to answer real-world questions like “How many workdays are there between today and my vacation?”, “How much money do I need in the bank right now to retire a millionaire?“, and “Statistically speaking, who’s smarter Democrats or Republicans?” Best of all, you’ll steer clear of obscure options that aren’t worth the trouble to learn, while homing in on the hidden gems that’ll win you the undying adoration of your coworkers, your family, and your friendsor at least your accountant.

TABLE OF CONTENT:

  • Chapter 01 - Creating and Navigating Worksheets
  • Chapter 02 - Adding Information to Worksheets
  • Chapter 03 - Moving Data Around a Worksheet
  • Chapter 04 - Managing Worksheets and Workbooks
  • Chapter 05 - Formatting Cells
  • Chapter 06 - Smart Formatting Tricks
  • Chapter 07 - Viewing and Printing Worksheets
  • Chapter 08 - Building Basic Formulas
  • Chapter 09 - Math and Statistical Functions
  • Chapter 10 - Financial Functions
  • Chapter 11 - Manipulating Dates, Times, and Text
  • Chapter 12 - Lookup, Reference, and Information Functions
  • Chapter 13 - Advanced Formula Writing and Troubleshooting
  • Chapter 14 - Tables: List Management Made Easy
  • Chapter 15 - Grouping and Outlining Data
  • Chapter 16 - Templates
  • Chapter 17 - Creating Basic Charts
  • Chapter 18 - Formatting and Perfecting Charts
  • Chapter 19 - Inserting Graphics
  • Chapter 20 - Scenarios and Goal Seeking
  • Chapter 21 - Pivot Tables
  • Chapter 22 - Protecting Your Workbooks
  • Chapter 23 - Worksheet Collaboration
  • Chapter 24 - Querying Databases and XML Files
  • Chapter 25 - Exchanging Data with Other Programs
  • Chapter 26 - Connecting Worksheets to the Web
  • Chapter 27 - Automating Tasks with Macros
  • Chapter 28 - Programming Spreadsheets with VBA