
Alan Murray is a trainer, consultant, and community leader in Excel and Power BI. His resource site, https://www.computergaga.com/, and YouTube channel, https://www.youtube.com/computergaga, are some of the most valuable and respected on the Internet. In this conversation, we explore the benefits and possible use cases for a new suite of Excel functions - the Dynamic Array Functions. These functions - UNIQUE, SORT, SORTBY, FILTER, SEQUENCE, and RANDARRAY - work differently than any other function you've used before, and they represent a HUGE leap forward.To see Alan in action as a trainer, check his playlist of tutorial videos about Dynamic Array Functions: https://www.youtube.com/watch?v=X2ybRZbvR5k&list=PLxv7tqbNjU9WP3oMeRKwNXwDYQilKjF-sEnroll in Computergaga's excellent online courses at: https://www.computergaga.com/online-courses/Contact Alan directly at: [email protected] questions about the show, contact Neil at [email protected]
Jun 29, 2020
28 min

Melissa Esquibel is a Microsoft Certified Trainer, consultant, and author. She has a unique ability to make learning programs enjoyable AND valuable. She offers classroom, conference, and online presentations, as well as content development, team and individual coaching, and project consulting for most office productivity platforms.She recently wrote an Excel-focused data guide called Dirty Data: https://www.melissaesquibel.com/dirty-data/ - that is focused on 'cleaning up' data before analyzing it. If you'd like to talk with her about customized training or consulting, visit https://www.melissaesquibel.com/For questions, please email [email protected]
Jun 15, 2020
30 min

While the software trainer's mantra is typically "Work Smarter, Not Harder," in this episode, Neil Malek of Knack Training explores the idea that we should work smarter and harder. By automating what we can - through rules, quick steps, etc. - and working harder on those things that can't be automated, we can create more impactful and human work.In this episode, Neil recommends the book Linchpin by Seth Godin.Email [email protected] with questions and follow-up.
Jan 27, 2020
20 min

David Ringstrom is an Excel trainer, consultant, and author, and a CPA. Over 25 years, he's developed a suite of tools and best practices that save him from crashes, collaboration issues, and other disastrous situations with his spreadsheets. In this conversation, we talk about setting up files properly, customizing settings in Excel, and using tools like Power Query to prevent issues in the first place.David’s calendar is online at www.davidringstrom.com if you’d like to talk to him about customized Excel training or spreadsheet consulting work for any organization. Or, if you’re an accounting educator, please visit www.studentsexcel.com to learn about Excel training exercises customized to match the material you're teaching in class. Email questions to [email protected]
Jan 20, 2020
37 min

An effective presentation is one that engages the audience, aligns them, and motivates them to create a positive change. In this podcast, Neil Malek discusses the simple design principles that make your message clear and focused, as well as the PowerPoint technique that helps create a story thread in your audience's head.Morph Transition tutorial can be found on YouTube.
Jan 13, 2020
25 min

Melissa Peoples is a productivity and organization expert who coaches and trains executive assistants. By building a framework of communication, organization, and automation, she helps executive teams become stunningly productive and effective. In this episode, we discuss creating productivity road maps, time boxing your calendar, and Outlook tools and techniques for finding your personal best practices.Find Gamestorming on Amazon. Listen to 2Bobs on your favorite podcasting app. Watch Melissa's timeboxing video on YouTube.Find Melissa at her website, LinkedIn, Twitter, and YouTube.Melissa's tour dates and locations can be found on her website. The EA Revolution Summit includes speakers Bryan Rose, Sheena Hubbard, La Donna Finnels-Neal, and of course Melissa Peoples.
Jan 6, 2020
30 min

Neil Malek, a software instructor and consultant, introduces the Everyday Office podcast, and recommends that listeners use OneNote for business and personal note-taking. OneNote integrates seamlessly with Microsoft Office, SharePoint, and Teams, and is accessible through the desktop app, online service, or mobile apps.Install OneNote 2016 using the Microsoft website. Watch the YouTube tutorials from Everyday Office about using OneNote for various purposes.Get a new email address from Microsoft to get OneDrive Personal.Install the OneNote Clipper plug-in for your browser.Q&A: [email protected]
Jan 1, 2020
14 min