Tag Archives: excel tip

How to Use Consolidate Data in Microsoft Excel

If you have data spread out over multiple workbooks or worksheets you might want to have them all in one place on one sheet. Rather than having to copy and paste you can do this using the Excel feature Consolidate … Continue reading

Posted in Excel, excel data | Tagged , , , , , , , , , | Leave a comment

How to Use Excel Flash-fill

Excel has many wonderful features but this is one of my favourites. Its called Flash-fill. It might be easier to watch the video but will try and explain it. If you have a list of data and need to say … Continue reading

Posted in Excel, excel data | Tagged , , , , , , , , , , , , | Leave a comment

How to Remove Duplicates in an Excel List

If you have created lists in Excel you might have thought to check if it has any duplicates. It could be data you’ve imported or data that has been entered. Perhaps you have shared the spreadsheet and you want to … Continue reading

Posted in Excel, excel data | Tagged , , , , , , , , , , | Leave a comment

Excel’s Newest Function XLOOKUP

VLOOKUP and HLOOKUP are two popular functions in Excel and a new one has come along to replace them, don’t worry they haven’t gone away. The new function is XLOOKUP it is easier to use and has some additional features … Continue reading

Posted in Excel, excel function, Microsoft Office | Tagged , , , , , , | Leave a comment

Copying Excel Data into a Word Document

If you use both Excel and Word you may well want to copy data from Excel into Word and what would be really convenient is if the data in Word updated when you change it in Excel. Well that is … Continue reading

Posted in Excel, microsoft word, productivity | Tagged , , , , , , , | Leave a comment