Category Archives: Microsoft Excel 2013

Microsoft Excel Pivot Tables – Preserving formatting when refreshing

I had a client who found that she had spent time getting column widths to her satisfaction when she had created a pivot table. However as soon as she refreshed the data the column widths changed, which she found annoying. … Continue reading

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

Microsoft Excel – month name from a date

I was at a local client earlier this week – face-to-face training at last after so much time. They had entered dates in two columns – one for months and the other for years. Since they wanted to be able … Continue reading

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

Microsoft Excel – RAG icon sets

I had a client who had typed in as text, R, A or G depending on whether a certain indicator should be classified as Red, Amber or Green. They then wanted to use conditional formatting to show the relevant colour … Continue reading

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

Microsoft Excel – including a date in a text string

There are occasions when you may want to include a date in a text string in Excel. The method shown here is slightly convoluted but it does work! If my original date is in cell A4 (I used the =TODAY() … Continue reading

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

Microsoft Excel – putting two or more charts on same sheet

To put two or more charts on to a single chart sheet: Click an empty cell, and press [F11] (or Fn + F11 depending on your laptop. Change the default chart name to Two Chart Sheet (or some other suitable … Continue reading

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

Microsoft Excel – using Sparklines

Sparklines are small charts of data placed within a single cell within a worksheet. There are three types of sparkline charts: Line – shows trends and changes in values over time Column – allows comparison in values Win/Loss – allows … Continue reading

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

Microsoft Excel – Creating timetable by adding minutes to time

I was asked by someone who was creating a timetable for music exams how to get Excel to calculate the next exam time, knowing how long the exam would take – for Music Grade exams depending on the Grade and … Continue reading

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

Microsoft Excel – VLOOKUP giving n/a though looks like cells match

A client recently asked me to look at their Excel workbook where a VLOOKUP was showing N/A all down the column. I could see that some of the cell references did indeed appear to be there in the table array … Continue reading

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

Microsoft Excel – using conditional formatting to highlight upcoming renewal dates

A client has employees who have to renew various work certificates every 3 years. If you have a lot of employees it would help to see when renewal dates were approaching. This can be done by using Conditional Formatting in conjunction … Continue reading

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

Microsoft Excel – VLOOKUP showing formula rather than result

I received a workbook from a client the other day. The first thing I usually do when I receive someone else’s workbook is to display the formulas to quickly see what is raw data and what are formulas. (To do … Continue reading

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