Microsoft Excel Functions Quick Reference

1. Front Matter

   Pages i-xxix

   PDF

2. What Is an Excel Function?

   • Mandeep Mehta

   Pages 1-5

3. Text Functions

   • Mandeep Mehta

   Pages 7-30

4. Date Functions

   • Mandeep Mehta

   Pages 31-51

5. Time Functions

   • Mandeep Mehta

   Pages 53-58

6. Named Ranges and Excel Tables

   • Mandeep Mehta

   Pages 59-71

7. Lookup & Reference Functions

   • Mandeep Mehta

   Pages 73-102

8. Aggregate Functions

   • Mandeep Mehta

   Pages 103-138

9. Logical Functions

   • Mandeep Mehta

   Pages 139-149

10. Math Functions

    • Mandeep Mehta

    Pages 151-160

11. Information Functions

    • Mandeep Mehta

    Pages 161-183

12. Finance Functions

    • Mandeep Mehta

    Pages 185-204

13. Error Handling

    • Mandeep Mehta

    Pages 205-212

14. Megaformulas

    • Mandeep Mehta

    Pages 213-220

15. Array Formulas

    • Mandeep Mehta

    Pages 221-242

16. Back Matter

    Pages 243-255

    PDF

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 the quality of your data analysis, dashboards, models, and templates.


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

Who This Book Is For


Administrators, analysts, and anyone else working with Microsoft Excel.

• Excel
• Microsoft
• Microsoft Office
• Excel functions
• VLOOKUP alternative
• Excel References
• Excel string functions

• Mumbai, India

  Mandeep Mehta

Mandeep has more than 20 years of experience in administration, operations, software development, and reporting. He mostly works with cross-functional teams in ensuring operational and service excellence. Mandeep has worked with Capgemini for more than ten years and is currently working as a freelancer in conducting various training in MS Office and providing data services. 

Policies and ethics