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

Mehta, Mandeep

ISBN 10: 1484266129 / ISBN 13: 9781484266120

Verlag: Apress, 2021

Beschreibung

Bestandsnummer des Verkäufers 42301254-n

Bibliografische Details

• Titel: Microsoft Excel Functions Quick Reference : For High-Quality Data Analysis, Dashboards, and More
• Verlag: Apress
• Veröffentlichungsdatum: 2021
• Sprache: Englisch
• ISBN-10: 1484266129
• ISBN-13: 9781484266120
• Bindung: Softcover
• Zustand: New

Über diesen Titel

Inhaltsangabe

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

·  

Über die Autorin bzw. den Autor

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.