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) |
MARC
| LEADER | 00000cam a2200000Mu 4500 | ||
|---|---|---|---|
| 001 | OR_on1064935469 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr |n|---||||| | ||
| 008 | 181117s2018 nju o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d LVT |d YDX |d OCLCQ |d CZL |d OCLCF |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 1064275769 | ||
| 020 | |a 9781119518273 | ||
| 020 | |a 111951827X | ||
| 020 | |z 9781119518259 | ||
| 020 | |z 1119518253 | ||
| 029 | 1 | |a AU@ |b 000066170250 | |
| 035 | |a (OCoLC)1064935469 |z (OCoLC)1064275769 | ||
| 050 | 4 | |a HF5548.4 |b .B588 E93 2019 | |
| 082 | 0 | 4 | |a 005.54 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Bluttman, Ken. | |
| 245 | 1 | 0 | |a Excel Formulas and Functions for Dummies. |
| 250 | |a 5th ed. | ||
| 260 | |a Newark : |b John Wiley & Sons, Incorporated, |c 2018. | ||
| 300 | |a 1 online resource (403 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a --For dummies | |
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 500 | |a Looking for a Sign. | ||
| 520 | |a 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 Dummies offers thorough but easy-to-read coverage of powerful Excel functions. With this book, you'll learn to apply the power of Excel functions and formulas to make your work and other tasks easier. Compare 15-year vs. 30-year mortgage terms, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit card purchases, or forecast college expenses and savings. All of this and more is possible when you master functions and formulas in Excel. Although it covers the latest software version, Excel 2019, the techniques and functions described in this book can be used on any version of Excel. Step-by-step instruction on Excel's 150 most useful functions Each function is illustrated by helpful, real-world examples 85 specialized functions are described in abbreviated form Includes Excel's must-know functions This book is a must-read for beginning to intermediate Excel users who want to find out how to use Excel's powerful built-in functions. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 650 | 0 | |a Electronic spreadsheets |x Computer programs. | |
| 650 | 0 | |a Business |x Computer programs. | |
| 650 | 6 | |a Tableurs |x Logiciels. | |
| 650 | 7 | |a Business |x Computer programs |2 fast | |
| 650 | 7 | |a Electronic spreadsheets |x Computer programs |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Bluttman, Ken. |t Excel Formulas and Functions for Dummies. |d Newark : John Wiley & Sons, Incorporated, ©2018 |z 9781119518259 |
| 830 | 0 | |a --For dummies. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781119518259/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a YBP Library Services |b YANK |n 15825978 | ||
| 994 | |a 92 |b IZTAP | ||