Everyday Office

Follow Everyday Office
Share on
Copy link to clipboard

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.

Neil Malek


    • Jun 29, 2020 LATEST EPISODE
    • infrequent NEW EPISODES
    • 26m AVG DURATION
    • 7 EPISODES


    Search for episodes from Everyday Office with a specific topic:

    Latest episodes from Everyday Office

    Episode 007: Dynamic Array Functions with Alan Murray of Computergaga

    Play Episode Listen Later Jun 29, 2020 28:36


    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

    Episode 006: Dirty Data with Melissa Esquibel

    Play Episode Listen Later Jun 15, 2020 30:36


    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

    Episode 005: Working Smarter AND Harder

    Play Episode Listen Later Jan 27, 2020 20:11


    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.

    Episode 004: Excel Disaster Recovery with David Ringstrom

    Play Episode Listen Later Jan 20, 2020 37:58


    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

    Episode 003: Effective Presentations with Design Principles and the Morph Transition

    Play Episode Play 46 sec Highlight Listen Later Jan 13, 2020 25:13


    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

    Play Episode Play 28 sec Highlight Listen Later Jan 6, 2020 30:08


    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.

    Episode 001: Introduction and Using OneNote

    Play Episode Play 38 sec Highlight Listen Later Jan 1, 2020 14:27


    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

    Claim Everyday Office

    In order to claim this podcast we'll send an email to with a verification link. Simply click the link and you will be able to edit tags, request a refresh, and other features to take control of your podcast page!

    Claim Cancel