The links below contain some helpful Excel information. Check back periodically for more.

How to create a horizontal line in a column graph.

How to protect your spreadsheet from the whims of other users.

How to protect your VBA code.

How to limit the contents of a cell to a dropdown list to create consistency in user inputs.

How to automatically create borders as you input data.

How to eliminate unnecessary intermediate calculations using array formulas.

How to pull out the middle of a text string.

How to do auto-populating, multivariable regression in Excel.

 

Feel free to share these, but please give credit and link back to the site.