The Resource Microsoft Office Excel 2007 formulas & functions for dummies, by Ken Bluttman and Peter G. Aitken, (electronic resource)

Microsoft Office Excel 2007 formulas & functions for dummies, by Ken Bluttman and Peter G. Aitken, (electronic resource)

Label
Microsoft Office Excel 2007 formulas & functions for dummies
Title
Microsoft Office Excel 2007 formulas & functions for dummies
Statement of responsibility
by Ken Bluttman and Peter G. Aitken
Creator
Contributor
Subject
Genre
Language
  • eng
  • eng
Summary
Make 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
Member of
Cataloging source
MiAaPQ
http://library.link/vocab/creatorName
Bluttman, Ken
Dewey number
005.54
Illustrations
illustrations
Index
index present
Language note
English
LC call number
HF5548.4.M523
LC item number
B58372 2007
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
Aitken, Peter G
Series statement
For dummies
http://library.link/vocab/subjectName
  • Electronic spreadsheets
  • Business
Label
Microsoft Office Excel 2007 formulas & functions for dummies, by Ken Bluttman and Peter G. Aitken, (electronic resource)
Instantiates
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • 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 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
  • Chapter 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
  • Generating 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
  • Getting 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
  • Understanding How Excel Handles Time
Dimensions
unknown
Extent
1 online resource (386 p.)
Form of item
online
Isbn
9780470377390
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000413140
  • (EBL)333787
  • (OCoLC)228414042
  • (SSID)ssj0000202527
  • (PQKBManifestationID)11166845
  • (PQKBTitleCode)TC0000202527
  • (PQKBWorkID)10252784
  • (PQKB)11286936
  • (MiAaPQ)EBC333787
  • (EXLCZ)991000000000413140
Label
Microsoft Office Excel 2007 formulas & functions for dummies, by Ken Bluttman and Peter G. Aitken, (electronic resource)
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • 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 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
  • Chapter 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
  • Generating 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
  • Getting 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
  • Understanding How Excel Handles Time
Dimensions
unknown
Extent
1 online resource (386 p.)
Form of item
online
Isbn
9780470377390
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000413140
  • (EBL)333787
  • (OCoLC)228414042
  • (SSID)ssj0000202527
  • (PQKBManifestationID)11166845
  • (PQKBTitleCode)TC0000202527
  • (PQKBWorkID)10252784
  • (PQKB)11286936
  • (MiAaPQ)EBC333787
  • (EXLCZ)991000000000413140

Library Locations

  • Albert D. Cohen Management LibraryBorrow it
    181 Freedman Crescent, Winnipeg, MB, R3T 5V4, CA
    49.807878 -97.129961
  • Architecture/Fine Arts LibraryBorrow it
    84 Curry Place, Winnipeg, MB, CA
    49.807716 -97.136226
  • Archives and Special CollectionsBorrow it
    25 Chancellors Circle (Elizabeth Dafoe Library), Room 330, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Bibliothèque Alfred-Monnin (Université de Saint-Boniface)Borrow it
    200, avenue de la Cathédrale, Local 2110, Winnipeg, MB, R2H 0H7, CA
    49.888861 -97.119735
  • Bill Larson Library (Grace Hospital)Borrow it
    300 Booth Drive, G-227, Winnipeg, MB, R3J 3M7, CA
    49.882400 -97.276436
  • Carolyn Sifton - Helene Fuld Library (St. Boniface General Hospital)Borrow it
    409 Tache Avenue, Winnipeg, MB, R2H 2A6, CA
    49.883388 -97.126050
  • Concordia Hospital LibraryBorrow it
    1095 Concordia Avenue, Winnipeg, MB, R2K 3S8, CA
    49.913252 -97.064683
  • Donald W. Craik Engineering LibraryBorrow it
    75B Chancellors Circle (Engineering Building E3), Room 361, Winnipeg, MB, R3T 2N2, CA
    49.809053 -97.133292
  • E.K. Williams Law LibraryBorrow it
    224 Dysart Road, Winnipeg, MB, R3T 5V4, CA
    49.811829 -97.131017
  • Eckhardt-Gramatté Music LibraryBorrow it
    136 Dafoe Road (Taché Arts Complex), Room 257, Winnipeg, MB, R3T 2N2, CA
    49.807964 -97.132222
  • Elizabeth Dafoe LibraryBorrow it
    25 Chancellors Circle, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Fr. H. Drake Library (St. Paul's College)Borrow it
    70 Dysart Road, Winnipeg, MB, R3T 2M6, CA
    49.810605 -97.138184
  • J.W. Crane Memorial Library (Deer Lodge Centre)Borrow it
    2109 Portage Avenue, Winnipeg, MB, R3J 0L3, CA
    49.878000 -97.235520
  • Libraries Annex (not open to the public; please see web page for details)Borrow it
    25 Chancellors Circle (in the Elizabeth Dafoe Library), Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Neil John Maclean Health Sciences LibraryBorrow it
    727 McDermot Avenue (Brodie Centre), 200 Level, Winnipeg, MB, R3E 3P5, CA
    49.903563 -97.160554
  • Sciences and Technology LibraryBorrow it
    186 Dysart Road, Winnipeg, MB, R3T 2M8, CA
    49.811526 -97.133257
  • Seven Oaks General Hospital LibraryBorrow it
    2300 McPhillips Street, Winnipeg, MB, R2V 3M3, CA
    49.955177 -97.148865
  • Sister St. Odilon Library (Misericordia Health Centre)Borrow it
    99 Cornish Avenue, Winnipeg, MB, R3C 1A2, CA
    49.879592 -97.160425
  • St. John's College LibraryBorrow it
    92 Dysart Road, Winnipeg, MB, R3T 2M5, CA
    49.811242 -97.137156
  • Victoria General Hospital LibraryBorrow it
    2340 Pembina Highway, Winnipeg, MB, R3T 2E8, CA
    49.806755 -97.152739
  • William R Newman Library (Agriculture)Borrow it
    66 Dafoe Road, Winnipeg, MB, R3T 2R3, CA
    49.806936 -97.135525
Processing Feedback ...