Microsoft Office Excel 2007 Formulas and Functions for Dummies.
Ken. Bluttman
Bok Engelsk 2007 · Electronic books.
| Omfang | 1 online resource (386 pages)
|
|---|---|
| Utgave | 1st ed.
|
| Opplysninger | Intro -- 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 Tools -- Getting Familiar with the Insert Function Dialog Box -- Finding 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 -- Chapter 5: Calculating Loan Payments and Interest Rates -- Understanding 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 -- Generating and Using Random Numbers.. - Ordering 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 -- Getting It Straight: Using SLOPE and INTERCEPT to Describe Linear Data -- What'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 -- Understanding How Excel Handles Time -- Formatting Time -- Keeping TIME -- Text to Time with TIMEVALUE -- Deconstructing Time with HOUR, MINUTE, and SECOND -- Finding the Time NOW -- Calculating Elapsed Time over Days -- Chapter 14: Using Lookup, Logical, and Reference Functions -- Testing on One Condition -- Choosing the Right Value -- Let's Be Logical -- Finding Where It Is -- Looking It Up -- Chapter 15: Digging Up the Facts -- Getting Informed with the CELL Function -- Getting Information about Excel and Your Computer System -- Finding What IS and What IS Not -- Getting to Know Your Type -- Part IV: Working with Data -- Chapter 16: Writing Home about Text Functions -- Breaking Apart Text.. - Putting Text Together with CONCATENATE -- Changing Text -- Comparing, Finding, and Measuring Text -- Chapter 17: Playing Records with Database Functions -- Putting Your Data into a Database Structure -- Working with Database Functions -- Fine-tuning Criteria with AND and OR -- Adding Only What Matters with DSUM -- Going for the Middle with DAVERAGE -- Counting Only What Matters with DCOUNT -- Finding Highest and Lowest with DMIN and DMAX -- Finding Duplicate Values with DGET -- Part V: The Part of Tens -- Chapter 18: Ten-Plus Tips for Working with Formulas -- Operator Precedence -- Display Formulas -- Fixing Formulas -- Use Absolute References -- Turn Calc On/Turn Calc Off -- Use Named Areas -- Use Formula Auditing -- Use Conditional Formatting -- Use the Conditional Sum Wizard -- Use the Lookup Wizard -- Create Your Own Functions -- Chapter 19: Ten-Plus Functions You Really Should Know -- SUM -- AVERAGE -- COUNT -- INT and ROUND -- IF -- NOW and TODAY -- HLOOKUP and VLOOKUP -- ISNUMBER -- MIN and MAX -- SUMIF and COUNTIF -- Index.. - Make Excel do the math and make sense of your data Use the Insert Function dialog box, array formulas and functions, and more Excel 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 statistical functions * Develop forecasts and track trends * Manipulate strings and work with database functions.
|
| Emner | |
| Sjanger | |
| Dewey | |
| ISBN | 9780470377390
|
| ISBN(galt) |
