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
The Exit Status and Decision-Making
Input and Output
Commands
Functions
Certified Ethical Hacker Exam Prep
Picking the Right Platform
Key Terms
History of Cryptography
Web Application Vulnerabilities
Contacting Que Certification
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Combos and Lists
Tables
Trees
Scales, Sliders, and Progress Bars
Drag and Drop and the Clipboard
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
The Auxiliary (AUX) Port
Modern IOS QoS Tools
Dial-on-Demand Routing
Network Address Translation (NAT)
Tunnels
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
What Is SQL*Plus?
Unions
Using SQL*Plus Timers
Windows GUI SQL*Plus
Section A.2. Commands You Can Issue Within SQL*Plus
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Finding Shapes for Diagrams
Changing the Layout of Connected Shapes
Key Points
Storing Information with Network Shapes
Choose the Right Book for You
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