Flylib.com
List of Sidebars
Previous page
Table of content
Next page
Chapter 1: Excel in a Nutshell
How Big Is a Worksheet?
What's New in Excel 2007?
Data-Entry Tips
Chapter 2: Basic Facts about Formulas
Using the Formula Bar as a Calculator
Don't Hard-Code Values
A1 versus R1C1 Notation
When to Use AutoFill Rather Than Formulas
Chapter 3: Working with Names
Rules for Naming Names
Hidden Names
Naming Objects
Chapter 4: Introducing Worksheet Functions
Accommodating Former Lotus 1-2-3 Users
Let Excel Insert Functions for You
Volatile Functions
Chapter 5: Manipulating Text
When a Number Isn't Treated as a Number
How to Find Special Characters
Transforming Data with Formulas
Splitting Text Strings without Using Formulas
Chapter 6: Working with Dates and Times
Choose Your Date System: 1900 or 1904
Searching for Dates
Where's the DATEDIF Function?
Calculating Easter
Chapter 7: Counting and Summing Techniques
Getting a Quick Count or Sum
About This Chapter's Examples
Creating Bins for a Frequency Distribution
Is the Analysis ToolPak Installed?
Let a Wizard Create Your Formula
Chapter 8: Using Lookup Functions
When a Blank Is Not a Zero
Chapter 9: Tables and Worksheet Databases
Designing a Worksheet Database or Table
Table Limitations
Excel Remembers
Using a Data Form
About the SUBTOTAL Function
Filling in the Gaps
Chapter 10: Miscellaneous Calculations
Need to Convert Other Units?
Chapter 11: Borrowing and Investing Formulas
Financial Function Arguments
Rounding of Financial Formulas
Chapter 14: Introducing Arrays
Array Formulas: The Downside
Worksheet Functions That Return an Array
TRUE and FALSE in Array Formulas
Chapter 15: Performing Magic with Array Formulas
About the Examples in This Chapter
Illogical Behavior from Logical Functions
Using Excel's Formula Evaluator
Chapter 16: Intentional Circular References
About Circular References
More about Circular References
Chapter 17: Charting Techniques
Chart-Making Tips
Handling Missing Data
Chapter 18: Pivot Tables
Pivot Table Terminology
Pivot Table Calculations
Copying a Pivot Table
Chapter 19: Conditional Formatting and Data Validation
Excel 2007 Improvements
Using Custom Worksheet Functions in Data Validation Formulas
Chapter 20: Creating Megaformulas
Copying Text from a Formula
Chapter 21: Tools and Methods for Debugging Formulas
Research on Spreadsheet Errors
Using Formula AutoCorrect
Tracing Error Values
Pay Attention to the Colors
Third-Party Auditing Tools
Chapter 23: Function Procedure Basics
What Custom Worksheet Functions Can't Do
Using the Immediate Window
A Few Words about Passwords
Chapter 24: VBA Programming Concepts
Forcing Yourself to Declare All Variables
Chapter 25: VBA Custom Function Examples
Using the Functions in This Chapter
Understanding Object Parents
Worksheet Function Data Types
Controlling Function Recalculation
Appendix B: Using Custom Number Formats
Pre-formatting Cells
Where Did Those Number Formats Come From?
Testing Custom Number Formats
Formatting Numbers Using the TEXT Function
Displaying a Number Format String in a Cell
Appendix C: Additional Excel Resources
A Dozen Tips for Posting to a Newsgroup
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
Qshell for iSeries
Introduction to Qshell
Input and Output
Accessing OS/400-Specific Objects
The Perl Utility
C and C++ Development Tools
FileMaker Pro 8: The Missing Manual
Creating a Relational Database
Connecting Databases
Handling Errors
Scripts and Security
Appendix B. FileMaker Error Codes
The Complete Cisco VPN Configuration Guide
VPN Definition
Packet Authentication
ISAKMP/IKE Phase 1 Preparation
3002 Hardware Client
Router Remote Access Connections
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Individual change
Leading change
Restructuring
Mergers and acquisitions
IT-based process change
An Introduction to Design Patterns in C++ with Qt 4
Encapsulation
Standard Expression Conversions
Valid Pointer Operations
Inheritance in Detail
Appendix A. C++ Reserved Keywords
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
Overview of Captology
Computers as Persuasive Tools
Computers as Persuasive Media Simulation
Credibility and the World Wide Web
The Ethics of Persuasive Technology
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