Everyday I take some time to get through the questions I get in my online courses. I enjoy getting questions for a couple of reasons. Asking questions means that the person asking is learning. I get to make more videos!! I'd like to share one of the questions that I've been asked a lot. It deals with working with a list of Excel data, creating formulas summarizing the data and then filtering the list. In the above example, we have a formula in cell I4 that SUMS up the Total S

Excel has a few different ways to import data from various sources, including web content. If you visit the DATA TAB, found within the Excel ribbon, you'll find various import features. The GET & TRANSFORM tools provide a quick, easy and powerful method of importing data. But, when dealing with web content, you may find using a little VBA magic is better suited to extract the data you are looking for. Below you will find a quick introduction to using Excel VBA to scrap data f

Microsoft recently announced a handful of new Microsoft Excel Functions. And, they are blowing my mind!! "Note: September 24, 2018: The FILTER function is one of several beta features, and currently only available to a portion of Office Insiders at this time. We'll continue to optimize these features over the next several months. When they're ready, we'll release them to all Office Insiders, and Office 365 subscribers." ~ Microsoft For more information on the function, visit