Microsoft Excel Functions Quick Reference
eBook - ePub

Microsoft Excel Functions Quick Reference

For High-Quality Data Analysis, Dashboards, and More

  1. English
  2. ePUB (mobile friendly)
  3. Only available on web
eBook - ePub

Microsoft Excel Functions Quick Reference

For High-Quality Data Analysis, Dashboards, and More

Book details
Table of contents
Citations

About This Book

This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade thequality of your data analysis, dashboards, models, and templates.
The Microsoft Excel Functions Quick Reference helps youset 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 createsophisticated 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

Who This Book Is For
Administrators, analysts, and anyone else working with Microsoft Excel.

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Microsoft Excel Functions Quick Reference by Mandeep Mehta in PDF and/or ePUB format, as well as other popular books in Computer Science & Microsoft Programming. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Apress
Year
2021
ISBN
9781484266137
Topic
Computer Science
Subtopic
Microsoft Programming
Index
Computer Science

Table of contents

  1. Cover
  2. Front Matter
  3. 1. What Is an Excel Function?
  4. 2. Text Functions
  5. 3. Date Functions
  6. 4. Time Functions
  7. 5. Named Ranges and Excel Tables
  8. 6. Lookup & Reference Functions
  9. 7. Aggregate Functions
  10. 8. Logical Functions
  11. 9. Math Functions
  12. 10. Information Functions
  13. 11. Finance Functions
  14. 12. Error Handling
  15. 13. Megaformulas
  16. 14. Array Formulas
  17. Back Matter