The Resource Excel Formulas and Functions for Dummies
Excel Formulas and Functions for Dummies
Resource Information
The item Excel Formulas and Functions for Dummies represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in University of Missouri Libraries.This item is available to borrow from 2 library branches.
Resource Information
The item Excel Formulas and Functions for Dummies represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in University of Missouri Libraries.
This item is available to borrow from 2 library branches.
 Language
 eng
 Edition
 5th ed.
 Extent
 1 online resource (403 pages)
 Note
 Looking for a Sign
 Contents

 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 BooBoos; 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 straightline 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
 Isbn
 9781119518273
 Label
 Excel Formulas and Functions for Dummies
 Title
 Excel Formulas and Functions for Dummies
 Language
 eng
 Cataloging source
 EBLCP
 http://library.link/vocab/creatorName
 Bluttman, Ken
 Dewey number
 005.54
 Index
 no index present
 Literary form
 non fiction
 Nature of contents
 dictionaries
 Series statement
 For dummies
 Label
 Excel Formulas and Functions for Dummies
 Note
 Looking for a Sign
 Carrier category
 online resource
 Carrier category code

 cr
 Carrier MARC source
 rdacarrier
 Content category
 text
 Content type code

 txt
 Content type MARC source
 rdacontent
 Contents

 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 BooBoos; 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 straightline 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
 Control code
 1064935469
 Dimensions
 unknown
 Edition
 5th ed.
 Extent
 1 online resource (403 pages)
 Form of item
 online
 Isbn
 9781119518273
 Media category
 computer
 Media MARC source
 rdamedia
 Media type code

 c
 Specific material designation
 remote
 System control number
 (OCoLC)1064935469
 Label
 Excel Formulas and Functions for Dummies
 Note
 Looking for a Sign
 Carrier category
 online resource
 Carrier category code

 cr
 Carrier MARC source
 rdacarrier
 Content category
 text
 Content type code

 txt
 Content type MARC source
 rdacontent
 Contents

 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 BooBoos; 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 straightline 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
 Control code
 1064935469
 Dimensions
 unknown
 Edition
 5th ed.
 Extent
 1 online resource (403 pages)
 Form of item
 online
 Isbn
 9781119518273
 Media category
 computer
 Media MARC source
 rdamedia
 Media type code

 c
 Specific material designation
 remote
 System control number
 (OCoLC)1064935469
Library Links
Embed
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa faexternallinksquare fafw"></i> Data from <span resource="http://link.library.missouri.edu/portal/ExcelFormulasandFunctionsforDummies/MnE_pDTgdvY/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.library.missouri.edu/portal/ExcelFormulasandFunctionsforDummies/MnE_pDTgdvY/">Excel Formulas and Functions for Dummies</a></span>  <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.library.missouri.edu/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.library.missouri.edu/">University of Missouri Libraries</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data  Experimental
Data Citation of the Item Excel Formulas and Functions for Dummies
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa faexternallinksquare fafw"></i> Data from <span resource="http://link.library.missouri.edu/portal/ExcelFormulasandFunctionsforDummies/MnE_pDTgdvY/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.library.missouri.edu/portal/ExcelFormulasandFunctionsforDummies/MnE_pDTgdvY/">Excel Formulas and Functions for Dummies</a></span>  <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.library.missouri.edu/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.library.missouri.edu/">University of Missouri Libraries</a></span></span></span></span></div>