Tag Archives: microsoft office

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

Microsoft Access: How to Use the Append Query

So you’ve imported some data into your Microsoft Access database and now need to add that data to an existing table. It would be handy to copy and paste but using an append query does the trick and you can … Continue reading

Posted in Microsoft Access, Microsoft Office, Office 2010 | Tagged , , , , | Leave a comment