In this episode Bill Jelen (Mr. Excel) joins Mary Schaeffer for an episode that is both entertaining and educational. Jelen includes many behind-the-scenes anecdotes related to the creation of certain Excel features. The begins with a humorous tale of how Bill got started on the road to becoming Mr. Excel. It started when his boss bought an expensive piece of reporting software (for $100,000) that didn’t work. And, so Bill downloaded the information from the ERP system using the expensive software and then did all the analytical work in Excel.

He also regales the audience with tales of the annual meeting Microsoft has with a group of authors, like himself. He shares that while the authors enjoy the meeting, the programmers – not so much. He then launches into the meat of the podcast, demonstrating to the audience how they can use three often overlooked features in Excel, specifically, Filter by Selection, Get & Transform Data, and the New TextJoin or Concat Functions features.

The features are explained using accounting and accounts payable examples and are easily understandable. There is something for both the Excel novice and the Excel expert. This is one episode you will probably want to listen to more than one time.

Host: Mary Schaeffer (www.ap-now.com)

Guest: Bill Jelen (https://www.mrexcel.com/)

Sponsor: Stampli (www.stampli.com/APNow)

Credit: Music: https://www.purple-planet.com