Category Archives: Tech

Excel Function Cheat Sheet – Jon’s Personal Reference Page

As a huge Excel fanatic, over the years I’ve amassed a nice collection of spreadsheets; if you’ve explored this website much, I’m sure you’ve seen graphs from some of them. As part of that data crunching, I’ve also utilized a wide variety of functions and formulas to process data. I keep a master reference list of these Excel functions in

Read more

Database Fun – Art Collection

I’ve posted quite a bit regarding my love for Excel and Pivot Tables, but I haven’t actually mentioned my other source for data-crunching fun – Microsoft Access. Occasionally, I’ll come across some data structure or method of viewing that can’t be accomplished using Excel (or can’t be accomplished well). That’s when I’ll jump into database design. One example of this

Read more
« Older Entries