List of Tables

Chapter 2: Basic Facts about Formulas

Table 2-1: EXCEL-SUPPORTED OPERATORS

Table 2-2: REFERENCE OPERATORS

Table 2-3: OPERATOR PRECEDENCE IN EXCEL FORMULAS

Table 2-4: EXCEL ERROR VALUES

Chapter 6: Working with Dates and Times

Table 6-1: DATE ENTRY FORMATS RECOGNIZED BY EXCEL

Table 6-2: TIMES OF DAY AND THEIR CORRESPONDING SERIAL NUMBERS

Table 6-3: TIME ENTRY FORMATS RECOGNIZED BY EXCEL

Table 6-4: HOW TWO-DIGIT YEARS ARE INTERPRETED IN VARIOUS EXCEL VERSIONS

Table 6-5: DATE-RELATED FUNCTIONS

Table 6-6: TIME-RELATED FUNCTIONS

Chapter 7: Counting and Summing Techniques

Table 7-1: EXCEL'S COUNTING AND SUMMING FUNCTIONS

Table 7-2: EXAMPLES OF FORMULAS USING THE COUNTIF FUNCTION

Chapter 8: Using Lookup Functions

Table 8-1: FUNCTIONS USED IN LOOKUP FORMULAS

Table 8-2: FORMULAS FOR A LOOKUP USING LINEAR INTERPOLATION

Chapter 9: Tables and Worksheet Databases

Table 9-1: TABLE ROW REFERENCES

Table 9-2: COMPARISON OPERATORS

Table 9-3: EXAMPLES OF TEXT CRITERIA

Table 9-4: EXCEL'S DATABASE WORKSHEET FUNCTIONS

Chapter 10: Miscellaneous Calculations

Table 10-1: EXCEL ROUNDING FUNCTIONS

Table 10-2: RESULTS USING THE EVEN AND ODD FUNCTIONS

Chapter 12: Discounting and Depreciation Formulas

Table 12-1: EXCEL DEPRECIATION FUNCTIONS

Chapter 17: Charting Techniques

Table 17-1: FORMULAS USED TO CREATE A BOX PLOT

Table 17-2: FORMULAS USED TO GENERATE A CLOCK CHART

Chapter 20: Creating Megaformulas

Table 20-1: FORMULAS USED TO CALCULATE TOTAL INTEREST

Table 20-2: INTERMEDIATE FORMULAS IN THE FIRST ROW OF SHEET1 IN Figure 20-3

Table 20-3: COMPARING INTERMEDIATE FORMULAS AND MEGAFORMULA

Table 20-4: INFORMATION ABOUT FOUR MAJOR CREDIT CARDS

Chapter 21: Tools and Methods for Debugging Formulas

Table 21-1: OPERATOR PRECEDENCE IN EXCEL FORMULAS

Chapter 23: Function Procedure Basics

Table 23-1: FUNCTION CATEGORIES

Chapter 24: VBA Programming Concepts

Table 24-1: VBA DATA TYPES

Table 24-2: VBA LOGICAL OPERATORS

Chapter 25: VBA Custom Function Examples

Table 25-1: COMMISSION RATES FOR MONTHLY SALES

Appendix A: Excel Function Reference

Table A-1: CUBE CATEGORY FUNCTIONS

Table A-2: DATABASE CATEGORY FUNCTIONS

Table A-3: DATE & TIME CATEGORY FUNCTIONS

Table A-4: ENGINEERING CATEGORY FUNCTIONS

Table A-5: FINANCIAL CATEGORY FUNCTIONS

Table A-6: INFORMATION CATEGORY FUNCTIONS

Table A-7: LOGICAL CATEGORY FUNCTIONS

Table A-8: LOOKUP & REFERENCE CATEGORY FUNCTIONS

Table A-9: MATH & TRIG CATEGORY FUNCTIONS

Table A-10: STATISTICAL CATEGORY FUNCTIONS

Table A-11: TEXT CATEGORY FUNCTIONS

Appendix B: Using Custom Number Formats

Table B-1: NUMBER-FORMATTING BUTTONS ON THE RIBBON

Table B-2: NUMBER-FORMATTING KEYBOARD SHORTCUTS

Table B-3: CODES USED TO CREATE CUSTOM NUMBER FORMATS

Table B-4: CODES USED IN CREATING CUSTOM FORMATS FOR DATES AND TIMES

Table B-5: EXAMPLES OF DISPLAYING VALUES IN THOUSANDS

Table B-6: EXAMPLES OF DISPLAYING VALUES IN HUNDREDS

Table B-7: EXAMPLES OF DISPLAYING VALUES IN MILLIONS

Table B-8: EXAMPLES OF DISPLAYING A VALUE WITH EXTRA ZEROS

Table B-9: USEFUL CUSTOM DATE AND TIME FORMATS

Appendix C: Additional Excel Resources

Table C-1: POPULAR EXCEL-RELATED NEWSGROUPS