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 LearnWork 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. 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
Price: 53.12 USD
Location: Matraville, NSW
End Time: 2024-12-05T07:17:29.000Z
Shipping Cost: 0 USD
Product Images
Item Specifics
Restocking Fee: No
Return shipping will be paid by: Buyer
All returns accepted: Returns Accepted
Item must be returned within: 60 Days
Refund will be given as: Money Back
EAN: 9781484266120
UPC: 9781484266120
ISBN: 9781484266120
MPN: N/A
Book Title: Microsoft Excel Functions Quick Reference: For Hig
Item Height: 1.5 cm
Number of Pages: Xxix, 255 Pages
Publication Name: Microsoft Excel Functions Quick Référence : for High-Quality Data Analysis, Dashboards, and more
Language: English
Publisher: Apress L. P.
Subject: Programming / Microsoft
Publication Year: 2021
Type: Textbook
Item Weight: 16 Oz
Author: Mandeep Mehta
Item Length: 9.3 in
Subject Area: Computers
Item Width: 6.1 in
Format: Trade Paperback
