Excel

Recent posts

Summer Camp: Excel Formulas with Kyle Stokes

In this 28-minute webinar, StateImpact Indiana reporter Kyle Stokes walks you through some Excel basics, including:

  • using cell references!
  • copying formulas down a column!
  • calculating sum and difference!
  • and calculating rate of change!

To follow along, download the data here.

And for quick reference, here is a sampling of some of our favorite Excel formulas for journalists, below: Continue reading

Summer Camp: Excel Basics with Molly Bloom

Let StateImpact Reporter Molly Bloom lead  you through some basics of using Excel, including: 
  • Importing data from txt and csv files!
  • Sorting and filtering data!
  • and Creating easy and super-powerful pivot tables for data analysis and organization!

To experiment with the files used in this video:
  1. Report Card data: Go here and click on File –> Download as –> Microsoft Excel.
  2. Enrollment data is here.
  3. School levy data is here

2013 NICAR’s Greatest Hits

The annual computer-assisted reporting conference organized by IRE and NICAR is a treasure trove of tips, tools and inspiration. There is always something for just about anyone in the news

Pete Karl II / Flikr

People share notes, experiences and know-how at NICAR and IRE conferences. It's cool like that.

industry–from the old-school newspaperman who won’t send an email to the young, enthusiastic programming geek–and everyone in between.

In fact, if you consider yourself to be very much in between–or maybe even slightly towards the old-school side of things, this post is for you. We’ve sifted through the labyrinth of tipsheets, blog posts and (almost) exhaustive collections of all that was generously shared, referenced or demonstrated at this year’s conference to bring you some of the most useful data-driven reporting tools offerred at this year’s event.

We’ve organized it into seven broad categories:

  1. General CAR Tips & Best Practices from the Pros
  2. Research Tools
  3. Social Media Tools
  4. Data Cleaning
  5. Excel
  6. Inspiration: A Small Collection of some of the Best Data-Driven Stories of 2012 (with a special emphasis on energy, education and economy stories)
  7. Advanced Coursework in Database Analysis, Super Stealth Spy Stuff and Web Scraping

We haven’t tested everything just yet, so if you find any of this particularly useful–or not–please do tell us about it in the comments section or via email.

That said, we hope you’ll find at least some of the collection below as useful and inspiring as we do. Enjoy!

Continue reading