Excel In Depth 2013

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 – “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 – “Does Excel RATE Function work?”: Podcast #1804

               

A question from YouTube about the Excel RATE Function not appearing to work. The Function does work, but Back

Learn Excel from MrExcel