Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More

iebukes Apress 196 次浏览 没有评论
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More Front Cover

Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More

by Mandeep Mehta
  • Length: 284 pages
  • Edition: 1
  • Publisher: Apress
  • Publication Date: 2021-01-22
  • ISBN-10: 1484266129
  • ISBN-13: 9781484266120
Description

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.

Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More

 
 “你有一个苹果,我有一个苹果,彼此交换一下,我们彼此仍然是各有一个苹果;你有一本电子书,我有一本电子书,我们交换一下,一人就有两本电子书”,扫描下面二维码,加入iebukes电子书分享群,和大家一起分享你手中的电子书吧!本站分享的电子书访问密码见群公告,赶快入群吧!  
                微信公众号二维码