PDF GUIDE - Exceljet
PDF GUIDE
TABLE of Contents
101 Excel Functions2 Date and Time Functions3 Engineering 9 Information Functions 10 Logical Functions11 Lookup and Reference Functions 13 STATISTICAL Functions19 MATH Functions24 TEXT Functions28 Dynamic Array Functions33 More Resources34
Copyright
No part of this publication shall be reproduced, or sold in whole or in part in any form, without the prior written consent of the author. All trademarks and registered trademarks appearing in this guide are the property of their respective owners.
? 2021 Exceljet. All rights reserved.
Published: 2021-04-14 09:59:45
Quick Navigation
ABS AGGREGATE AND AVERAGE AVERAGEIF AVERAGEIFS CEILING CHAR CHOOSE CLEAN CODE COLUMN COLUMNS CONCAT CONCATENATE CONVERT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS DATE DATEDIF DAY EDATE EOMONTH EXACT FILTER FIND FLOOR GETPIVOTDATA HLOOKUP HOUR HYPERLINK IF IFERROR IFNA IFS INDEX INDIRECT INT ISBLANK ISERROR ISEVEN ISFORMULA ISLOGICAL ISNUMBER ISODD ISTEXT LARGE LEFT LEN LOOKUP LOWER MATCH MAX MAXIFS MID MIN MINIFS MINUTE MOD MODE MONTH MROUND NETWORKDAYS NOT NOW OFFSET OR PROPER RAND RANDARRAY RANDBETWEEN RANK REPLACE RIGHT ROUND ROUNDDOWN ROUNDUP ROW ROWS SEARCH SECOND SEQUENCE SMALL SORT SORTBY SUBSTITUTE SUBTOTAL SUM SUMIF SUMIFS SUMPRODUCT TEXT TEXTJOIN TIME TODAY TRANSPOSE TRIM UNIQUE UPPER VLOOKUP WEEKDAY WEEKNUM WORKDAY XLOOKUP XMATCH YEAR YEARFRAC
Table of Contents
101 EXCEL FUNCTIONS
1
101 Excel Functions
Excel has over 480 built-in functions, and more are still being added. That is a huge number of functions to think about, even for advanced users. Thankfully, you don't need to learn all of these functions to be productive in Excel. If you have a basic understanding of about a hundred key functions, you'll be far ahead of the average user. This document contains a brief overview of about 100 important Excel functions you should know, with links to detailed examples. It is based on a more complete list of Excel functions here.
Excel Function List We also have a large list of example formulas and video training. If you are new to Excel formulas and how functions are used, see this introduction.
Quick Navigation
ABS AGGREGATE AND AVERAGE AVERAGEIF AVERAGEIFS CEILING CHAR CHOOSE CLEAN CODE COLUMN COLUMNS CONCAT CONCATENATE CONVERT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS DATE DATEDIF DAY EDATE EOMONTH EXACT FILTER FIND FLOOR GETPIVOTDATA HLOOKUP HOUR HYPERLINK IF IFERROR IFNA IFS INDEX INDIRECT INT ISBLANK ISERROR ISEVEN ISFORMULA ISLOGICAL ISNUMBER ISODD ISTEXT LARGE LEFT LEN LOOKUP LOWER MATCH MAX MAXIFS MID MIN MINIFS MINUTE MOD MODE MONTH MROUND NETWORKDAYS NOT NOW OFFSET OR PROPER RAND RANDARRAY RANDBETWEEN RANK REPLACE RIGHT ROUND ROUNDDOWN ROUNDUP ROW ROWS SEARCH SECOND SEQUENCE SMALL SORT SORTBY SUBSTITUTE SUBTOTAL SUM SUMIF SUMIFS SUMPRODUCT TEXT TEXTJOIN TIME TODAY TRANSPOSE TRIM UNIQUE UPPER VLOOKUP WEEKDAY WEEKNUM WORKDAY XLOOKUP XMATCH YEAR YEARFRAC
Table of Contents
101 EXCEL FUNCTIONS
2
Date and Time Functions
Excel provides many functions to work with dates and times.
NOW and TODAY
You can get the current date with the TODAY function and the current date and time with the NOW Function. Technically, the NOW function returns the current date and time, but you can format as time only, as seen below:
Note: these are volatile functions and will recalculate with every worksheet change. If you want a static value, use date and time shortcuts.
DATE SHORTCUT: This shortcut will insert the current date as a fixed value; it will not change.
Easily add Date and Time to your Excel files using these functions
TIME SHORCUT: This shortcut will insert the current time as a fixed value; it will not change. [Note: In Mac 2016, Control Shift : stopped working to insert a time. Command ; now seems to work.]
More excel shortcuts.
101 EXCEL FUNCTIONS
3
DAY, MONTH, YEAR, and DATE
You can use the DAY, MONTH, and YEAR functions to disassemble any date into its raw components, and the DATE function to put things back together again.
Did you know?
Excel dates are serial numbers that start in the year 1900.
Excel times are fractions of the number 1.
Both dates and times are numbers that can be used in math operations.
HOUR, MINUTE, SECOND, and TIME
Excel provides a set of parallel functions for times. You can use the HOUR, MINUTE, and SECOND functions to extract pieces of a time, and you can assemble a TIME from individual components with the TIME function.
101 EXCEL FUNCTIONS
4
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- excel user guide pdf 2016
- accuplacer study guide pdf 2019
- sat official guide pdf download
- 12th economics guide pdf download
- na step working guide pdf printable
- 11th maths guide pdf download
- 12th chemistry guide pdf download
- sura 10th guide pdf download
- harvard referencing guide pdf 2018
- sas survival guide pdf free
- gaap accounting guide pdf 2019
- ccna study guide pdf download