Excel Top 10 | #10 – VLOOKUP with Two Variables

Learn how to quickly find the intersection of a row and column in a dataset. Episode 10 of the Excel Top-10 series by PowerConcepts.

MS Excel – Use Filters to Create Reports

Do you need to create reports in Microsoft Excel 2010? Check out this quick video explaining how to use Filters. You can find more great Microsoft Office 2010 video tutorials on our channel, and even more at www.powerconcepts.ca

MS Excel – Creating a Basic Macro

What is a macro in Microsoft Excel 2010 and when should I use one? Answer that question and more with this instructional video on how to create, save, and find a basic macro in Microsoft Excel 2010. More great videos and courses on Microsoft Office 2010 programs are available on our Powerconcepts website: www.powerconcepts.ca.

Excel 2016 Power Query Get Data From Folder

This short video will show how to use power query tool to set up the steps to get data from a folder which is constantly added with monthly files