Created with Sketch.
29 minutes | Jun 29, 2020
Episode 007: Dynamic Array Functions with Alan Murray of Computergaga
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: firstname.lastname@example.orgFor questions about the show, contact Neil at email@example.com
31 minutes | Jun 15, 2020
Episode 006: Dirty Data with Melissa Esquibel
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 firstname.lastname@example.org
20 minutes | Jan 27, 2020
Episode 005: Working Smarter AND Harder
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@example.com with questions and follow-up.
38 minutes | Jan 20, 2020
Episode 004: Excel Disaster Recovery with David Ringstrom
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 firstname.lastname@example.org
25 minutes | Jan 13, 2020
Episode 003: Effective Presentations with Design Principles and the Morph Transition
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.
30 minutes | Jan 6, 2020
Episode 002: Productivity Road Map with Melissa Peoples of Admin Gurus
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.
14 minutes | Jan 1, 2020
Episode 001: Introduction and Using OneNote
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@example.com
Terms of Service
Do Not Sell My Personal Information
© Stitcher 2022