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

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

Macro Adds zeros to the front of a number

Macro Change format of date

Macro Change Color

Macro Change formulae

Macro Change formulae to values

Macro Check Color

Macro Clear a sheet but leave formulae on 2nd row

Macro Compare Columns

Macro Compare Rows

Macro Copy formulae down on a sheet

Macro Copy Formulae down on a sheet using arrays

Macro Count Binary

Macro Count Sequentially

Macro Create Sequence

Macro Delete Columns

Macro Delete unused Rows and Cols

Macro Display a message to the user

Macro Email ActiveWorkbook As Outlook Attachment

Macro Export to Text File

Macro Get Color

Macro Insert Column

Macro Master Run Routine

Macro Options

Macro Read File

Macro Scroll To

Macro Search Binary

Macro Search Sequentially

Macro Set Formulae

Macro Show Excel on Top

Macro Sort

Macro Sum Binary

Macro Sum Sequentially

Macro Text to Columns

Macro Turn Filters off

Macro Unprotect an Excel Spreadsheet if you have lost your password

Macro Window API Declarations

Macro Full Example Program