Flylib.com
List of Tables
Previous page
Table of content
Next page
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
Previous page
Table of content
Next page
Excel 2007 Formulas (Mr. Spreadsheets Bookshelf)
ISBN: 0470044020
EAN: 2147483647
Year: 2007
Pages: 212
Authors:
John Walkenbach
BUY ON AMAZON
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Planning for Risk Management
Quantifying and Analyzing Activity Risks
Monitoring and Controlling Risky Projects
Closing Projects
Appendix A Selected Detail From the PERIL Database
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Auditing the Kanban
Appendix A MRP vs. Kanban
Appendix C Two-Bin Kanban Systems
Appendix G Intra-Cell Kanban
Appendix J Abbreviations and Acronyms
A+ Fast Pass
Domain 3 Preventive Maintenance
Domain 5 Printers
Domain 1 Operating System Fundamentals
Domain 2 Installation, Configuration, and Upgrading
Domain 4 Networks
A Practitioners Guide to Software Test Design
Case Studies
Domain Analysis Testing
Data Flow Testing
Defect Taxonomies
When to Stop Testing
C++ How to Program (5th Edition)
Wrap-Up
Case Study: Class GradeBook Using an Array to Store Grades
Exercises
Appendix K. XHTML Special Characters
Summary
An Introduction to Design Patterns in C++ with Qt 4
C++ Simple Types
Review Questions
Copy Constructors and Assignment Operators
Example Project: Using QApplication and QLabel
Polymorphism and virtual Destructors
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies