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 "Microsoft Excel" ...
-
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
-
Bringing Excel to the web with Excel 2013 and SkyDrive
Learn some of Microsoft Excel 2013's new features and talk about how to improve your stories and how to engage viewers with your sites for free. Look at different examples of how Excel has been implemented in storytelling.
-
Embedding interactive data and charts using Office Web apps
"Learn how to take your Excel workbooks and quickly turn them into part of your published story by using the free Excel Web App." This Powerpoint presentation will walk you through, step-by-step.
-
Execel Formulas- A Quick List
A brief cheat sheet of formulas commonly used on Microsoft Excel. Scroll to the fourth page of this tipsheet for the Bengali translation.
Tags: Excel
-
Importing HTML tables using Microsoft Excel
"Getting HTML tables into Microsoft Excel used to be labor intensive and problematic." Get tips from Nixon on how to import easily.
Tags: Excel; HTML; importing data
-
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;
-
Excel/Access User Defined Functions`
Harbord discusses how Visual Basic for Applications can be used to expand the capabilities of Excel and Access. \\\"Based on the original Basic programming language from the early 70’s, this version is built in to all Microsoft Office products and is similar to Visual Basic version 6.0. Each product like Excel has special capabilities in VBA for accessing and manipulating its specific “objects” such as cells and ranges of cells. (Called the Object Model).\\\"
Tags: visual basic; excel; access; object model; VBA; functions; query
-
Building a Database
Maines discusses the nuts and bolts of building your own database, and raises a lot of practical considerations to decide before beginning. He also includes examples of home-grown databases that have lead to excellent CAR stories.
Tags: data; Microsoft Access; data entry; story ideas