So Long as There’s Small Business, There Will Be Small Data (and Excel)

This week, with a little time off between semesters, I’ve been helping a family member with financial reporting & analysis for his business. It’s been over a year since I worked in finance and this exercise reminds me how frustrating this can be and how critical a strong command of Excel is to modern data […]

Grouping PivotTable Data by Week

I must admit, my Excel use has declined significantly since returning to school full-time. But, I still find plenty of uses – and, because they are not my routine office tasks, sometimes they are more interesting and I have more to write about. This one comes from a project I am helping a family member […]