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 "filtering data" ...
-
Excel 1
Start learning basic calculation and sorting with Microsoft Excel. Learn how to format your data, rank and sort numbers and filter information.
Tags: Microsoft Excel; software; calculation; sorting; formatting; filtering; data: CAR
-
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
-
Skills and Knowledge Checklist for Excel
This tipsheet lists everything that a journalist would ever need to know in order to use Microsoft Excel. It covers everything from basic terminology to data formatting, data design and data calculation. Wolfe explains the most important and complicated functions, and lists other helpful tricks.
Tags: spreadsheets; calculations; filtering data; formula; worksheet; toolbar.
-
Hunting for Trends in Data Using Microsoft Access
This tipsheet uses a database about hunting accidents to demonstrate some of the basic Access functions. It covers everything from sorting data to crafting queries. The tipsheet offers several practice questions, such as "How many accidents occurred overall on the first day of deer hunting season in 1994?" It then goes on to explain how to write queries that answer these questions.
Tags: Microsoft Access; database analysis; design view; Queries
-
Microsoft Access: Quick Tips
This tipsheet is a good guide to some of the more basic functions of Microsoft Access. It gives easy -to-follow explanations for writing queries that sort, filter and summarize the data. The tipsheet also explains how to join tables.
Tags: databases; query design view; tables; Group By; order by
-
CAR on Beat
Guide defines and explains computer-assisted reporting resources, including listserves, newsgroups, bulletin boards, news filters, forums, databases, gopher sites, and www sites. Includes general information on use requirements, cost, and problems associated with each resource. Audio tape is available for purchase from the IRE Resource Center. Contact us at (573) 882-3364 or rescntr@ire.org
Tags: Electronic Data Internet