Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.

It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

Colors

Lookups

2 way lookup

Convert Function

Count the number of errors in a range

Delete all text after the first instance

Delete all text before the first instance

Lookup multiple values from a list where vlookup will not work

Lookup unique values from a list where vlookup will not work

Pad number to specific number of digits

Sum with NA in range

VLOOKUP

Macros