05233nam 22006494a 450 991045080340332120200520144314.00-470-37739-9(CKB)1000000000413140(EBL)333787(OCoLC)228414042(SSID)ssj0000202527(PQKBManifestationID)11166845(PQKBTitleCode)TC0000202527(PQKBWorkID)10252784(PQKB)11286936(MiAaPQ)EBC333787(JP-MeL)3000029959(Au-PeEL)EBL333787(CaPaEBR)ebr10226858(CaONFJC)MIL123781(EXLCZ)99100000000041314020061130d2007 uy 0engur|n|---|||||txtccrMicrosoft Office Excel 2007 formulas & functions for dummies[electronic resource] /by Ken Bluttman and Peter G. AitkenHoboken, N.J. Wileyc20071 online resource (386 p.)For dummiesIncludes index.0-470-04655-4 Microsoft 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 ToolsGetting 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 MoneyChapter 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 DiameterGenerating 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; ModelingGetting 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 FunctionsUnderstanding How Excel Handles TimeMake 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 --For dummies.Electronic spreadsheetsBusinessComputer programsElectronic books.Electronic spreadsheets.BusinessComputer programs.005.54Bluttman Ken970801Aitken Peter G42713MiAaPQMiAaPQMiAaPQBOOK9910450803403321Microsoft Office Excel 2007 formulas & functions for dummies2231768UNINA