Please log in to continue
Principal at Knack Training
Neil Malek is a software instructor and consultant who partners with businesses and organizations to identify and close skill gaps, making their teams more effective and efficient. After twenty years of teaching, he believes that fun, real-world practice is the most functional way to build a practical skillset. With clients like Ernst & Young, Lockheed Martin, and the Chicago Bulls, he has consistently delivered the most impactful, high-energy, and enjoyable courses those businesses have offered their workforce.
Neil is Principal at Knack Training, a US firm focused on Microsoft Office, Power BI, and collaboration with Microsoft 365.
The critical starting point for a successful spreadsheet is clean, accurate, and up-to-date data. The most effective and fastest way to accomplish this task is with one of Excel’s newer features – Power Query.
With Power Query, we can clean up a spreadsheet (or CSV, or PDF) that has huge problems. We can automate getting the latest version of data from a standard location. We can even combine dozens of files together in seconds. Power Query is easier to use than macros!
Learning Outcomes
Microsoft 365 is the modern cloud collaboration suite that includes SharePoint, Teams, and several other applications. What many people miss is that these applications can be integrated seamlessly and easily to solve complex problems.
In this session, the complex problem we’ll solve is project management. Project management includes planning, putting the plan into action, and measuring progress – and each of these stages can be handled by Microsoft 365 applications working together.
Learning Outcomes
Microsoft Teams and the other Microsoft 365 applications are flexible tools that can be tweaked, integrated, and customized in hundreds of ways.
Learning Outcomes
In this session, you will learn how to optimize Teams for your daily use:
If you’ve ever spent hours – or perhaps days – ‘cleaning up’ a document, spreadsheet, or presentation, this session is for you. There are incredible tools, tricks, and shortcuts in each of the major Office applications that can resolve complex problems in seconds, if you only know how to use them. In this 90-minute block, we’ll handle formatting, layout, and even the dreaded ‘dirty data.’
Topics include:
(90 minutes)
Many professionals are chained to their inbox – every new email has to be handled at that moment. Managing the flow of information through the inbox, and ultimately being able to retrieve it, act upon it, and share it appropriately, is exhausting. There are several tools in Outlook that, used effectively, can create an elegant, automated organizations system.
(60-180 minutes)
There are so many places where Outlook comes up short – finding important information later, keeping robust meeting minutes connected to the meeting details, providing rich detail for contacts and assignments you work on throughout your day – and OneNote makes each and every one better.
OneNote is a free application you can install on every device you own, and access essential information in seconds from anywhere – and hardly anyone uses it!
(60-180 minutes)
Whether you’re an executive, an administrator, an accountant, or a business analyst, everything works better when you use Excel the way it’s meant to be used. Nearly all our headaches with a spreadsheet can be tied back to sloppy data and poor navigation of the file. In this session, we focus on best practices around data layout, building a smart spreadsheet, and simple shortcuts that shave minutes of work every time we open a file. Not only that, but we can make our spreadsheet bulletproof by preparing it properly.
(60-240 minutes)
In the three essential Office file-creation programs (Word, Excel, and PowerPoint) there are a set of tools and best practices that can shave hours off your workload every week. By either preparing the documents properly ahead of time, or using some quick-fix tools after the problems arise, our files can be clean, consistent, and professional – with very little effort on our part.
(120-240 minutes)
If you’re going to bring an audience together to watch a live presentation, there had better be a return on that investment. Our PowerPoint presentations tend to bore audiences to tears, but that’s not PowerPoint’s fault. PowerPoint has incredible features that can be brought together in an almost infinite set of combinations, to make our presentations truly compelling.
(60-180 minutes)
Thank you so much, Neil. I’ve found your videos and website resources so informative and helpful. Sadly, when I’ve felt I needed something more or different I’ve tried to find books but they never seem to be worth the money I pay for them. With all sincerity, your straight-forward, comprehensive approach tops any resource I’ve found to date! Thank you so much for your help!
If there was ever a person put on this earth to teach you how to use all your software and make you feel you can do it easily, then it is Neil. Calming, reassuring, and patient, as well as really smart!
Professional development instructor Neil Malek of Knack Training presented to a full house at the June Technology Forum. His subject, Techniques for Maximum Effeciency, drew one of the largest crowds since the forum’s inception.
Neil is an absolute pleasure to work with. His extensive knowledge of various technologies illustrates his value as an instructor, and Neil never hesitates to spend time working with us individually.
Neil Malek has gotten the highest marks of any instructor that has taught here at SRI. They said he was phenomenal.