How to Create a Macro - Excel tutorial

Category: Excel tutorials > Macros - Difficulty:

Offset allows you to refer to cells above, below, left or right of a reference cell. Very useful for cash flow forecasts where the receipt or payment of money can move between periods.

This video tutorial shows how to use the square root function in Excel.

The width of column and height of row can be changed very easily to properly accommodate the data in cells.

Change the format of cells depending on their contents and various other conditions that may be required.

These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper.