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.
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-s
Enroll in Computergaga's excellent online courses at: https://www.computergaga.com/online-courses/
Contact Alan directly at: email@example.com
For questions about the show, contact Neil at firstname.lastname@example.org
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 email@example.com
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 firstname.lastname@example.org with questions and follow-up.
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 email@example.com
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.
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.