Excel

Learn Excel – “Confidence Chart by Gavin Jordan at ModelOff”: Podcast #1846

               

In Episode #1845 from ModelOff, Gavin Jordan of Price Waterhouse in London shows how to create a Confidence Chart in Excel. 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 was there as a judge and took the opportunity to record(…)

Dueling Excel – “Prevent Current Sheet Name in Formula”: Podcast #1845

               

Lets suppose you’re trying to enter a simple SUMIFS Formula that points to another Sheet. Back

Trueling Excel – “Excel Mirror and Kaleidoscope”: Podcast #1843

               

In today’s Episode 144 of Trueling Excel, 7 year old ‘Excel is Funner’ tries to teach two old guys about Excel. Back

Learn Excel – “See all Pivot Items with Vlad Smirnov at ModelOff”: Podcast #1839

               

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(…)

Learn Excel – “ModelOff Elasticity with Mack Wilk”: Podcast #1836

               

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 was there as a judge and took the opportunity to record some Live Podcasts. At the ModelOff Financial Modeling Championships, I captured some live podcasts with finalist Mack Wilk. If  you remember,(…)

Learn Excel from MrExcel