Ideas for New Posts — Part the First

“I am not an actuary, but I play one on TV”.

I like to say this, even though it’s not true (the TV part). But I get some things about data that actuaries like to dig into that end up being fun challenges in Excel. One of the biggest learning experiences for me over the last few years has been “how to best query, organize, and analyze my_metric in the context of ‘root year’, calendar year, and ‘dimension x’ ?”

I have recently migrated my core preference from pivot table to (in Excel 2007 and hopefully later) Excel Tables, the entities formerly known as lists. Tables and structured references are not only viable replacements for the former, they have some syntactical qualities that make them superior. In the right context of course.

So, in keeping with the ambiguity of the title, “stay tuned” hah ha.

p.s. some typo fixes

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

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: