Here Is A List of Helpful Excel HOW TO Articles

image Graphic from 

I love it when people take the time to write up step-by-step HOW TO articles or blogs.  And, I like Excel HOW TO articles because it is an easy way to give a tutorial to a client when I need them to create/fix/organize data for loading into an ERP system. 

Recently, I have found quite a few key Excel HOW TO procedures.  As I like to keep things where I can easily find them, I am putting them on my blog so that others have the list, too.

Here we go.

1. Copy a formula in Excel

2. Excel Data Validation for Dates  (This is awesome!)

3. How to find duplicates in Excel and numbers (uses conditionals and COUNTIF)

4. All about Pivot Tables or at

5. Eleven advanced Excel tricks – Vlookup, Index match,  3D Sum, $ sign, Ampersand symbol, arrays, goal seek, pivot tables,

6. How to split data from one column to two or

7. Link data in two workbooks

8. General Excel training from Microsoft