How to make one Word document appear in another document by linking or embedding. A Word document can be placed inside another so it appears in the second document. This can be done as a ‘one-off’ insertion or a linking where changes to the source document automatically appear elsewhere. For example is a company’s ‘Terms […]
Another way to enter lists in Excel, why Microsoft’s effort sucks and an alternative. Excel has two ways of typing in data, there’s the usual direct entry into the worksheet or you can make a form with a single click of a button. For example here’s a ‘typical’ Excel list: And here’s the same list, […]
It’s easy to make an Excel list into an HTML table. Excel has great list making features. It’s often the best way to manage a simple list or database. There’s features for sorting, filtering, auto-complete and calculated fields. But using the finished list isn’t always obvious, especially if you want to use an Excel list […]
Free training manuals for Office 2007 and before plus Quick References for Office 2010. Mouse Training in the UK has released their training manuals free for all comers plus some Quick Reference Guides. The Training Manuals are for Office 2007, Office 2003, Office XP (2002) and Office 2000. They cover Word, Excel, PowerPoint, Outlook, Access, […]
There are several built-in ways to export Access data to Excel. There are several built-in ways to export Access data to Excel. You can use the Excel button on the Ribbon (or toolbar) to export a report (or other object) to Excel, or the TransferSpreadsheet method in code, to transfer data from the report’s record […]