This is a simple introduction to some Excel commands which are helpful with the large spreadsheets of medical data on the site. The commands here work in Excel 2010 and Excel 2003.
When you open an excel spreadsheet from the web, it may ask if you want to "enable editing." You'll need to say Yes to make any changes in your copy, or to "find all" entries of a certain type, or filter, or sort.
If the spreadsheet was slow to download, click File/Save As a couple times with new names, so you can get back to the original version without downloading again.
If you need extra help, many people who work in bookkeeping or finance are good with Excel spreadsheets, or you can search the web.
Basics. Most of you already know these:
Undo a Sort or anything: press Ctrl and Z at the same time. You can do this repeatedly to back up to previous versions, sometimes as far as the last time you saved the file
Save Frequently, with new names, so you can go back to previous versions if you need to.
Calculate an Average or Sum: Suppose you want Average of Column T
There are excellent articles on statistical analysis of health data in the British Medical Journal, though it requires a subscription, which you may find at a university or hospital library.
This site uses Excel, since Google Sheets are limited to 2 million cells and Open Office is limited to 65,536 rows. The files here have hundreds of thousands of doctors with 20-60 cells for each, so they need the size of Excel or QuattroPro. These instructions cover Excel, since more people have it. You can do the same work in QuattroPro.
This site does not provide
legal or medical advice.
The site does not
hospitals or anyone. It
mostly from Medicare, so
you can decide.
Dates are assigned
arbitrarily to sort
the articles. Most
articles have been
written or updated
Like: Facebook, Twitter,