Excel Data Tutorials

Data Validation – Dependent Lists

Saturday, October 16th, 2010 at 08:54 | 0 comments
Categories: Data

How to Add a Comment to a Formula

Wednesday, October 15th, 2008 at 02:08 | 6 comments
Categories: Data, Formulas, General

Connect Excel to Mysql Database

Tuesday, November 1st, 2005 at 17:30 | 38 comments
Categories: Data

Export MYSQL Table to Excel Spreadsheet with the Click of a Link

Tuesday, March 15th, 2005 at 04:50 | 5 comments
Categories: Data
Tags:

Sort Horizontally

Sunday, January 9th, 2005 at 17:11 | 0 comments
Categories: Data
Tags:

Extra Rows in CSV file

Saturday, August 14th, 2004 at 22:22 | 0 comments
Categories: Data
Tags:

Remove Hyphens using Substitute

Saturday, August 14th, 2004 at 22:20 | 0 comments
Categories: Data
Tags:

Sort Left to Right or Sort by Columns

Saturday, August 14th, 2004 at 22:18 | 0 comments
Categories: Data
Tags:

Create a list to choose from (dropdown list)

Saturday, August 14th, 2004 at 22:17 | 1 comment
Categories: Data
Tags:

Hide Duplicates

Saturday, August 14th, 2004 at 22:15 | 1 comment
Categories: Data
Tags: