Category Archives: Microsoft Excel

Microsoft Excel – the IFS function

Are you using Office 365? If so, instead of a nested IF, you can use the new IFS function. Consider the example below: We would generally use a nested IF to work out the exam score, the formula being: =IF(B2>80,”A”,IF(B2>70,”B”,IF(B2>60,”C”,”FAIL”))) … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Office 365 | Tagged , , | Leave a comment

Microsoft Excel – working out school year from date of birth

School years run from September to August, so in general it depends on both the month that a child is born in as well as the year. So if you have a list of dates of births and need to … 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 – conditionally formatting a whole column range if any cell in that column is blank

This is a question that we were posed at training recently. First select the data area to be formatted. In the example here, I have selected B2:D7. Then on the Home tab, in the Styles group, from the Conditional Formatting … Continue reading

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

Microsoft Excel – using icon sets to compare two sets of figures

If you are looking at data over time, you often want to see visually whether numbers have gone up, down or remained static. Create a third column to show the difference between the two sets of data, in this case … Continue reading

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

Microsoft Excel – copying and pasting between two filtered workbooks

I was at client site yesterday and one learner said that they were having great difficulty copying and pasting information between two filtered workbooks. I said he should use Find and Select – Go To Special – Visible cells only … Continue reading

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

Microsoft PowerPoint – inserting several pictures all same size

When working with Microsoft PowerPoint, you may want several pictures on a slide to all be of the same size. Insert your first picture, then on the Picture Tools Format tab, in the Size group, select your required size, or … Continue reading

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

Microsoft Excel – keeping original column widths when pasting data

Sometimes you spend a lot of time and effort getting the columns on a worksheet to the exact widths that you want and then need to copy and paste the data elsewhere. The last thing you want is to then … Continue reading

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

Microsoft Excel – quickly unhide all columns or rows

If you have hidden multiple rows or columns in Excel, it can take a while to work out what you have hidden to unhide again. It is also hard to work out how to unhide column A or row 1! … Continue reading

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

Excel 2016 – Forecast Sheet

New in Excel 2016 is the Forecast Sheet capability which you will find on the Data tab in the Forecast group. This looks at past data and the trends within it, to allow you to forecast what is likely to … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – I’ve hidden column A – how can I get it back?

When you are working with Excel, you sometimes hide rows or columns but may well want to unhide them again. As long as it is not column A or Row 1 you have hidden – it is very easy – … Continue reading

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