 Addin
 Blank cells
 Calendar
 Case sensitive
 Charts
 Combinations
 Combine/Merge
 Compare
 Concatenate
 Conditional formatting
 Count records
 Count unique distinct records
 Count values
 Dates
 Drop down lists
 Duplicate records
 Duplicate values
 Features
 Filter emails
 Filter records
 Finance
 Find numbers in sum
 Functions
 Compability
 Date and Time
 Financial
 Information
 Logical
 Lookup and reference
 Math and trigonometry
 ABS function
 AGGREGATE function
 COMBIN function
 COMBINA function
 COS function
 DEGREES function
 EVEN function
 EXP function
 FACT function
 INT function
 LN function
 LOG function
 MMULT function
 MOD function
 MROUND function
 PI function
 POWER function
 PRODUCT function
 QUOTIENT function
 RADIANS function
 RAND function
 RANDBETWEEN function
 SIGN function
 SIN function
 SQRT function
 SUBTOTAL function
 SUM function
 SUMIF function
 SUMIFS function
 SUMPRODUCT function
 TAN function
 Statistical
 AVERAGE function
 AVERAGEIF function
 AVERAGEIFS function
 COUNT function
 COUNTA function
 COUNTBLANK function
 COUNTIF function
 COUNTIFS function
 FREQUENCY function
 LARGE function
 MAX function
 MAXIFS function
 MEDIAN function
 MIN function
 MINIFS function
 MODE.MULT function
 PERMUT function
 PERMUTATIONA function
 SMALL function
 Text
 Fuzzy lookup
 Hyperlinks
 Invoice
 Maps
 Maze
 Misc
 Missing values
 Normalize data
 Pathfinding
 Permutations
 Random
 Rank
 Rearrange values
 Records
 Related tables
 Schedule
 Search and return multiple values
 Sequence
 Sort values
 Split values
 Substitute Replace
 Templates
 Text string manipulation
 Tournament
 Twodimensional lookup
 Unique distinct records
 Unique distinct values
 Unique values
 VBA
 VLOOKUP and return multiple values

Sign up for free blog updates
Categories