Microsoft Excel Functions Quick Reference

For High-Quality Data Analysis, Dashboards, and More

Paperback Engels 2021 9781484266120
Verwachte levertijd ongeveer 9 werkdagen

Samenvatting

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 LearnWork with basic Excel functionsUse the LOOKUP functionTake advantage of new functions in information functionsCreate a mega formulaWho This Book Is For
Administrators, analysts, and anyone else working with Microsoft Excel.

Specificaties

ISBN13:9781484266120
Taal:Engels
Bindwijze:paperback
Uitgever:Apress

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Inhoudsopgave

<p>Chapter 1: What is an Excel function?.- Chapter 2:&nbsp;TEXT functions.- Chapter 3: DATE functions.- Chapter 4: TIME functions.- Chapter 5:&nbsp;Named Ranges and Excel Tables.- Chapter 6:&nbsp;LOOKUP &nbsp; 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.</p><p></p>

Managementboek Top 100

Rubrieken

    Personen

      Trefwoorden

        Microsoft Excel Functions Quick Reference