Title: Excel Formulas and Functions: 80 Top Excel Functions Made Easy (Paperback or Softback)
Publisher: Gtech Publishing 12/5/2022
Publication Date: 2022
Language: English
ISBN 10: 1915476070
ISBN 13: 9781915476074
Binding: Paperback or Softback
Condition: New
Book Type: Book

About this title

Synopsis

Leverage the full power of Excel functions

Excel Formulas and Functions provides clear, step-by-step explanations on creating formulas with over 80 of the most useful Excel functions.

This book provides a detailed description of each function, its arguments, and practical examples relevant to real-world productivity tasks. Create powerful formulas with simpler syntax using modern functions like IFS, XLOOKUP, XMATCH, TEXTSPLIT, and FILTER. From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.

Excel Formulas and Functions is a great reference guide for working with Excel in your job, business, studies, or home. This book has been organized to make it easier for you to quickly find answers to your questions.

Downloadable sample files for hands-on learning

All examples in this book are available online as downloadable Excel files. You can learn Excel formulas and functions faster with the sample files as you don't need to create the examples in the book from scratch. You can copy and adapt the tried and tested formulas for use in your own worksheets.

In this book, you'll learn how to:

Troubleshoot and fix formula errors.
Use the latest lookup and reference functions to find and reference values in your formulas.
Return rows and columns of data using dynamic array functions.
Sort and filter data without changing the source data.
Use logical functions to include decision branches in your formulas.
Deploy advanced logical functions in place of convoluted nested functions for more efficient and flexible solutions.
Use date and time functions to address a wide range of date calculations.
Manipulate text strings easily with new and more flexible text functions.
Perform a variety of aggregate and summary calculations using math and statistical functions.
Calculate loan payments, the value of investments, and depreciation using special financial functions.

This book covers the latest version of Excel for Microsoft 365 (2022 update).

"About this title" may belong to another edition of this title.

Store Description

Save up to 90% on your favorite items at BargainBookStores.com! Our 20,000 square foot warehouse in Grand Rapids, Michigan is filled with hundreds of thousands of books and consumer goods, all at the lowest prices! We've been serving internet customers with great deals since 2001. All books ship from Grand Rapids, Michigan. 100% Customer Satisfaction Guaranteed We want to ensure your satisfaction. If you are dissatisfied with your purchase or shopping experience, we would like to hear from you. Please contact us by email: cs@bargainbookstores.com. Please be sure to include your contact information and order number. We do not charge a restocking fee for returns. Your Privacy BargainBookStores.com does not provide, sell or market customer information to other businesses or organizations.

Visit Seller's Storefront

Seller's business information

BargainBookStores
3423 Lousma Dr SE, Grand Rapids, MI, 49548, U.S.A.

Sale & Shipping Terms

Terms of Sale

BargainBookStores guarantees 100% Customer Satisfaction. We ship worldwide and offer a variety of shipping methods to meet your needs. Please place your order directly via ABEBooks.com. We accept payment by MasterCard and Visa. For more information, contact us by email at cs@bargainbookstores.com. Full contact info is below:

BargainBookStores.com LLC
3423 Lousma Dr SE
Grand Rapids, MI 49548