Excel Workbook For Dummies

  • 7h 32m
  • Greg Harvey
  • John Wiley & Sons (US)
  • 2006

Start using Excel spreadsheets, formulas, and charts - practice exercises make it easy

You don't have to be overwhelmed by Excel - this workbook helps you get the hang of the most popular spreadsheet program by doing!

See how to

  • Set up, format, and edit basic spreadsheets
  • Create a variety of formulas for finance, date and time, math, and more
  • Calculate return on investments or loan amortization
  • Master data analysis with pivot tables
  • Turn spreadsheets into Web pages and master hyperlinks

About the Author

Greg Harvey has authored tons of computer books, the most recent being Excel Timesaving Techniques For Dummies and Roxio Easy Media Creator For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.

His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.

Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

In this Book

  • Excel Workbook For Dummies
  • Introduction
  • Entering the Spreadsheet Data
  • Formatting the Spreadsheet
  • Printing Spreadsheet Reports
  • Modifying the Spreadsheet
  • Building Formulas
  • Copying and Correcting Formulas
  • Creating Date and Time Formulas
  • Financial Formulas and Functions
  • Using Math Functions
  • Using Statistical Functions
  • Using the Lookup Functions
  • Using the Logical Functions
  • Text Formulas and Functions
  • Charting Spreadsheet Data
  • Adding Graphics to the Spreadsheet
  • Building and Maintaining Data Lists
  • Protecting the Spreadsheet
  • Performing What-If Analysis
  • Generating Pivot Tables
  • Publishing Spreadsheets as Web Pages
  • Adding Hyperlinks to Spreadsheets
  • Using Macros
  • Using the Visual Basic Editor
  • Top Ten Tips for Using Excel like a Pro
  • Ten (More or Less) Shortcut Keys for Entering Data
  • Ten (More or Less) Shortcut Keys for Formatting the Worksheet
  • Ten (More or Less) Shortcut Keys for Editing Data
  • Ten (More or Less) Miscellaneous Shortcut Keys