breadcrumbs trail / matzo meal

I think it's a best practice to design ALL spreadsheets as if they will be manipulated by other people, which means leaving a strong "breadcrumbs trail" of your assumptions, formulas, variables, data sources, and more. In my case, it's a matzo meal trail until tomorrow evening when Passover ends and I will devour pizza with all my might!

encountering a real, live Excel bug

I think I stumbled upon an Excel "bug" (gasp!!) when I was combining SUMIF formulas plus sorting alphabetically. @___@ This is a new one, grasshoppers and honeybees! Sit down, buckle in, and enjoy the ride - we're gonna get technical with some formulas and explore what to do when you get real confused.

strawberry shortcut cake

I wanted to share a set of tips that could supercharge ANY spreadsheet maker's work.  So what could be better than SHORTCUTS?  For repetitive functions, selecting cells, and navigating around a spreadsheet, keyboard shortcuts will make a heck of a difference. Here are 5 Excel shortcuts you shouldn't live without!