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.
EUR 8,65 gastos de envío desde Reino Unido a España
Destinos, gastos y plazos de envíoEUR 37,89 gastos de envío desde Estados Unidos de America a España
Destinos, gastos y plazos de envíoLibrería: Brit Books, Milton Keynes, Reino Unido
Paperback. Condición: Used; Good. ***Simply Brit*** Welcome to our online used book store, where affordability meets great quality. Dive into a world of captivating reads without breaking the bank. We take pride in offering a wide selection of used books, from classics to hidden gems, ensuring there is something for every literary palate. All orders are shipped within 24 hours and our lightning fast-delivery within 48 hours coupled with our prompt customer service ensures a smooth journey from ordering to delivery. Discover the joy of reading with us, your trusted source for affordable books that do not compromise on quality. Nº de ref. del artículo: 1103085
Cantidad disponible: 1 disponibles
Librería: WorldofBooks, Goring-By-Sea, WS, Reino Unido
Paperback. Condición: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Nº de ref. del artículo: GOR004690551
Cantidad disponible: 3 disponibles
Librería: Better World Books, Mishawaka, IN, Estados Unidos de America
Condición: Good. 2nd Edition. Used book that is in clean, average condition without any missing pages. Nº de ref. del artículo: 5596878-6
Cantidad disponible: 1 disponibles
Librería: Better World Books: West, Reno, NV, Estados Unidos de America
Condición: Good. 2nd Edition. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Nº de ref. del artículo: 5397289-6
Cantidad disponible: 2 disponibles
Librería: Better World Books, Mishawaka, IN, Estados Unidos de America
Condición: Good. 2nd Edition. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Nº de ref. del artículo: 5397289-6
Cantidad disponible: 1 disponibles
Librería: SN Books Ltd, Thetford, Reino Unido
Paperback. Condición: Very Good. Orders shipped daily from the UK. Professional seller. Nº de ref. del artículo: mon0000035284
Cantidad disponible: 1 disponibles
Librería: 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: 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: 00070787478
Cantidad disponible: 2 disponibles
Librería: The Maryland Book Bank, Baltimore, MD, Estados Unidos de America
paperback. Condición: Good. 2nd Edition. Corners are bent Used - Good. Nº de ref. del artículo: 5-S-5-0164
Cantidad disponible: 1 disponibles
Librería: New Legacy Books, Annandale, NJ, Estados Unidos de America
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_ns
Cantidad disponible: 1 disponibles