Excel 2013 In Depth

Learn Excel – “Nested Functions with fx”: Podcast #1831

               

Rob asks for tips on entering Nested IF functions in Excel. Today in Episode #1831, Bill shows us how to use the Function Arguments dialog box to assist. Back

Learn Excel – “Use Solver with VBA”: Podcast #1830

               

Haizen has to arrange transport for ‘N’ employees where ‘N’ can be 1 to 500. There are three types of vehicles available with different capacity and different cost. He wants a Formula for 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 – “Show Mean on Bell Curve – 5 Ways”: Podcast #1825B

               

An addendum to Episode #1825 – several easier ways to add a line at the Mean of a Bell Curve using a Drawing object, Back

Learn Excel – “Add Mean to Bell Curve”: Podcast #1825

               

Several comments on the ‘Learn Excel from MrExcel’ Podcast Series Episode #1663 asked how to add a Mean to the Bell Curve Chart. Today the Episode #1825 Podcast shows us Back

Learn Excel from MrExcel