55% off any Apress title—your Summer Sale giveaway!

Microsoft Excel Functions Quick Reference

For High-Quality Data Analysis, Dashboards, and More

Authors: Mehta, Mandeep

Free Preview
  • Consists of examples for each function discussed
  • Discusses complex calculations and their solutions by using a mega formula
  • Covers simplification of multiple calculations at once
see more benefits

Buy this book

eBook $29.99
price for Mexico
  • ISBN 978-1-4842-6613-7
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $37.99
price for Mexico
  • ISBN 978-1-4842-6612-0
  • Free shipping for individuals worldwide
  • Institutional customers should get in touch with their account manager
  • Covid-19 shipping restrictions
  • Usually ready to be dispatched within 3 to 5 business days, if in stock
About this book

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.



About the authors

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. 

Table of contents (14 chapters)

Table of contents (14 chapters)

Buy this book

eBook $29.99
price for Mexico
  • ISBN 978-1-4842-6613-7
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $37.99
price for Mexico
  • ISBN 978-1-4842-6612-0
  • Free shipping for individuals worldwide
  • Institutional customers should get in touch with their account manager
  • Covid-19 shipping restrictions
  • Usually ready to be dispatched within 3 to 5 business days, if in stock

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Microsoft Excel Functions Quick Reference
Book Subtitle
For High-Quality Data Analysis, Dashboards, and More
Authors
Copyright
2021
Publisher
Apress
Copyright Holder
Mandeep Mehta
eBook ISBN
978-1-4842-6613-7
DOI
10.1007/978-1-4842-6613-7
Softcover ISBN
978-1-4842-6612-0
Edition Number
1
Number of Pages
XXIX, 255
Number of Illustrations
127 b/w illustrations
Topics