Category Archives: Microsoft Excel 2003

Microsoft Excel – Mac keyboard shortcut for absolute cell references

If you are using a PC or Windows based laptop, you can make an Excel cell reference absolute (or fixed) by pressing the F4 function key on the keyboard after the cell reference. The equivalent if you are using a … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , , , | Leave a comment

Microsoft Excel – finding process date using working days from end date

If I have a date in which an order has to be sent and I know the number of working days that it takes me to process the order, I may want to find out when I need to start … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , , | Leave a comment

Microsoft Excel – third working day of every month

Someone asked me recently whether they could produce a series in Excel to find out the third working day of every month. To be honest, it may be as easy to do this manually as you still need to input … Continue reading

Posted in Uncategorized, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – width of columns in charts

I was working with a client the other day creating column charts of data where the horizontal axis was made up of dates. We wanted to make the columns wider, but trying to format the data series to change the … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013 | Tagged , | 1 Comment

Microsoft Excel – inputting mobile numbers in a specific format

I was recently asked how to get mobile numbers in the format XXXX XXX XXX in an Excel worksheet. The answer is leave the column in which the mobile numbers are to be input formatted as General. Go to the … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010 | Tagged , , | 2 Comments

Microsoft Excel – changing time from 1400 to 14:00

Sometimes we are given a column of times in a worksheet but they don’t look formatted as we went them to be, e.g. 1400 instead of 14:00. If the times are as shown in column A above, we need to … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013 | Tagged , | Leave a comment

Microsoft Excel – making a PivotChart static

A PivotChart is connected to the PivotTable used to create it so every time you make a change to the PivotTable, the PivotChart automatically changes too. There are occasions when you might not want your PivotChart to change, i.e, you … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – using named cells instead of absolute cell references and updating formulas based on them

Recently I was training a group of people who had large workbooks with a lot of formulas containing absolute cell references. I taught them how to name cells which not only saves the need to use absolute cell references but … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – showing the Field List in a PivotTable in alphabetical order

By default, when you insert a PivotTable into an Excel workbook, the field list is shown in the order of the column headings in the original data set. I was working at a clientt site recently where there were numerous … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – The RANK, RANK.AV and RANK.EQ functions

The RANK function in Excel ranks numbers in order. In this example, people have scored their favourite film personalities, and I want to rank those personalities in order of preference. The RANK function had to be used for ranking in … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment