Monthly Archives: May 2021

Microsoft Excel – XLOOKUP function – returning data from non-contiguous columns

In my recent blog on the XLOOKUP function I showed how useful it was rather than using the VLOOKUP function. When training XLOOKUP recently, I was asked if it could return data on columns that were not next to each … Continue reading

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

Microsoft Excel – adding company logo to header

When printing off an Excel spreadsheet, or indeed emailing it to a client, you may want to include your company logo as part of the header. To insert a header, click the Insert tab, then in the Text group, click … Continue reading

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

Microsoft Excel – I get the same answer in every cell when I copy my formula down

I was training Excel and we were doing an IF statement in one cell and then copied down to the other cells in that column. One in the session got the same answers for all cells though looking at her … Continue reading

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