My super fit cousin Joe Perry contacted me with a few questions about an Excel spreadsheet he uses to track his running. Continue reading
Posts Tagged → offset
Allocating costs
In this post I’ll show you how to allocate expenses (or any number) over a period of time. I will use years but it could also be months, weeks or days. Continue reading
Formulas or VBA to create military code?
How do you know whether you should use Excel Formulas or Excel VBA? Sometimes both work and sometimes only one works. This series will explore this question. Let’s start with an idea from Sumit Bansal at TrumpExcel. Continue reading
Video 00073 Helping Dean Pelton with his menu in Excel
Dean Pelton has a problem.
His menu is alphabetical and has too many meatball recipes.
Watch as Bill Jelen (aka Mr Excel) helps Dean: Mr Excel helps Dean Pelton