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.

Label
Excel Formulas and Functions for Dummies
Title
Excel Formulas and Functions for Dummies
Creator
Language
eng
Member of
EBLCP
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
Instantiates
Publication
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 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
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
Publication
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 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
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 Locations

• Ellis Library
1020 Lowry Street, Columbia, MO, 65201, US
38.944491 -92.326012
• Engineering Library & Technology Commons
W2001 Lafferre Hall, Columbia, MO, 65211, US
38.946102 -92.330125