“Excel”-lent Resource for Excel Tips

September 13, 2006

I’m always on the lookout for well written Excel tips for crunching large amounts of data.  Seems many of the litigators I know need to analyze large datasets.  Allen Wyatt’s ExcelTips Online is a terrific resource.  He offers a weekly e-mail newsletter, and 2 RSS feeds – Daily Nuggets and the Weekly Classic.

Check out this tip – Deriving Monthly Median Values – the example looks at sixty years worth of data and offers two strategies for finding the monthly median value.  He explains as he goes, which makes his tips even more valuable.  I believe you could take this tip and run with it to suit your needs.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: