Month: January 2017

Go To Special

The ‘Go To’ and ‘Go To Special’ functions can help you audit your worksheet and also act as a tool to update values and make changes to your spreadsheet with the minimum fuss.   From the Home tab, they can be accessed under ‘Find & Select’ from the Editing group.     There are also Read More …

Play audio on Microsoft Excel

A little known, quite funky Application command in VBA is to set your spreadsheet to talk to you. You can either input a fixed message like the example below, or use strings to trigger Excel to speak out loud the contents of a cell on a particular event.     Application.Speech.Speak “Have a nice day”

Data cleansing functions

When you import data from an external source, you will often find it isn’t in a desirable format for you to analyse. You will need to clean your data up first and thankfully there are lots of in-built Excel functions which can help.     CLEAN can be used to remove non-printable characters you’ve imported. Read More …

Power BI add-ins

What is BI? BI, or ‘Business Intelligence’, is the generic term for the process of transforming data into meaningful information to increase understanding and awareness around a business and help management to make informed decisions.   In recent years corporate organisations have really started to see the value in developing their Business Intelligence. Whether the Read More …