Excel Workbook For Dummies

Excel is the most sophisticated spreadsheet program available in the world of personal Ecomputing. As such, this program is much more than just an electronic version of an accountant’s familiar green sheet for crunching numbers. For millions of users the world over, Excel is also their number one forms designer, their interface to the corporate database, as well as their premier charting program.

Given Excel’s indisputable versatility, it should come as no surprise that mastering the basics of the program, not to mention its finer points, is no small undertaking. My experience, however, in teaching adults to use all manner of Excel’s capabilities has convinced me that this mastery is greatly accelerated with just a modicum of hands-on experience judiciously applied to rather simple butrealistic data-related problems.

As its name suggests, Excel Workbook For Dummiesis designed to give you the kind of hands-on experience with all the major aspects of the program you need to start using the program for business or home with a certain degree of confidence and efficiency. As you’d expect from this type of book, the workbook is primarily composed of questions and exercises that give you plenty of opportunities to experience the purpose and benefits of Excel’s many features.

It’s my hope that as a result of doing the exercises in this workbook, you’ll not only be in firm command of the basic skills necessary to work with confidence in the Excel spreadsheet but also have a good idea of the overall power of the program through experience with its features beyond the spreadsheet.

TABLE OF CONTENT:
Chapter 01 - Entering the Spreadsheet Data
Chapter 02 - Formatting the Spreadsheet
Chapter 03 - Printing Spreadsheet Reports
Chapter 04 - Modifying the Spreadsheet
Chapter 05 - Building Formulas
Chapter 06 - Copying and Correcting Formulas
Chapter 07 - Creating Date and Time Formulas
Chapter 08 - Financial Formulas and Functions
Chapter 09 - Using Math Functions
Chapter 10 - Using Statistical Functions
Chapter 11 - Using the Lookup Functions
Chapter 12 - Using the Logical Functions
Chapter 13 - Text Formulas and Functions
Chapter 14 - Charting Spreadsheet Data
Chapter 15 - Adding Graphics to the Spreadsheet
Chapter 16 - Building and Maintaining Data Lists
Chapter 17 - Protecting the Spreadsheet
Chapter 18 - Performing What-If Analysis
Chapter 19 - Generating Pivot Tables
Chapter 20 - Publishing Spreadsheets as Web Pages
Chapter 21 - Adding Hyperlinks to Spreadsheets
Chapter 22 - Using Macros
Chapter 23 - Using the Visual Basic Editor
Chapter 24 - Top Ten Tips for Using Excel like a Pro
Chapter 25 - Ten (More or Less) Shortcut Keys for Entering Data
Chapter 26 - Ten (More or Less) Shortcut Keys for Formatting the Worksheet
Chapter 27 - Ten (More or Less) Shortcut Keys for Editing Data
Chapter 28 - Ten (More or Less) Miscellaneous Shortcut Keys
Appendix A - About the CD
Appendix B - Table of Exercises

Download Here

Password: ganelon