|
F1: Get the Most Out of Excel Formulas & Functions: The Ultimate Excel Formulas & Functions Help Guide
With more than 300 solutions to the time-consuming problem of combining Microsoft Excel functions into effective, problem-solving formulas, this handbook addresses questions that are regularly posted to Excel newsgroups—topics of the most interest to Excel users. Questions and answers provide a title, problem, solution, explanation, and screenshot,
and include many of the complex formulas and their several nested functions. Formulas for wages, shifts, time sheets, income taxes, financial calculations, amortization tables, counting, and handling errors are demonstrated, and the accompanying CD-ROM contains Excel workbook files that incorporate all the formulas presented in the book. Each question and answer includes a hyperlink that allows interested readers to visit the author's website to discuss problems and proposed solutions.
CONTENTS:
1 Working With Formulas
Inserting, Editing & Copying Formulas
Selecting, Displaying, Printing, & Pasting Formulas
Using Range Names in Formulas
Auditing Formulas
Protecting Formulas
2 Text
Entering Text
Combining Text, Date, & Numbers
Text Formatting - Troubleshooting
Subdividing Text
Replacing Characters
Searching a String
Rearranging & Sorting Text
Retrieving Cell Address, Row Number
3 Date & Time
Date
Time
Date & Time
Wages, Shifts, Time & Hours Worked
4 Lookup
Retrieving Data Using Text References
Retrieving Data Using One Criterion
Retrieving Data Using Two Criteria
Retrieving an Entire Row of Data
Retrieving Data From Two Different Lists
Complex Retrieval Problems
5 Logical & Errors
Reducing Complexity of IF Functions
Using OR & AND functions
Handling Errors
Handling Errors with the VLOOKUP Function
6 Counting
The Count Formulas
Counting Using One Criterion
Counting Using Two Criteria
Complex Counting Problems
7 Summing
Summing Techniques & Tips
Summing Values Based on Text, Text & Numbers, & Blank Cell Criteria
Summing Values Using Indirect Cell References
Summing Using One or More Criteria
Summing Last N Number of Values
8 List
Sorting, Reversing, & Retrieving Values
Creating a New List Using Criteria
Identifying Duplicate Values
Transposing a List
9 Miscellaneous Calculation & Math
Averaging Values
Averaging Using Criteria
Finding Minimum/ Maximum Values
Rounding Values
Ranking Values
Random Calculation
Miscellaneous Calculation
Converting Units
10 Income Tax & Financial
Calculating Income Tax
Financial Functions
Amortization Tables
11 Functions Help List
12 Index
|
