Tag Archives: Excel

Tips on using Excel to get a handle on large data files

Med-Studies-Excel-tipsheetIn the age of big data and large datasets available through the CDC, the NIH, and other entities, it helps to know what to do with all that information. One tool for manipulating it – especially since so much is provided in CSV files that easily open in spreadsheets – is Excel.

Consider, for example, data on vaccinations from the National Immunization Survey. The CDC has downloadable data sets going back for nearly two decades. A journalist might want to look for trends in that data, such as changes in coverage in a particular state or changes in uptake for particular vaccines. But once you get all that data downloaded, what do you do with it to look for those trends, especially if you don’t know much about Excel? Continue reading