Category Archives: Training


XLOOKUP Webinar

XLOOKUP is the next-gen lookup function designed to address the limitations of VLOOKUP and related workarounds. It combines the capabilities of numerous functions including VLOOKUP, INDEX, MATCH, HLOOKUP, and IFERROR. Many have asked me to teach this via webinar. So, I created this short webinar that covers the basics πŸ™‚ This on-demand webinar is about […]






Gamification 1: Story Mode

This is the first post in a new Gamification + Excel Training series, where we’ll talk about how gamification is used to motivate students to learn Excel. What is gamification? In summary, it is the use of game design and mechanics to help people achieve their objectives. It is applied in many areas today, from […]


Excel Tips from 18 Experts

My Excel-friend John Michaloudis has compiled a podcast with tips from 18 Excel experts and MVPs. He does this annually, and this year he has put together a great collection of tips. This year, you’ll hear tips from: John Michaloudis Jeff Lenning Bill Jelen Mynda Treacy Chandoo Kasper Langmann Alan Murray Jon Acampora Danielle Stein […]



Excel Breakout Puzzle 7

The next Excel breakout puzzle is ready! And it’s a goodie πŸ™‚ I realize fall doesn’t officially start for a few weeks, but, our kids start school next week and so it already feels like fall is upon us. Fall means back-to-school, cooler weather, falling leaves, and … american football. My son plays, and so […]