Functions in Excel are a super important tool. Excel would not be what it is without functions. They are used to make calculations based on cell contents, perform operations on the contents of a cell, find the values based on your search criteria and more. The learning of functions in Excel is crucial to mastering spreadsheets. Excel functions let you do even more once mastered.
I created this site to explain some of the most used functions in Excel. Click on the sections or functions below to get started.
Lookup and Reference Functions
(ADDRESS, CHOOSE, COLUMN, COLUMNS, FORMULATEXT, GETPIVOTDATA, HLOOKUP, HYPERLINK, INDEX, INDIRECT, MATCH, OFFSET, ROW, ROWS, TRANSPOSE, VLOOKUP)
Logical Functions
(AND, IF, IFERROR, NOT, OR)
Text Functions
(CHAR, CONCATENATE, EXACT, FIND, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TRIM, UPPER, VALUE)
Date and Time Functions
(DATE, DA, EDATE, EOMONTH, HOUR, MONTH, MINUTE, NOW, NETWORKDAYS, SECOND, TODAY, WEEKDAY, WEEKNUM, WORKDAY, YEAR)
Information Functions
(CELL, ERROR.TYPE, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT, NA, TYPE)
Mathematical Functions
(RAND, RANDBETWEEN, MROUND, ROUND, ROUNDUP, ROUNDDOWN, MOD, SUBTOTAL, SUM, SUMPRODUCT, SUMIF, SUMIFS)
Statistical Functions
(AVERAGE, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, FREQUENCY, LARGE, MAX, MEDIAN, MIN, MODE.SNGL, RANK.EQ, SMALL)
No comments:
Post a Comment