I'm excited to announce that I have a new Microsoft Excel course in the pipeline. I plan on having it released before the end of Oct. 2017, called... Microsoft Excel Data Analysis and Dashboard Reporting Below are the first few videos introducing the course and what you will learn. What's Included in the Course? I have designed this course to take you from raw data to a completed, interactive dashboard. I'll guide you through effective data analysis and data clean-up, includi

Its time for another CONTEST! I’ve been getting a lot of students in my Udemy courses sending me message expressing interest in taking one of the Microsoft Office Specialist exams (MOS). So, I’ve decided to run a contest to help and inspire those interested. Whether you are already planning on taking one of the exams or are currently sitting on the fence, keep reading. HOW TO PARTICIPATE Currently enrolled in my... “Microsoft Excel – Excel from Beginner to Advanced” Udemy cou

Got another great question from a student in my Excel VBA UserForms course on Udemy. QUESTION: I have built and Excel UserForm that allows users to interact with worksheets within a workbook. I don’t want the users to interact with the worksheets directly. How can I hide the worksheets from the users, but unhide them when I need to work with the worksheets? SETUP: Imagine you have an Excel workbook that contains various worksheet, one worksheet for each employee. In this exam

I just got another great question from a student in my Microsoft Excel course on Udemy. The question deals with automating a conditional check using VBA. One way to accomplish this would be create a custom function using VBA. I put together a quick video describing the process of creating a User Defined Function using VBA in Excel. Download the exercise file and try it yourself: MDABFunction-01