Cargando…
Excel Formulas and Functions for Dummies.
Put the power of Excel functions to work in your formulas There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dum...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Newark :
John Wiley & Sons, Incorporated,
2018.
|
| Edición: | 5th ed. |
| Colección: | --For dummies.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Intro; Title Page; Copyright Page; Table of Contents; Introduction; About This Book; Foolish Assumptions; How to Use This Book; Icons Used in This Book; Where to Go from Here; Part 1 Getting Started with Formulas and Functions; Chapter 1 Tapping Into Formula and Function Fundamentals; Working with Excel Fundamentals; Understanding workbooks and worksheets; Introducing the Formulas Tab; Working with rows, column, cells, ranges, and tables; Formatting your data; Getting help; Gaining the Upper Hand on Formulas; Entering your first formula; Understanding references.
- Copying formulas with the fill handleAssembling formulas the right way; Using Functions in Formulas; Looking at what goes into a function; Arguing with a function; Nesting functions; Chapter 2 Saving Time with Function Tools; Getting Familiar with the Insert Function Dialog Box; Finding the Correct Function; Entering Functions Using the Insert Function Dialog Box; Selecting a function that takes no arguments; Selecting a function that uses arguments; Entering cells, ranges, named areas, and tables as function arguments; Getting help in the Insert Function dialog box.
- Using the Function Arguments dialog box to edit functionsDirectly Entering Formulas and Functions; Entering formulas and functions in the Formula Bar; Entering formulas and functions directly in worksheet cells; Chapter 3 Saying "Array!" for Formulas and Functions; Discovering Arrays; Using Arrays in Formulas; Working with Functions That Return Arrays; Chapter 4 Fixing Formula Boo-Boos; Catching Errors As You Enter Them; Getting parentheses to match; Avoiding circular references; Mending broken links; Using the Formula Error Checker; Auditing Formulas; Watching the Watch Window.
- Evaluating and Checking ErrorsMaking an Error Behave the Way You Want; Part 2 Doing the Math; Chapter 5 Calculating Loan Payments and Interest Rates; Understanding How Excel Handles Money; Going with the cash flow; Formatting for currency; Choosing separators; Figuring Loan Calculations; Calculating the payment amount; Calculating interest payments; Calculating payments toward principal; Calculating the number of payments; Calculating the number of payments with PDURATION; Calculating the interest rate; Calculating the principal.
- Chapter 6 Appreciating What You'll Get, Depreciating What You've GotLooking into the Future; Depreciating the Finer Things in Life; Calculating straight-line depreciation; Creating an accelerated depreciation schedule; Creating an even faster accelerated depreciation schedule; Calculating a midyear depreciation schedule; Measuring Your Internals; Chapter 7 Using Basic Math Functions; Adding It All Together with the SUM Function; Rounding Out Your Knowledge; Just plain old rounding; Rounding in one direction; Leaving All Decimals Behind with INT; Leaving Some Decimals Behind with TRUNC.