| ||||||||||||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Frequently Bought Together
Product details
|
More About the Authors
Discover books, learn about writers, and more.
Product Description
Product Description
Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day–to–day information, such as calculating the true cost of credit card purchases or comparing 15–year and 30–year mortgage costs. This fun and friendly book demystifies Excel′s built–in functions so you can put them to work.
You′ll find step–by–step instructions on 150 of Excel′s most useful functions, how they work within formulas, and how to use them to make your life easier.
- See how to use 150 of Excel′s most useful functions, with real–world examples showing how each function is used within a formula
- Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance
- Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well
- Includes essential coverage of an additional 85 functions
In the ever–popular, non–threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel′s power accessible to you.
From the Back Cover
Get your hands dirty and dig for the nuggets in your data! This book shows you how, walking you through over 150 built–in functions in Excel 2010. Want to calculate a loan payment? How about finding a trend in your data? It′s all covered with step–by–step instructions and illustrations, so you can put the power of Excel functions to work.
Put the fun in functions — from using the Insert Function dialog box and array functions to correcting formulas, you′ll brush up on Excel
Do the math — create worksheets to track costs and revenue
Simple to sophisticated — take advantage of finance–related functions and learn how to sum and round numbers to get just the answers you need
Statistically speaking — test for central tendencies, analyze deviation, and count items in a data sample
Dive into forecasting — apply statistical functions to develop sound predictions
Make the data work for you — work with dates, times, and strings of text and pluck out pieces of data from a database
What′s your function? — get the most from several cool functions, such as the amazing IF and the workhorses HLOOKUP and VLOOKUP
Open the book and find:
Tips for tapping into formula and function fundamentals
How to catch errors and audit formulas
Steps for moving from basic to advanced math functions
How to solve problems with statistics
Best practices for working with data
How to compare, find, and measure text
Ways to use lookup, logical, and reference functions
How to put data into a database structure
Learn to:
Use Excel′s built–in formulas to make everyday calculations
Determine what functions to use in your formulas
Create amortization tables, calculate classroom grades, or evaluate investments
Design a database
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Like calculating averages, including todays date etc etc.
Thoroughly recommended for a new user or as a reminder for the experienced writer.
So I got the paperback version and we were off. With the layout of the book as it was ment to be and charts and examples fully seen there was no holding me back. The book covers Excel 2010 but in nearly all cases you can use this for Excel 2003 as well. In short this is a fantastic simple no nonsence explanation of the understanding of formulas and functions in Excel. Buy it now it is so simple.
Listmania!
|
|
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
