Feb 07
Digg
Stumbleupon
Technorati
Delicious

Using Text to Manipulate Dates in Excel

Today, I had a member call and ask how she could convert a list of numbers in excel to the names of a month. Apparently, she was having issues sorting her table by the name of the month and to get around the issue she replaced the names of the month with the number of […]

Author: Mark Flavin
Feb 04
Digg
Stumbleupon
Technorati
Delicious

Pivot Tables for Fun and Profit

As the de-facto statistics guru for the association I find myself getting tasked regularly to take large amounts of data and format them in a way which is easy to understand or to identify trends in data. One thing that I have found is by and far people don’t understand or underestimate is the value in […]

Author: Mark Flavin