Month: December 2016

How To Change A Comment Box Shape And Format

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 the comment. Hover the mouse over the edge of the comment until you see the cursor change to a four way cross with arrows at the ends. Left click with the mouse. Go to the Insert tab in the ribbon. In the Illustrations section, press the small Shapes icon. From the drop down...

Read More

How To Sum Across Multiple Sheets In A Workbook

Get The Completed Workbook 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.     In this example, we have a table of sales figures each in a separate tab named Jan through Dec. Each sheet is the same format with the table in the same position within each sheet.     If you wanted to create a Total sheet and have a table in it that sums up each of the tables in...

Read More

How To Import All Your Facebook Data With 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 Power Query is an add-in and you can find out how to install it here. In Excel 2016 it comes pre-installed under the Data tab in the ribbon and is called Get & Transform.     Create a Facebook Power Query. Go to the Power Query tab in the ribbon. Under the...

Read More

How To Insert Every Nth Row

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 record.     I realize it’s a bit of cluster bomb and I might have put a bit too much in it 🙁 To accomplish our task we’re going to need to add a helper column. Add a column to the right of your data. If the helper column...

Read More

How To Use Data Tables For What If Analysis

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 example we’ll create a data table based on the accumulated value of a bank deposit that earns interest (i.e. how much money will we have after a given time at this interest rate). Our inputs for the calculation are the principal amount, term of deposit and interest rate earned. We’ll use a data table...

Read More

Follow Us

Advertisement

Free Book

Recent Tweets

Categories

Pin It on Pinterest