I’ve added a number of excel tutorials to the NHS Excel website and this will become the home for most of my excel related content.
It’s been a busy month at work due to year end and the agreement of balances exercise but its been interesting from an excel point of view. We’ve had to work across a departments and this has thrown up a number of issues, not least of which has been the problem of people using different versions of excel to work on a single workbook. This month I’ve written a tutorial explaining how to force Excel 2007 to work in compatibility mode so that you can create pivot tables that work in earlier versions of excel.
I’ve also written some VBA code to automate log-ins to password protected websites. The idea of this is to use in conjunction with a website query to download data from a central NHS website to a spreadsheet on a regular basis.