Excel Workbook

How This Book Is Organized

This workbook is organized into eight parts, each of which contains two or more related chapters. Each of the chapters follows a similar pattern of introductory text fol¬lowed by exercises. In some of the chapters, you’ll also encounter question and answer sections that are designed to stimulate your thinking regarding the features you’re about to practice in the subsequent exercises. Note that although the exercises within any given chapter do build on one another, you’re certainly not expected to complete them in strict chapter order.

Part I: Creating Spreadsheets

This part contains the most exercises of any in the workbook. It is made up of four chapters designed to give you practice in all the spreadsheet basics, all the way from starting Excel to editing a completed spreadsheet:

* Chapter 1 enables you to practice creating a new spreadsheet.
* Chapter 2 runs you through formatting spreadsheet data.
* Chapter 3 gives you training in all aspects of printing the completed spreadsheet.
* Chapter 4 gives you plenty of experience with making modifications to the com¬pleted spreadsheet.

Part II: Using Formulas and Functions

This part gives you all the practice you need with creating and using formulas in the spreadsheet. Chapter 5 introduces you to formula-making just as Chapter 6 introduces you to the all-important topic of formula copying.

Because of the importance of Excel’s built-in functions in formula building, the remaining seven chapters in this part concentrate on building formulas using a particular category of functions:

* Chapter 7 gets you up and running on date and time formulas.
* Chapter 8 trains you in the use of financial formulas.
* Chapter 9 gives you practice creating formulas using Excel’s Math functions.
* Chapter 10 concentrates on exercises in creating formulas using Statistical functions.
* Chapter 11 introduces you to the creation of formulas using Lookup functions.
* Chapter 12 runs you through the creation of formulas using the Logical func¬tions, the performance of which depends upon prevailing conditions in the spreadsheet.
* Chapter 13 introduces you to the creation of text formulas that manipulate and change text entries in the spreadsheet.

Part III: Working with Graphics

This part takes you into the graphical aspects of Excel, the most important of which is its rich and versatile charting capabilities covered in Chapter 14. In addition to charts, in Chapter 15 you get practice in working with other types of graphics in the spread¬sheet, both those that you generate with the program’s own drawing tools and those that you import from other sources such as clip art and digital photos.

Part IV: Managing and Securing Data

This part is concerned with the management and security of the vast amounts of data that you accumulate in your worksheets. Chapter 16 gives you practice in creating,eels comfortable and fits your learning needs.

maintaining, sorting, and querying database tables and data lists in the worksheet. Chapter 17, on the other hand, gives you practice using Excel’s various methods for protecting your data and worksheets from illicit viewing and unwanted changes.

Part V: Doing Data Analysis

This part takes you to the next step of using the Excel spreadsheet by introducing you to two different kinds of data analysis. Chapter 18 gives you practice in doing various types of what-if analysis that enable you to look at different potential outcomes in the spreadsheet. Chapter 19 concentrates on training you in the use of pivot tables, a dynamic type of data table that you can use to summarize vast amounts of data.

Part VI: Excel and the Web

This part gives you experience with Excel’s Web capabilities in two forms. Chapter 20 gives you experience converting Excel spreadsheets to Web pages, both in static and dynamic formats. Chapter 21 trains you in the use of hyperlinks in spreadsheets that connect you to different sheets in the same workbook, different documents on the same computer, as well as to different pages and e-mail addresses on the World Wide Web.

Part VII: Macros and Visual Basic for Applications

This part introduces you to the topic of creating and using macros to both streamline and customize your work in Excel. Chapter 22 introduces you to recording your actions as Excel macros and then playing them back in the worksheet. Chapter 23 gives you practice using Excel’s Visual Basic Editor to edit macros and extend macros you’ve recorded as well as to create your own user-defined functions.

Part VIII: The Part of Tens

This part gives you tips for using Excel on your own after you complete the exercises in this workbook. Chapter 24 is full of tips on using some of the many features you’ve practiced using in the workbook like a professional. Chapters 25 through 28 are full of various and sundry keystroke shortcuts designed to save you keyboard enthusiasts out there all sorts of time as you work in Excel.
Read comments To Download