LEADER 02980oam 2200433 450 001 9910484214003321 005 20210615010816.0 010 $a1-4842-6613-7 024 7 $a10.1007/978-1-4842-6613-7 035 $a(CKB)4100000011704553 035 $a(DE-He213)978-1-4842-6613-7 035 $a(MiAaPQ)EBC6452456 035 $a(CaSebORM)9781484266137 035 $a(PPN)253256550 035 $a(EXLCZ)994100000011704553 100 $a20210615d2021 uy 0 101 0 $aeng 135 $aurnn|008mamaa 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aMicrosoft excel functions quick reference $efor high-quality data analysis, dashboards, and more /$fMandeep Mehta 205 $a1st ed. 2021. 210 1$aNew York, New York :$cApress L. P.,$d[2021] 210 4$d©2021 215 $a1 online resource (XXIX, 255 p. 127 illus.) 300 $aIncludes index. 311 $a1-4842-6612-9 327 $aChapter 1: What is an Excel function? -- Chapter 2: TEXT functions -- Chapter 3: DATE functions -- Chapter 4: TIME functions -- Chapter 5: Named Ranges and Excel Tables -- Chapter 6: LOOKUP & functions -- Chapter 7: AGGREGATE functions -- Chapter 8: LOGICAL functions -- Chapter 9: Maths functions -- Chapter 10: INFORMATION functions -- Chapter 11: Finance functions -- Chapter 12: Error Handling -- Chapter 13: Megaformulas -- Chapter 14: Array formula. Appendix A: Formula ready reckoner. 330 $aThis 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. You will: Work with basic Excel functions Use the LOOKUP function Take advantage of new functions in information functions Create a mega formula. 676 $a005.54 700 $aMehta$b Mandeep$01228714 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bUtOrBLW 906 $aBOOK 912 $a9910484214003321 996 $aMicrosoft excel functions quick reference$92852590 997 $aUNINA