The IRE Resource Center is a major research library containing more than 23,250 investigative stories — both print and broadcast. Add to that more than 3,000 tipsheets from our national conferences on how to cover specific beats or do specific stories and you have a resource that no reporter or editor should be without. These stories and tipsheets are searchable online or by contacting the Resource Center directly (573-882-3364 or rescntr@ire.org) where a researcher can help you pinpoint what you need. Browse or search the tipsheet section of our library below. Logged-in members can view the tipsheets free online:
Search results for "pivot tables" ...
-
Welcome to the world of data: Now what do you do?
Herzog gives great tips on what to do with your data once you have it, including how to get to know your data, how to clean it, how to keep it simple and where to look for story ideas (IRE's Resource Center, of course!).
Tags: data; resources; cleaning data; pivot tables
-
Importing data using the Microsoft Excel Import Wizard
Importing data into Microsoft Excel will enhance your reporting by allowing you to do original, in-depth analysis on a variety of different types of information. It's fortunate that Excel can accommodate multiple data formats so you can do basic or complex sorts, filters, pivot tables and more. In this lesson you’ll learn about different data formats, how to identify a format, which ones are Excel-friendly and how to get them into Excel.
Tags: data; excel; import; text file; comma-separated value; database format; html; access file; pdf
-
Moving from Excell 2003 to Excel 2007: Welcome to the Ribbon
Dowdell discusses the changes between Excel 2003 and Excel 2007. Basic differences in the layout of the programs, and the introduction of the "ribbon" are addressed. "The "Ribbon" is what Microsoft is calling this new interface. It has gotten rid of the menus and added a series of tabs." Dowdell discusses where to find and how to use different fucntions in the 2007 version of Excel.
Tags: Excel 2003; Excel 2007; ribbon; pivot tables; filtering; sort; sorting;
-
From Database to Story - A Step-by-step Guide
Harbord and McKie show how you can utilize OSHA data to tell the story of workplace safety in non-traditional industries such as healthcare, schools (e.g., violence) and business (carpal tunnel syndrome). Their tipsheet walks you through the process of analyzing the data. And how to compare this information to other data sets to obtain a more complete sense of "the story."
Tags: data; database; OSHA; query; NAICS; excel; pivot tables; inspections; NICAR; National Institute of Computer-Assisted Reporting