Description |
xxix, 538 pages : illustrations ; 23 cm + 1 CD-ROM (4 3/4 in.) |
Note |
Includes index. |
Contents |
Formulas in Excel -- Logical functions -- Text functions -- Date and time functions -- Basic statistical functions -- Mathematical functions -- Basic financial functions -- Database functions -- Lookup and reference functions -- Conditional formatting with formulas -- Working with dynamic array formulas -- Special solutions with formulas -- User-defined functions -- Examples -- Other features -- Data analytics using Excel -- Shortcut keys. |
Summary |
Demonstrates the secrets of Excel functions through the use of practical and useful examples in a quick reference format. Topics include logical, text, date and time, basic statistical, mathematical, financial, database, and lookup and reference functions as well as conditional formatting with formulas, array formulas, and user-defined functions. This book's extensive examples make it an excellent tutorial for all Excel users who want to understand, create, and apply formulas. Intermediate and advanced users will find Microsoft Excel Functions & Formulas an excellent reference to many of the program's advanced formulas and functions. |
Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Office.
|
|
Electronic spreadsheets -- Computer programs.
|
|
Business -- Computer programs.
|
Added Author |
Held, Bernd, author.
|
|
Richardson, Theodor, author.
|
ISBN |
9781683928539 paperback |
|
1683928539 paperback |
|