Such Happiness In Thought Happens

May 13, 2008

List analysis in Excel 2003

Filed under: MS Office — Tags: , , , — Duane @ 8:48 am

There are a number of ways of achieving the same result of finding data from an Excel list. In this post I would like to look at some of these different methods so you can determine which one you would use depending upon your situation. The file that I will be using to demonstrate these techniques is available HERE and you can download said file for practice. The file was made using data from the Northwind Access database, which was then exported out to Excel. This post will look at Excel 2003 and earlier. I might do an Excel 2007 version in the future as Sorting, Filters and Pivot Tables have changed in the newer version.

(more…)

Blog at WordPress.com.