Summer Reading B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Lists | July 16, 2015

    Annie Liontas: IMG "You Want Me to Smell My Fingers?": Five Unforgettable Greek Idioms



    The word "idiom" originates in the Greek word ídios ("one's own") and means "special feature" or "special phrasing." Idioms are peculiar because,... Continue »
    1. $18.20 Sale Hardcover add to wish list

      Let Me Explain You

      Annie Liontas 9781476789088

    spacer
Qualifying orders ship free.
$24.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
4 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets
3 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

More copies of this ISBN

Microsoft Office Excel 2007 Formulas & Functions for Dummies (For Dummies)

by

Microsoft Office Excel 2007 Formulas & Functions for Dummies (For Dummies) Cover

 

Synopses & Reviews

Publisher Comments:

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

Synopsis:

* Examples of Excel formulas and functions show how to compare 15year vs. 30year mortgage terms, choose between leasing or buying a car, compute classroom grades, determine election results, evaluate investment performance, calculate the real cost of credit card purchases, design a database, forecast college expenses and savings, and much more

Synopsis:

* Manipulate strings and work with database functions

Synopsis:

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

About the Author

Ken Bluttman has been working as a software developer for nearly two decades. Ken specializes in VB.Net/VBA/database/web applications. He has written several articles on various computer topics including Office/VBA development, XML, SQL Server, and InfoPath. He has a number of books out on Excel and Access. Ken lives in New York with his wife, son, dog, hamster, some frogs, and a couple of geckos.

Peter Aitken has been writing about computers and programming for over 15 years. He has more than 45 books to his credit with over 1.5 million copies in print, and also has extensive experience writing software documentation, online help, and magazine and trade-publication articles. Some recent book titles are Managing Your Money and Investment with Excel, Powering Office XP with XML, Excel PivotTables and Charts, and Visual Basic.NET Programming with Peter Aitken. He is the proprietor of PGA Consulting, providing custom application development and technical writing services since 1994.

Table of Contents

Introduction.

Part I: Putting the Fun in Functions.

Chapter 1: Tapping into Formula and Function Fundamentals.

Chapter 2: Saving Time with Function Tools.

Chapter 3: Saying “Array!” for Formulas and Functions.

Chapter 4: Fixing Formula Boo-Boos.

Part II: Counting on Your Money.

Chapter 5: Calculating Loan Payments and Interest Rates.

Chapter 6: Appreciating What You’ll Get, Depreciating What You Got.

Chapter 7: Using Basic Math Functions.

Chapter 8: Advancing Your Math.

Chapter 9: Throwing Statistics a Curve.

Chapter 10: Using Significance Tests.

Part III: Doing the Math.

Chapter 11: Rolling the Dice on Predictions and Probability.

Chapter 12: Dressing Up for Date Functions.

Chapter 13: Keeping Well-Timed Functions.

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

Chapter 15: Digging Up the Facts.

Part IV: Working with Data.

Chapter 16: Writing Home about Text Functions.

Chapter 17: Playing Records with Database Functions.

Part V: The Part of Tens.

Chapter 18: Ten-Plus Tips for Working with Formulas.

Chapter 19: Ten-Plus Functions You Really Should Know.

Index.

Product Details

ISBN:
9780470046555
Author:
Bluttman, Ken
Publisher:
For Dummies
Author:
Aitken, Peter G.
Subject:
Non-Classifiable
Subject:
Business
Subject:
Spreadsheets - General
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Microsoft Excel
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
For Dummies
Publication Date:
February 2007
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
388
Dimensions:
9.20x7.40x.82 in. 1.35 lbs.

Other books you might like

  1. Empire of Ivory (Temeraire #04)
    Used Mass Market $4.95

Related Subjects

» Computers and Internet » Operating Systems » Microsoft Windows » Applications
» Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
» Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
» Science and Mathematics » Mathematics » General
» Science and Mathematics » Mathematics » Probability and Statistics » General
» Science and Mathematics » Mathematics » Probability and Statistics » Statistics

Microsoft Office Excel 2007 Formulas & Functions for Dummies (For Dummies) New Trade Paper
0 stars - 0 reviews
$24.99 In Stock
Product details 388 pages For Dummies - English 9780470046555 Reviews:
"Synopsis" by , * Examples of Excel formulas and functions show how to compare 15year vs. 30year mortgage terms, choose between leasing or buying a car, compute classroom grades, determine election results, evaluate investment performance, calculate the real cost of credit card purchases, design a database, forecast college expenses and savings, and much more
"Synopsis" by , * Manipulate strings and work with database functions
"Synopsis" by , 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

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.