Overview

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.

Full Product Details

Author:   Mandeep Mehta
Publisher:   APress
Imprint:   APress
Edition:   1st ed.
Weight:   0.454kg
ISBN:  

9781484266120

ISBN 10:   1484266129
Pages:   255
Publication Date:   08 January 2021
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand  
We will order this item for you from a manufactured on demand supplier.

Table of Contents

Chapter 1 – What is an Excel function? ·         Excel formula definition ·         How to use an Excel formula ·         Different types of Excel functions   Chapter 2 –TEXT functions ·         LEFT ·         RIGHT ·         MID ·         UPPER ·         LOWER ·         PROPER ·         TRIM ·         LEN ·         FIND ·         SEARCH ·         CONCATENATE/& ·         VALUE ·         TEXT ·         EXACT ·         REPLACE ·         SUBSTITUTE   Chapter 3 – DATE functions ·         TODAY ·         DAY ·         MONTH ·         YEAR ·         DATE ·         EDATE ·         EOMONTH ·         WEEKDAY ·         WEEKNUM ·         DATEVALUE ·         NETWORKDAYS ·         DATEDIF   Chapter 4 – TIME functions ·         NOW ·         HOUR ·         MINUTE ·         SECOND ·         TIMEVALUE   Chapter 5 – LOOKUP functions ·         VLOOKUP ·         HLOOKUP ·         MATCH ·         INDEX ·         CHOOSE    Chapter 6 – AGGREGATE functions ·         SUM ·         SUMIF ·         SUMIFS ·         SUMPRODUCT ·         SUBTOTAL ·         COUNT ·         COUNTIF ·         COUNTIFS ·         AVERAGE ·         AVERAGEIF ·         AVERAGEIFS ·         AGGREGATE   Chapter 7 – LOGICAL functions ·         IF ·         IFS ·         AND ·         OR ·         NOT ·         IFERROR ·         IFNA ·         SWITCH   Chapter 8 – REFERENCE functions ·         INDIRECT ·         ADDRESS ·         OFFSET ·         ROW ·         ROWS ·         COLUMN ·         COLUMNS   Chapter 9 – MATH functions ·         ABS ·         INT ·         TRUNC ·         ROUND ·         ODD ·         EVEN ·         POWER ·         PRODUCT   Chapter 10 – INFORMATION functions ·         CELL ·         ISBLANK ·         ISERROR ·         ISEVEN ·         ISODD ·         ISFORMULA ·         ISLOGICAL ·         ISNA ·         ISNONTEXT ·         ISNUMBER ·         ISTEXT ·         N ·         TYPE   Chapter 11 – MEGA-Formula ·         What is Mega formula? ·         How to create a mega formula ·         Examples   Chapter 12 – Array formula ·         What is an array formula? ·         Advantages and disadvantages ·         Examples   Appendix A – Formula Reference ready reckoner

Reviews

Author Information

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. 

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions