Authors:
- Consists of examples for each function discussed
- Discusses complex calculations and their solutions by using a mega formula
- Covers simplification of multiple calculations at once
Buy it now
Buying options
Tax calculation will be finalised at checkout
Other ways to access
This is a preview of subscription content, log in via an institution to check for access.
Table of contents (14 chapters)
-
Front Matter
-
Back Matter
About this book
The Microsoft Excel Functions Quick Reference helps you set up workbooks, enter data, and format it for easier viewing. It starts by giving an overview of Excel functions explaining the different types of Excel functions available followed by an understanding of string functions and date functions. It then covers time, lookup, aggregate, and logical functions along with practice problems. Further, you will see math functions and information functions in Excel. You will also be able to create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines. Each function in the text is illustrated by helpful, illuminating examples.
With this book by your side, you'll always have the answer to your Excel function syntax questions.
What You Will Learn
- Work with basic Excel functions
- Use the LOOKUP function
- Take advantage of new functions in information functions
- Create a mega formula
Administrators, analysts, and anyone else working with Microsoft Excel.
Authors and Affiliations
-
Mumbai, India
Mandeep Mehta
About the author
Bibliographic Information
Book Title: Microsoft Excel Functions Quick Reference
Book Subtitle: For High-Quality Data Analysis, Dashboards, and More
Authors: Mandeep Mehta
DOI: https://doi.org/10.1007/978-1-4842-6613-7
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Mandeep Mehta 2021
Softcover ISBN: 978-1-4842-6612-0Published: 08 January 2021
eBook ISBN: 978-1-4842-6613-7Published: 07 January 2021
Edition Number: 1
Number of Pages: XXIX, 255
Number of Illustrations: 127 b/w illustrations
Topics: Microsoft and .NET