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

ISBN-13: 9781484266120 / Angielski / Miękka / 2021 / 255 str.

Mandeep Mehta

Opis

Intermediate

Spis treści

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

O autorze

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. 

Blurb

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. 

You will:

• Work with basic Excel functions
• Use the LOOKUP function
• Take advantage of new functions in information functions
• Create a mega formula