Put the power of Excel functions to work in your formulas
There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dummies offers thorough but easy-to-read coverage of powerful Excel functions.
With this book, you'll learn to apply the power of Excel functions and formulas to make your work and other tasks easier. Compare 15-year vs. 30-year mortgage terms, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit card purchases, or forecast college expenses and savings. All of this and more is possible when you master functions and formulas in Excel. Although it covers the latest software version, Excel 2019, the techniques and functions described in this book can be used on any version of Excel.
* Step-by-step instruction on Excel's 150 most useful functions
* Each function is illustrated by helpful, real-world examples
* 85 specialized functions are described in abbreviated form
* Includes Excel's must-know functions
This book is a must-read for beginning to intermediate Excel users who want to find out how to use Excel's powerful built-in functions.
Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.
Ken Bluttman is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written numerous articles and books on a variety of technical topics. His latest projects include large-scale cloud-based applications and mobile app development.
Put Excel's powerful functions to work for you!
Excel contains a whopping 400+ built-in functions. Now before your eyes glaze over, this book has sorted out the 150 most useful ones and provided step-by-step instructions on how to use each within a formula. Helpful, real-world examples show you how to take advantage of Excel's power for basic tasks, like determining your business's average sale, computing classroom grades, forecasting college expenses, determining the REAL cost of large credit card purchases, or just cataloging your recipe collection. Add Excel to your team!
Inside...
* Understand how functions work within a formula
* Take full advantage of built-in Excel functions
* Evaluate and forecast investments and expenses
Put Excel's powerful functions to work for you!
Excel contains a whopping 400+ built-in functions. Now before your eyes glaze over, this book has sorted out the 150 most useful ones and provided step-by-step instructions on how to use each within a formula. Helpful, real-world examples show you how to take advantage of Excel's power for basic tasks, like determining your business's average sale, computing classroom grades, forecasting college expenses, determining the REAL cost of large credit card purchases, or just cataloging your recipe collection. Add Excel to your team!
Inside...
* Essential Excel functions
* Real-world examples using each function in a formula
* Using Excel to make decisions
* Saving time with function tools
* Calculating interest rates
* Applying significance tests
* Working with database functions
„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.
Anbieter: BooksRun, Philadelphia, PA, USA
Paperback. Zustand: Good. 5. It's a preowned item in good condition and includes all the pages. It may have some general signs of wear and tear, such as markings, highlighting, slight damage to the cover, minimal wear to the binding, etc., but they will not affect the overall reading experience. Artikel-Nr. 1119518253-11-1
Anzahl: 1 verfügbar
Anbieter: Dream Books Co., Denver, CO, USA
Zustand: acceptable. This copy has clearly been enjoyedâ"expect noticeable shelf wear and some minor creases to the cover. Binding is strong, and all pages are legible. May contain previous library markings or stamps. Artikel-Nr. 4EKGU9005ZDN_ns
Anzahl: 1 verfügbar
Anbieter: Better World Books, Mishawaka, IN, USA
Zustand: Good. Former library copy. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Artikel-Nr. 19207373-75
Anzahl: 1 verfügbar
Anbieter: Better World Books, Mishawaka, IN, USA
Zustand: Good. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Artikel-Nr. 40035079-6
Anzahl: 2 verfügbar
Anbieter: Better World Books Ltd, Dunfermline, Vereinigtes Königreich
Zustand: Very Good. Former library copy. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Artikel-Nr. 18988967-20
Anzahl: 1 verfügbar
Anbieter: BoundlessBookstore, Wallingford, Vereinigtes Königreich
Paperback. Zustand: Good. Very good condition paperback with minimal wear. Contents are clean and bright throughout with no markings. Artikel-Nr. 9999-999100375122
Anzahl: 1 verfügbar
Anbieter: BoundlessBookstore, Wallingford, Vereinigtes Königreich
Paperback. Zustand: Good. Good condition paperback with light wear. Contents are clean and bright throughout with no markings. Artikel-Nr. 9999-999102295056
Anzahl: 1 verfügbar
Anbieter: Phatpocket Limited, Waltham Abbey, HERTS, Vereinigtes Königreich
Zustand: Good. Your purchase helps support Sri Lankan Children's Charity 'The Rainbow Centre'. Ex-library, so some stamps and wear, but in good overall condition. Our donations to The Rainbow Centre have helped provide an education and a safe haven to hundreds of children who live in appalling conditions. Artikel-Nr. Z1-B-020-01947
Anzahl: 1 verfügbar
Anbieter: BoundlessBookstore, Wallingford, Vereinigtes Königreich
Paperback. Zustand: Good. G ood condition paperback with light wear. Contents are clean with minor age tone. Artikel-Nr. 9999-999100611956
Anzahl: 1 verfügbar
Anbieter: Robinson Street Books, IOBA, Binghamton, NY, USA
Paperback. Zustand: very good or better. Prompt Shipment, shipped in Boxes, Tracking PROVIDEDComputersvery good, clean, sturdy copy. Artikel-Nr. Roughroom290076
Anzahl: 1 verfügbar