Excel Tip - Apply borders with the keyboard

Wouldn’t it be great to be able to quickly apply a simple outline border to a cell or range in Excel without using the toolbar?  Let’s have a go, we will apply borders to each of the cells B6 through to B11 in the example below…

Excel Tip - Instantly calculate future dates

You may often need to calculate future dates in Excel based on dates that you already have.  For example, you may need to know what an invoice due date will be in 30 days but not including weekends.  Find out how, by using the WORKDAY.INTL function...

Excel Tip - Splitting single cell data into separate cells

Last time we looked at combining data from separate columns into one single cell, this time what if you have your data arranged in a single cell and you need to split it into individual columns?  Excel makes it easy, you can use the Text to Columns feature...

Excel Tip - Quick Charts

Did you know that instead of using the Insert Chart ribbon, there are two keyboard shortcuts for fast chart creation?  You can use F11 to create a full page sized chart or ALT F1 to create a chart within your worksheet...

Excel Tip - Combining Data in Separate Cells

Sometimes data that you are working with isn’t always laid out as you need it to be.  You may have information in separate columns, that you need to combine into one cell.  In this example we will show you how to do just that...