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.