Excel 2013

Learn Excel – “Within +/- 1 is a Hit”: Podcast #1815

               

It is Hit or Miss today at the MrExcel podcast, literally. The question is how to Label a Value as a ‘Hit’ if it falls Back

Learn Excel – “8 Ways to Paste Values”: Podcast #1814

               

At my Fort Myers, Florida Power Excel Seminar, someone showed me a new way to Paste Values. Back

Learn Excel – “UDF Rollover Jordan Goldmeier”: Podcast #1813

               

Excel MVP Jordan Goldmeier stopped by yesterday for a guest appearance on the podcast. Traditional rules say that a User Defined Function is not allowed Back

Learn Excel – “Increment Invoice # OCT13001”: Podcast #1812

               

Rupesh asks how to increment an invoice number in the form of YYMMM001, where the 001 Back

Learn Excel – “Adjust Formulas Yearly “: Podcast #1811

               

Stacy has to adjust formulas every year so they average the last five years of figures. Episode #1811 offers several techniques Back

Learn Excel from MrExcel