Several people suggested that I create a separate page and menu item listing the Excel tips and tutorials. Given the number, it probably makes sense. Instead of providing the full titles, I’ve opted to use a shorter one for spacing.

I’ve also included a legend to indicate if there are supplemental files. “S” = spreadsheet, “F” = Flash Demo, “P”= PDF with larger screen images.

General Excel Tips & Tutorials

How to use Excel Pivot Tables (S,P)

How to use Conditional Formatting in Excel (F)

How use Excel AutoFilter (S)

How to Display Excel’s Filter Criteria (S)

How to create Custom Fill Lists in Excel

How to use Mail Merge with Excel and Microsoft Word (S, F)

How to use Excel Data Forms (F)

How to assign Excel Cell and Range names (S)

How to have Excel filter invalid email addresses

How to Switch columns & rows in Excel (S, F)

How to Freeze columns & rows in Excel

How to use Excel to parse and convert street addresses (S, F)

Excel Function & Formula Tutorials

How to use Excel VLOOKUP (S,P)

How to use Excel LEN function to find problem records (F)

How to use Excel IF function (S)

How to use Excel RAND & RANDBETWEEN functions

How to prevent Excel Divide by 0 errors

How to Create a Word Count Formula (S)

How to find answers with Excel Goal Seek

Excel Add-ins & Related Programs

How to convert Word docs to Excel

How to create gift certificates with Excel and Word (F)

How to create mail merge files with Excel and Word (S,F)

Product Review: ASAP Utilities Add On