Everyday Office is a podcast about making tedious work less tedious, and interesting work more interesting. Set at the intersection of software and people, we use tools, shortcuts, best practices, and productivity hacks to make you amazing at what you do.
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: admin@computergaga.comFor questions about the show, contact Neil at help@knacktraining.com
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 help@knacktraining.com
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 help@knacktraining.com with questions and follow-up.
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 help@knacktraining.com
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.
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.
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: help@knacktraining.com