Feb 02, 2021
Text to Columns - First Space Only
I was recently asked how the street number and street name could be split into two cells (eg 344 Queen Street to 344 in one cell and Queen Street in another) using [...]
Oct 22, 2020
Absolute Cell References use in Formulas
Definition: In Excel, an absolute cell reference, like other cell references, identifies the location a cell or group of cells and are used in such things as [...]
Mar 27, 2021
Excel Array Formulas (Part 1)
Excel array formulas are power tools that enable you to perform operations that in many cases can’t be done with regular Excel functions. So what are array functions? In [...]
Mar 17, 2021
Background images in OneNote 2013
OneNote allows you to insert online pictures or pictures from your computer hard drive into your notebook pages. Then you can set the picture as a background, so you can [...]
Mar 09, 2021
Instant calculations in Excel
The ability to create formulas in Excel using worksheet functions is one of the applications' most important features. However, for six of these functions, it’s [...]
Feb 06, 2021
Introduction to transitions and animations in PowerPoint 2010/13
Today, I’m going to talk about two features of Microsoft PowerPoint that really make PowerPoint a distinctive part of the Office suite - transitions and animations. Both [...]
Nov 24, 2020
Comparing and combining two lists using VLOOKUPs
You may remember that in my last blog post, I talked about how to do a VLOOKUP in Microsoft Excel. Today, we are going to use VLOOKUPS to compare and combine two lists [...]
Oct 31, 2020
Doing a VLOOKUP that finds exactly what you want
A VLOOKUP in Microsoft Excel looks up and finds a piece of information in a list, a list like the one below: The V in VLOOKUP stands for vertical because you are [...]
Oct 21, 2020
Inserting an online video in Word 2013
Microsoft Word 2013 introduces a new feature which I think is pretty great: the ability to insert a link to an online video. The most likely source of the video would be [...]
Oct 17, 2020
The mystery of mail merge in Microsoft Word
There seems to be some mystery surrounding the process of performing a mail merge in Microsoft Word. People are often daunted by the thought of having to use this [...]
Oct 10, 2020
Why use section breaks in Microsoft Word?
So you just got told that you are going to have to write the next training manual for your job. No problem. Just type everything up and then print it out, right? Hold [...]
Sep 30, 2020
Customise the Ribbon in an Excel workbook
We all know how to customise the Ribbon in Microsoft Excel by using the graphical user interface, but the problem with this way of customisation is that if you move the [...]
Sep 26, 2020
Dynamic charts in Microsoft Excel
Charts in Microsoft Excel are a great way of representing data graphically, but sometimes that data is subject to change and when it does change, we need our charts to [...]
Sep 22, 2020
All about autofill in Microsoft Excel
You all agree that Microsoft Excel’s Autofill feature is one of the most popular and versatile features in Excel, however not a lot of people know about its full [...]
