by John MacDougall | Dec 30, 2016 | Tips
The default comment box in Excel is pretty plain, but you can change the shape, colours, fonts and borders among others things to make them stand out. Enter the comment format editing mode by clicking on the comment and you will see small squares around...
by John MacDougall | Dec 29, 2016 | Tips
If you’ve ever had to sum up items across many different sheets, then you know it can be a real pain when there are a lot of sheets. This trick will make it super easy. Get the example workbook with the above link to follow along. In this example, you have...
by John MacDougall | Dec 28, 2016 | Power Query
Did you know Excel can import your Facebook data? If you have a Facebook page or personal profile you can easily import your data with Power Query to gain valuable and interesting insight about your friends and followers. Just a reminder, that in Excel 2010 and 2013...
by John MacDougall | Dec 27, 2016 | Tips
Follow Along With This Workbook If you ever need to insert multiple blank rows into your data, doing it manually could be very time consuming if you have a large data set. Here’s a quick way to do this by inserting a blank row into your data after every Nth...
by John MacDougall | Dec 27, 2016 | Tips
Get The Completed Workbook Not to be mistaken with Excel Tables, Data Tables are a tool that can be used to do “what if” type analysis and allows you to see the results of a calculation while varying up to two of the calculation inputs. In this...