“Santa Baby” – Excel / Power Pivot Version


Santa Monica Excel Consultant Szilvia Juhasz belts out this Power Pivot / Excel version of “Santa Baby“. Follow Szilvia on Twitter @Xszil Back

Learn Excel – “Hide Values in Formula Bar?”: Podcast #1827A


Episode #1827A: Back to the Microsoft Ad: can you select a cell and not have the value appear in the formula bar? Yes. Also, a Microsoft PR guy claims the ad is Back

Learn Excel – “Is Text in ANY Column?”: Podcast #1826


Two similar questions: (1) Can I count how many Rows contain certain Text in any Column? (2) Can I Filter to only Rows that have the selected Text in Back

Learn Excel – “Too Many INDIRECT Slows Calculation”: Podcast #1824


Today Bill looks at Extreme Excel. It seems that Abhijeet took INDIRECT to the extreme – 1200 Formulas, Back

Learn Excel – “Summing for Ad Agencies”: Podcast #1823A


Good news: The new Surface ads feature Excel. Bad news: there is a Spreadsheet Error in the ad. You may read the Original Blog Post from David Yanofsky.  Back

Learn Excel from MrExcel