LEADER 05233nam 22006494a 450 001 9910450803403321 005 20200520144314.0 010 $a0-470-37739-9 035 $a(CKB)1000000000413140 035 $a(EBL)333787 035 $a(OCoLC)228414042 035 $a(SSID)ssj0000202527 035 $a(PQKBManifestationID)11166845 035 $a(PQKBTitleCode)TC0000202527 035 $a(PQKBWorkID)10252784 035 $a(PQKB)11286936 035 $a(MiAaPQ)EBC333787 035 $a(JP-MeL)3000029959 035 $a(Au-PeEL)EBL333787 035 $a(CaPaEBR)ebr10226858 035 $a(CaONFJC)MIL123781 035 $a(EXLCZ)991000000000413140 100 $a20061130d2007 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMicrosoft Office Excel 2007 formulas & functions for dummies$b[electronic resource] /$fby Ken Bluttman and Peter G. Aitken 210 $aHoboken, N.J. $cWiley$dc2007 215 $a1 online resource (386 p.) 225 1 $aFor dummies 300 $aIncludes index. 311 $a0-470-04655-4 327 $aMicrosoft Office Excel 2007 Formulas & Functions for Dummies; About the Authors; Dedications; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; How to Use This Book; What You Can Safely Ignore; Foolish Assumptions; How This Book Is Organized; Icons Used In This Book; Where to Go from Here; Part I: Putting the Fun in Functions; Chapter 1: Tapping into Formula and Function Fundamentals; Working with Excel Fundamentals; Gaining the Upper Hand on Formulas; Using Functions in Formulas; Chapter 2: Saving Time with Function Tools 327 $aGetting Familiar with the Insert Function Dialog BoxFinding the Correct Function; Entering Functions Using the Insert Function Dialog Box; Directly Entering Formulas and Functions; 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; Auditing Formulas; Watching the Watch Window; Evaluating and Checking Errors; Making an Error Behave the Way You Want; Part II: Counting on Your Money 327 $aChapter 5: Calculating Loan Payments and Interest RatesUnderstanding How Excel Handles Money; Figuring Loan Calculations; Chapter 6: Appreciating What You'll Get, Depreciating What You Got; Looking into the Future; Depreciating the Finer Things in Life; Measuring Your Internals; Chapter 7: Using Basic Math Functions; Adding It All Together with the SUM Function; Rounding Out Your Knowledge; Leaving All Decimals Behind with INT; Leaving Some Decimals Behind with TRUNC; Looking for a Sign; Ignoring Signs; Chapter 8: Advancing Your Math; Using PI to Calculate Circumference and Diameter 327 $aGenerating and Using Random NumbersOrdering Items; Combining; Raising Numbers to New Heights; Multiplying Multiple Numbers; Using What Remains with the MOD Function; Summing Things Up; Chapter 9: Throwing Statistics a Curve; Stuck in the Middle with AVERAGE, MEDIAN, and MODE; Deviating from the Middle; Analyzing Data with Percentiles and Bins; Going for the Count; Chapter 10: Using Significance Tests; Testing to the T; Comparing Results to an Estimate; Part III: Doing the Math; Chapter 11: Rolling the Dice on Predictions and Probability; Modeling 327 $aGetting It Straight: Using SLOPE and INTERCEPT to Describe Linear DataWhat's in the Future: Using FORECAST, TREND, and GROWTH to Make Predictions; Using NORMDIST and POISSON to Determine Probabilities; Chapter 12: Dressing Up for Date Functions; Understanding How Excel Handles Dates; Formatting Dates; Making a Date with DATE; Breaking a Date with DAY, MONTH, and YEAR; Converting a Date from Text; Finding Out What TODAY Is; Determining the Day of the Week; Working with Workdays; Calculating Time between Two Dates with the DATEDIF Function; Chapter 13: Keeping Well-Timed Functions 327 $aUnderstanding How Excel Handles Time 330 $aMake Excel do the math and make sense of your dataUse the Insert Function dialog box, array formulas and functions, and moreExcel 2007 has more than 500 built-in functions. This book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing? Here's the fun and easy way!Discover how to* Create worksheets to track costs and revenue* Tell the difference among average, median, and mode* Work with 410 0$a--For dummies. 606 $aElectronic spreadsheets 606 $aBusiness$xComputer programs 608 $aElectronic books. 615 0$aElectronic spreadsheets. 615 0$aBusiness$xComputer programs. 676 $a005.54 700 $aBluttman$b Ken$0970801 701 $aAitken$b Peter G$042713 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910450803403321 996 $aMicrosoft Office Excel 2007 formulas & functions for dummies$92231768 997 $aUNINA