A number of excel tutorials have been added to the NHS Excel website.
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.
The ExcelPivots website has also been launched and although it is early days there are a few tutorials there including one on how to base pivots tables on expanding ranges.