Learn how to add colour, borders and alignment settings to your Excel data to give your worksheet a more professional look and to make it easier for others to read. Read more
Formatting lets you change the appearance of data to control exactly how Excel will display the data on a worksheet.
An example of formatting is to add dollar signs, percentage signs and decimal places to Excel data. Read more
Once you know how to enter data into an Excel worksheet you will be setting up tables of data in no time.
When you haven’t been shown how to enter data it can be a little tricky, so follow the steps below to learn the tips and hacks to entering your data easily into your worksheet. Read more
Ever tried to centre a heading over the top of a number of columns? It can be a little frustrating, especially when you can’t quite get it to sit as you would like. Last month saw me running multiple Stage 1 Excel courses and it reminded me that this problem frustrates so many. I love hearing the “oh wows” when I show the class how the Merge and Center command allows you to easily centre headings over tables of data. Read more