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.
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
As and Excel table grows sometimes you may lose sight of the heading on the top or on the left, making if difficult to understand what your looking at. Excel has the ability to free panes on the top or the left to make it easy to follow your data.
If you have added a column for manual entries to a PowerQuery table you may have discovered that when you refresh the query that the manual data gets messed up. In order to keep the manual data you will need to take a snapshot of the manual data in another query and then merge that query with the new data. Here’s how to do that.
