Listed in ascending order below are comprehensive worked examples of excel functions
- 3D SUMIF
- ABS function
- ACCRINT function
- ACCRINTM function
- ACOS function
- ACOSH function
- ACOT function
- ACOTH function
- ADDRESS function
- AGGREGATE function
- AMORDEGRC function
- AMORLINC function
- Analysis ToolPak
- AND function
- ARABIC function
- Area Chart
- AREAS function
- ASC function
- ASIN function
- ASINH function
- ATAN function
- ATAN2 function
- AVEDEV function
- AVERAGE function
- AVERAGEA function
- AVERAGEIF function
- AVERAGEIFS function
- BAHTTEXT function
- Bar Chart
- BASE function
- BESSELI function
- BESSELJ function
- BESSELK function
- BESSELY function
- BETA.DIST function
- BETA.INV function
- BIN2DEC function
- BIN2HEX function
- BIN2OCT function
- BINOM.DIST function
- BINOM.DIST.RANGE function
- BINOM.INV function
- BITAND function
- BITLSHIFT function
- BITOR function
- BITRSHIFT function
- BITXOR function
- CAGR
- CEILING function
- CEILING.MATH function
- CEILING.PRECISE function
- CELL function
- Cell Ranges & References
- CHAR function
- CHISQ.DIST function
- CHISQ.DIST.RT function
- CHISQ.INV function
- CHISQ.INV.RT function
- CHISQ.TEST function
- CHOOSE function
- CLEAN function
- Clustered Column
- CODE function
- Column Chart
- COLUMN function
- COLUMNS function
- COMBIN function
- COMBINA function
- Combo Chart
- COMPLEX function
- Compound Annual Growth Rate
- CONCAT function
- CONCATENATE function
- Conditional Formatting
- CONFIDENCE.NORM function
- CONFIDENCE.T function
- Conversion
- CONVERT function
- CORREL function
- COS function
- COSH function
- COT function
- COTH function
- COUNT function
- COUNTA function
- COUNTBLANK function
- COUNTIF function
- COUNTIFS function
- COUPDAYBS function
- COUPDAYS function
- COUPDAYSNC function
- COUPNCD function
- COUPNUM function
- COUPPCD function
- COVARIANCE.P function
- COVARIANCE.S function
- CSC function
- CSCH function
- CUBEKPIMEMBER function
- CUBEMEMBER function
- CUBEMEMBERPROPERTY function
- CUBERANKEDMEMBER function
- CUBESET function
- CUBESETCOUNT function
- CUBEVALUE function
- CUMIPMT function
- CUMPRINC function
- Custom Number Format
- Data Table
- DATE function
- DATEDIF function
- DATEVALUE function
- DAVERAGE function
- DAY function
- DAYS function
- DAYS360 function
- DB function
- DBCS function
- DCOUNT function
- DCOUNTA function
- DDB function
- DEC2BIN function
- DEC2HEX function
- DEC2OCT function
- DECIMAL function
- DEGREES function
- DELTA function
- DEVSQ function
- DGET function
- DISC function
- DMAX function
- DMIN function
- DOLLAR function
- DOLLARDE function
- DOLLARFR function
- DPRODUCT function
- DSTDEV function
- DSTDEVP function
- DSUM function
- DURATION function
- DVAR function
- DVARP function
- EDATE function
- EFFECT function
- ENCODEURL function
- EOMONTH function
- ERF function
- ERFC function
- ERFC.PRECISE function
- ERROR.TYPE function
- Errors
- EVEN function
- EXACT function
- Excel Controls
- EXP function
- EXPON.DIST function
- F.DIST function
- F.DIST.RT function
- F.INV function
- F.TEST function
- FACT function
- FACTDOUBLE function
- FALSE function
- FILTERXML function
- Find & Select
- FIND function
- FINDB function
- FISHER function
- FISHERINV function
- FIXED function
- FLOOR function
- FLOOR.MATH function
- FLOOR.PRECISE function
- FORECAST function
- Format Cell
- Formulas and Functions
- FORMULATEXT function
- FREQUENCY function
- Future value
- FV function
- FVSCHEDULE function
- GAMMA function
- GAMMA.DIST function
- GAMMA.INV function
- GAMMALN function
- GAMMALN.PRECISE function
- Gantt Chart
- Gauge Chart
- GAUSS function
- GCD function
- GEOMEAN function
- GESTEP function
- GETPIVOTDATA function
- GROWTH function
- HARMEAN function
- HEX2BIN function
- HEX2DEC function
- HEX2OCT function
- Histogram Chart
- HLOOKUP function
- HOUR function
- HYPERLINK function
- HYPGEOM.DIST function
- IF function
- IFERROR function
- IFNA function
- IFS function
- IMABS function
- IMAGINARY function
- IMARGUMENT function
- IMCONJUGATE function
- IMCOS function
- IMCOSH function
- IMCOT function
- IMCSC function
- IMCSCH function
- IMDIV function
- IMEXP function
- IMLN function
- IMLOG10 function
- IMLOG2 function
- IMPOWER function
- IMPRODUCT function
- IMREAL function
- IMSECH function
- IMSIN function
- IMSINH function
- IMSQRT function
- IMSUB function
- IMSUM function
- IMTAN function
- INDEX function
- INDIRECT function
- INFO function
- INT function
- INTERCEPT function
- Internet
- INTRATE function
- IPMT function
- IRR function
- IS function
- ISBLANK function
- ISERR function
- ISERROR function
- ISEVEN function
- ISFORMULA function
- ISLOGICAL function
- ISNA function
- ISNONTEXT function
- ISNUMBER function
- ISO.CEILING function
- ISODD function
- ISOWEEKNUM function
- ISPMT function
- ISREF function
- ISTEXT function
- KURT function
- LARGE function
- LCM function
- LEFT function
- LEFTB function
- LEN function
- LENB function
- Line Chart
- LINEST function
- Links
- LN function
- LOG function
- LOG10 function
- LOGEST function
- LOGNORM.DIST function
- LOGNORM.INV function
- LOOKUP function
- LOWER function
- Macro
- MATCH function
- MAX function
- MAXA function
- MAXIFS function
- MDETERM function
- MDURATION function
- MEDIAN function
- MID function
- MIDB function
- MIN function
- MINA function
- MINIFS function
- MINUTE function
- MINVERSE function
- MIRR function
- MMULT function
- MOD function
- MODE function
- MODE.MULT function
- MODE.SNGL function
- MONTH function
- MROUND function
- MULTINOMIAL function
- MUNIT function
- N function
- NA function
- NEGBINOM.DIST function
- Nested IF
- Net Present Value
- NETWORKDAYS function
- NETWORKDAYS.INTL function
- NOMINAL function
- NORM.DIST function
- NORM.INV function
- NORM.S.DIST function
- NORM.S.INV function
- NOT function
- NOW function
- NPER function
- NPV function
- NUMBERVALUE function
- OCT2BIN function
- OCT2DEC function
- OCT2HEX function
- ODD function
- ODDFPRICE function
- ODDFYIELD function
- ODDLPRICE function
- ODDLYIELD function
- OFFSET function
- Operator Precedence
- OR function
- Pareto Chart
- PDURATION function
- PEARSON function
- Percentage
- PERCENTILE function
- PERCENTILE.EXC function
- PERCENTILE.INC function
- PERCENTRANK.EXC function
- PERCENTRANK.INC function
- PERMUT function
- PERMUTATIONA function
- PHI function
- PHONETIC function
- PI function
- Pie Chart
- Pivot
- PMT function
- POISSON.DIST function
- POWER function
- PPMT function
- Present value
- PRICE function
- PRICEDISC function
- PRICEMAT function
- PROB function
- Probability
- PRODUCT function
- PROPER function
- Protect
- PV function
- QUARTILE function
- QUARTILE.EXC function
- QUARTILE.INC function
- QUOTIENT function
- RADIANS function
- RAND function
- RANDBETWEEN function
- Random
- RANK function
- RANK.AVG function
- RANK.EQ function
- RATE function
- RECEIVED function
- REPLACE function
- REPLACEB function
- REPT function
- Ribbon
- RIGHT function
- RIGHTB function
- ROMAN function
- ROUND function
- ROUNDDOWN function
- ROUNDUP function
- ROW function
- ROWS function
- RRI function
- RSQ function
- Scatter Chart
- SEARCH function
- SEARCHB function
- SEC function
- SECH function
- SECOND function
- SEQUENCE function
- SERIESSUM function
- Share
- SHEET function
- SHEETS function
- Shortcuts
- SIGN function
- SIN function
- SINH function
- SKEW function
- SKEW.P function
- SLN function
- SLOPE function
- SMALL function
- Solver
- Sort and Filter
- Sparklines
- Split Text
- SQRT function
- SQRTPI function
- STANDARDIZE function
- STDEV function
- STDEV.S function
- STDEVA function
- STDEVPA function
- STEYX function
- SUBSTITUTE function
- SUBTOTAL
- SUBTOTAL function
- SUM function
- SUMIF function
- SUMIFS function
- SUMPRODUCT function
- SUMSQ function
- SUMX2MY2 function
- SUMX2PY2 function
- SUMXMY2 function
- SWITCH function
- SYD function
- T function
- T.DIST function
- T.DIST.2T function
- T.DIST.RT function
- T.INV function
- T.INV.2T function
- T.TEST function
- Tables
- TAN function
- TANH function
- TBILLEQ function
- TBILLPRICE function
- TBILLYIELD function
- Templates
- TEXT function
- TEXTJOIN function
- Thermometer Chart
- TIME function
- TIMEVALUE function
- TODAY function
- TRANSPOSE function
- TREND function
- Trendline
- TRIM function
- TRIMMEAN function
- TRUE function
- TRUNC function
- TYPE function
- UNICHAR function
- UNICODE function
- Unix Time Stamp
- UPPER function
- VALUE function
- VAR.P function
- VAR.S function
- VARA function
- VARPA function
- VDB function
- View Tab
- VLOOKUP function
- WEBSERVICE function
- WEEKDAY function
- WEEKDAY.INTL function
- WEEKNUM function
- WEIBULL.DIST function
- What-If Analysis:
- Whisker Plot
- Workbook
- WORKDAY function
- WORKDAY.INTL function
- Worksheets
- XIRR function
- XNPV function
- XOR function
- YEAR function
- YEARFRAC function
- YIELD function
- YIELDDISC function
- YIELDMAT function
- Z.TEST function