Excel isn’t the best way to store a large database but it’s a great way to sort, filter, analyse, chart and PivotTable from it. Here’s the best way to import and update a large database into Excel. The standard way to store a list in Excel is to import CSV’s or other data into a […]
The UK has been embarrassed (again) with the news that around 16,000 COVID-19 test results were missing from the official database and so contact tracing wasn’t done. The culprit? Excel. Or, to be fair, bad use of Excel is to blame. Not understanding it’s limits and how to workaround them. We’ve tried to figure out […]
A strange name but Sparklines is a useful new part of Excel which makes simple single-cell graphs in Excel for Windows or Mac. Mea Culpa – we thought that ‘Sparklines’ was a fancy name made up by Microsoft after a long liquid lunch … Office Watch readers, John F, Nick M and Peter B all […]
Microsoft has finally confirmed what was long suspected. There will be another fixed price, perpetual licence version of Microsoft Office. The successor to Office 2019 will be released in late 2021 for Windows and Mac. Update in late 2021: of course we now know it’s called Office 2021 All about Office 2021 for Windows & […]
There are several ways to fill in a PDF form and add your signature with Microsoft Word, Acrobat Reader or online services. All these tips are free with nothing to pay. It’s possible to ‘sign’ a PDF form and return it without making a paper copy. Paper forms are so 2019 <g>. There’s no need […]
