F1 Get the Most Out of Excel Formulas and Functions
Limelight Media
978-0-9746368-5-6 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
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.
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
| Erscheint lt. Verlag | 1.1.2006 |
|---|---|
| Sprache | englisch |
| Maße | 215 x 274 mm |
| Themenwelt | Informatik ► Office Programme ► Excel |
| ISBN-10 | 0-9746368-5-1 / 0974636851 |
| ISBN-13 | 978-0-9746368-5-6 / 9780974636856 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
