Put the power of Excel formulas and functions to work for you! 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.
"Sinopsis" puede pertenecer a otra edición de este libro.
Ken Bluttman has been a software developer for 20 years. He is the author of several books, including Excel Charts For Dummies. Peter Aitken has written about computers and programming for over 10 years and has written more than 35 books, including Excel Programming Weekend Crash Course.
Roll up your sleeves and start working with functions from ABS to ZTEST
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
"Sobre este título" puede pertenecer a otra edición de este libro.
GRATIS gastos de envío en Estados Unidos de America
Destinos, gastos y plazos de envíoEUR 5,98 gastos de envío en Estados Unidos de America
Destinos, gastos y plazos de envíoLibrería: World of Books (was SecondSale), Montgomery, IL, Estados Unidos de America
Condición: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Nº de ref. del artículo: 00086482832
Cantidad disponible: 1 disponibles
Librería: World of Books (was SecondSale), Montgomery, IL, Estados Unidos de America
Condición: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Nº de ref. del artículo: 00084831142
Cantidad disponible: 1 disponibles
Librería: Goodwill of Colorado, COLORADO SPRINGS, CO, Estados Unidos de America
Condición: good. This item is in overall good condition. Covers and dust jackets are intact but may have minor wear including slight curls or bends to corners as well as cosmetic blemishes including stickers. Pages are intact but may have minor highlighting writing. Binding is intact; however, spine may have slight wear overall. Digital codes may not be included and have not been tested to be redeemable and or active. Minor shelf wear overall. Please note that all items are donated goods and are in used condition. Orders shipped Monday through Friday! Your purchase helps put people to work and learn life skills to reach their full potential. Orders shipped Monday through Friday. Your purchase helps put people to work and learn life skills to reach their full potential. Thank you! Nº de ref. del artículo: 466TY8001UXA
Cantidad disponible: 1 disponibles
Librería: New Legacy Books, Annandale, NJ, Estados Unidos de America
paperback. Condición: Good. The cover shows normal wear. This is a ex library book, stickers and markings accordingly. Fast shipping and order satisfaction guaranteed. A portion of your purchase benefits Non-Profit Organizations, First Aid and Fire Stations! Nº de ref. del artículo: 5FSZKH000NI5
Cantidad disponible: 1 disponibles
Librería: New Legacy Books, Annandale, NJ, Estados Unidos de America
paperback. Condición: Very Good. Fast shipping and order satisfaction guaranteed. A portion of your purchase benefits Non-Profit Organizations, First Aid and Fire Stations! Nº de ref. del artículo: mon0000001885
Cantidad disponible: 1 disponibles
Librería: ThriftBooks-Dallas, Dallas, TX, Estados Unidos de America
Paperback. Condición: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less. Nº de ref. del artículo: G047056816XI3N00
Cantidad disponible: 2 disponibles
Librería: ThriftBooks-Atlanta, AUSTELL, GA, Estados Unidos de America
Paperback. Condición: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less. Nº de ref. del artículo: G047056816XI3N00
Cantidad disponible: 1 disponibles
Librería: ThriftBooks-Phoenix, Phoenix, AZ, Estados Unidos de America
Paperback. Condición: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Nº de ref. del artículo: G047056816XI4N00
Cantidad disponible: 1 disponibles
Librería: ThriftBooks-Dallas, Dallas, TX, Estados Unidos de America
Paperback. Condición: Fair. No Jacket. Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less. Nº de ref. del artículo: G047056816XI5N00
Cantidad disponible: 1 disponibles
Librería: ThriftBooks-Atlanta, AUSTELL, GA, Estados Unidos de America
Paperback. Condición: Fair. No Jacket. Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less. Nº de ref. del artículo: G047056816XI5N00
Cantidad disponible: 1 disponibles