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
MySQL Stored Procedure Programming
A Quick Tour
Loops
Why SQL Tuning Is So Important
Tuning Joins
Tuning Subqueries
Strategies for Information Technology Governance
Structures, Processes and Relational Mechanisms for IT Governance
Linking the IT Balanced Scorecard to the Business Objectives at a Major Canadian Financial Group
Measuring and Managing E-Business Initiatives Through the Balanced Scorecard
Measuring ROI in E-Commerce Applications: Analysis to Action
Managing IT Functions
Java How to Program (6th Edition) (How to Program (Deitel))
Wrap-Up
Stack Class of Package java.util
Wrap-Up
Summary
Multitier Applications: Using JDBC from a Servlet
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
The continuing evolution of SOA (standards organizations and contributing vendors)
Service-orientation and the enterprise
The agile strategy
Deriving business services
Service design guidelines
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 5. Driven to a Better User Interface
Hack 32. Locate a Phone Number
Hacks 5161: Introduction
Hack 56. Pin Your Own Maps to Google Maps with TPhoto
Hack 65. Add More Imagery with a WMS Interface
Python Programming for the Absolute Beginner, 3rd Edition
Standard Streams
Visitor: Walking Trees Generically
Other Client-Side Tools
HTMLgen: Web Pages from Objects
Regular Expression Matching
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