Sometimes a Pivot Table is an intermediate step on the way to something bigger. ModelOff finalist Vlad Smirnov is creating a reserve booking for risky loans at a bank. His SumProduct ModelOff ModelOff is a worldwide championship for financial modelling in Excel. 16 finalists were flown to NYC in December 2013 to compete head-to-head. I(…)
Today Bill looks at Extreme Excel. It seems that Abhijeet took INDIRECT to the extreme – 1200 Formulas, Back
Let us suppose that you have serial numbers like “AA10D”, “AA11D” and what you’d like to do is quickly fill Back
Today, in Duel 142, we start back in Excel 2003 to create an Average by each Category that will work Back
Baseball Statistcal Averages and Microsoft Excel – on The Same Team.