Excel Formulas and Functions For Dummies
(Adobe EPUB eBook, OverDrive Read)

Book Cover
Average Rating
5 star
 
(0)
4 star
 
(1)
3 star
 
(0)
2 star
 
(0)
1 star
 
(0)
Author:
Published:
Wiley 2013
Format:
Adobe EPUB eBook, OverDrive Read
Edition:
3
Status:
Available from OverDrive
Description

Learn to use Excel for practical, day-to-day calculations

Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.

  • Excel is a complex tool, making it a perfect subject for the straightforward, plain-English approach of this book
  • Formulas and functions are explained in classic For Dummies fashion, with examples of how to apply the 150 most commonly used functions in real-world situations
  • Discover how to use Excel to compare the cost of 15 and 30-year mortgages, decide whether to buy or lease a car, calculate the actual cost of credit card purchases, forecast college expenses, design a database for your own use, and much more
  • Serves as an excellent resource for all versions of Excel, including the latest version 2013

Excel Formulas and Functions For Dummies, 3rd Edition helps you put the power of Excel to work in your daily life.

The EPUB format of this title may not be compatible for use on all handheld devices.

Also in This Series
Formats
Adobe EPUB eBook
Works on all eReaders (except Kindles), desktop computers and mobile devices with with reading apps installed.
Need Help?
If you are having problem transferring a title to your device, please fill out this support form or visit the library so we can help you to use our eBooks and eAudio Books.
More Like This
Other Editions and Formats
More Details
Street Date:
02/08/2013
Language:
English
ISBN:
9781118460856
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation (style guide)

Ken Bluttman. (2013). Excel Formulas and Functions For Dummies. 3 Wiley.

Chicago / Turabian - Author Date Citation (style guide)

Ken Bluttman. 2013. Excel Formulas and Functions For Dummies. Wiley.

Chicago / Turabian - Humanities Citation (style guide)

Ken Bluttman, Excel Formulas and Functions For Dummies. Wiley, 2013.

MLA Citation (style guide)

Ken Bluttman. Excel Formulas and Functions For Dummies. 3 Wiley, 2013.

Note! Citation formats are based on standards as of July 2010. Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy.
Copy Details
LibraryOwnedAvailable
Shared Digital Collection11
Staff View
Grouped Work ID:
deaa73a4-c448-5976-34c0-fbf92b4fa241
Go To Grouped Work
Needs Update?:
No
Date Added:
Mar 06, 2015 19:51:40
Date Updated:
Nov 16, 2017 03:21:03
Last Metadata Check:
Feb 16, 2020 07:45:44
Last Metadata Change:
May 11, 2019 16:26:29
Last Availability Check:
Feb 16, 2020 07:45:45
Last Availability Change:
Feb 14, 2020 09:32:11
Last Grouped Work Modification Time:
Feb 19, 2020 22:45:45

OverDrive Product Record

id
cc9a24a9-3cbc-453c-8ed3-db91aa53b437
primaryCreator
    • name: Ken Bluttman
    • role: Author
starRating
3.4
title
Excel Formulas and Functions For Dummies
crossRefId
1237078
sortTitle
Excel Formulas and Functions For Dummies
images
    • cover300Wide:
        • type: image/jpeg
        • href: https://img1.od-cdn.com/ImageType-400/0128-1/CC9/A24/A9/{CC9A24A9-3CBC-453C-8ED3-DB91AA53B437}Img400.jpg
    • cover:
        • type: image/jpeg
        • href: https://img1.od-cdn.com/ImageType-100/0128-1/{CC9A24A9-3CBC-453C-8ED3-DB91AA53B437}Img100.jpg
    • thumbnail:
        • type: image/jpeg
        • href: https://img1.od-cdn.com/ImageType-200/0128-1/{CC9A24A9-3CBC-453C-8ED3-DB91AA53B437}Img200.jpg
    • cover150Wide:
        • type: image/jpeg
        • href: https://img1.od-cdn.com/ImageType-150/0128-1/CC9/A24/A9/{CC9A24A9-3CBC-453C-8ED3-DB91AA53B437}Img150.jpg
dateAdded
2015-03-06T15:06:00-05:00
contentDetails
      • account:
          • id: 1351
          • name: Nashville Public Library (TN)
      • type: text/html
      • href: https://link.overdrive.com/?websiteID=239&titleID=1237078
mediaType
eBook
formats
      • id: ebook-epub-adobe
      • identifiers:
            • value: 9781118460856
            • type: ISBN
      • name: Adobe EPUB eBook
      • id: ebook-kindle
      • identifiers:
            • value: B00BE5V356
            • type: ASIN
      • name: Kindle Book
      • id: ebook-overdrive
      • identifiers:
            • value: 9781118460856
            • type: ISBN
      • name: OverDrive Read

OverDrive MetaData

isPublicDomain
False
images
    • cover:
        • href: https://img1.od-cdn.com/ImageType-100/0128-1/{CC9A24A9-3CBC-453C-8ED3-DB91AA53B437}Img100.jpg
        • type: image/jpeg
    • thumbnail:
        • href: https://img1.od-cdn.com/ImageType-200/0128-1/{CC9A24A9-3CBC-453C-8ED3-DB91AA53B437}Img200.jpg
        • type: image/jpeg
    • cover150Wide:
        • href: https://img1.od-cdn.com/ImageType-150/0128-1/CC9/A24/A9/{CC9A24A9-3CBC-453C-8ED3-DB91AA53B437}Img150.jpg
        • type: image/jpeg
    • cover300Wide:
        • href: https://img1.od-cdn.com/ImageType-400/0128-1/CC9/A24/A9/{CC9A24A9-3CBC-453C-8ED3-DB91AA53B437}Img400.jpg
        • type: image/jpeg
isPublicPerformanceAllowed
False
formats
      • fileName: ExcelFormulasandFunctionsForDummies9781118460856
      • partCount: 0
      • fileSize: 14152033
      • identifiers:
            • type: ISBN
            • value: 9781118460856
      • rights:
            • type: CopyingTimesPerDays
            • value: 7
            • type: Printing
            • value: -1
            • type: Lending
            • value: 0
            • type: ReadAloud
            • value: 0
            • type: ExpirationRights
            • value: 0
      • name: Adobe EPUB eBook
      • id: ebook-epub-adobe
      • onSaleDate: 02/08/2013
      • samples:
            • source: From the book
            • formatType: ebook-overdrive
            • url: https://samples.overdrive.com/excel-formulas-and-cc9a24?.epub-sample.overdrive.com
      • fileName: ExcelFormulasandFunctionsForDummies9781118460856
      • partCount: 0
      • fileSize: 0
      • identifiers:
            • type: ISBN
            • value: 9781118460856
      • name: OverDrive Read
      • id: ebook-overdrive
      • onSaleDate: 02/12/2013
      • samples:
            • source: From the book
            • formatType: ebook-overdrive
            • url: https://samples.overdrive.com/excel-formulas-and-cc9a24?.epub-sample.overdrive.com
languages
      • code: en
      • name: English
creators
      • role: Author
      • fileAs: Bluttman, Ken
      • bioText:

        Ken Bluttman is a veteran software developer specializing in developing web applications and VB/VBA-based applications. He has written several books and articles on Office/VBA development, XML, and SQL Server, and was coauthor of two previous editions of Excel Formulas and Functions For Dummies.

      • name: Ken Bluttman
imprint
For Dummies
subjects
      • value: Computer Technology
      • value: Nonfiction
publishDate
2013-02-08T00:00:00-05:00
edition
3
publishDateText
02/08/2013
mediaType
eBook
shortDescription

Learn to use Excel for practical, day-to-day calculations

Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.

  • Excel is a complex tool, making it a perfect subject for the straightforward, plain-English approach of this book
  • Formulas and functions are explained in classic For Dummies fashion, with examples of how to apply the 150 most commonly used functions in real-world situations
  • Discover how to use Excel to compare the cost of 15 and 30-year mortgages, decide...
isOwnedByCollections
True
title
Excel Formulas and Functions For Dummies
fullDescription

Learn to use Excel for practical, day-to-day calculations

Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.

  • Excel is a complex tool, making it a perfect subject for the straightforward, plain-English approach of this book
  • Formulas and functions are explained in classic For Dummies fashion, with examples of how to apply the 150 most commonly used functions in real-world situations
  • Discover how to use Excel to compare the cost of 15 and 30-year mortgages, decide whether to buy or lease a car, calculate the actual cost of credit card purchases, forecast college expenses, design a database for your own use, and much more
  • Serves as an excellent resource for all versions of Excel, including the latest version 2013

Excel Formulas and Functions For Dummies, 3rd Edition helps you put the power of Excel to work in your daily life.

The EPUB format of this title may not be compatible for use on all handheld devices.

sortTitle
Excel Formulas and Functions For Dummies
crossRefId
1237078
popularity
173
publisher
Wiley
links
    • self:
        • href: https://api.overdrive.com/v1/collections/L1BFAIAAA2J/products/cc9a24a9-3cbc-453c-8ed3-db91aa53b437/metadata
        • type: application/vnd.overdrive.api+json
id
cc9a24a9-3cbc-453c-8ed3-db91aa53b437
starRating
3.7
tableOfContents

Introduction 1

Part I: Putting the Fun in Functions 5

Chapter 1: Tapping into Formula and Function Fundamentals 7

Chapter 2: Saving Time with Function Tools 39

Chapter 3: Saying "Array!" for Formulas and Functions 57

Chapter 4: Fixing Formula Boo-Boos 69

Part II: Doing the Math 87

Chapter 5: Calculating Loan Payments and Interest Rates 89

Chapter 6: Appreciating What You'll Get, Depreciating What You've Got 109

Chapter 7: Using Basic Math Functions 125

Chapter 8: Advancing Your Math 143

Part III: Solving with Statistics 165

Chapter 9: Throwing Statistics a Curve 167

Chapter 10: Using Signifi cance Tests 205

Chapter 11: Rolling the Dice on Predictions and Probability 215

Part IV: Working with Data 233

Chapter 12: Dressing Up for Date Functions 235

Chapter 13: Keeping Well-Timed Functions 255

Chapter 14: Using Lookup, Logical, and Reference Functions 265

Chapter 15: Digging Up the Facts 297

Chapter 16: Writing Home about Text Functions 311

Chapter 17: Playing Records with Database Functions 337

Part V: The Part of Tens 351

Chapter 18: Ten Tips for Working with Formulas 353

Chapter 19: Ten Functions You Really Should Know 365

Chapter 20: Some Really Cool Functions 371

Index 377