Search results for "data formatting" ...

• 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

  By Linda Johnson

  2013

• PowerPivot Hands On

  Torok gives an introduction to the Power Pivot function of Excel (Windows only) and an instruction on how to create three different formats of pivot tables.

  Tags: excel; data; pivot; table; chart; power

  By Tom Torok

  2012

• 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

  By Garance Burke

  2011

• Essential Analysis: Data Integrity Checks

  powerpoint presentation that reminds journalists what to check when they get data and shows how to look for dirty data using database managers or SPSS. also mentions extensive data documentation [and clean-up of dirty data] that IRE and NICAR include with the databases available from the Database library.

  Tags: data; tables; documentary; file format; record layout; data dictionary; outliers; variations; dirty data; database manager; SPSS;

  By David Herzog

  2007

• Using Monarch Pro: A helpful method for pulling data from text documents, PDFs,a nd HTML files into tables

  Monarch is a 'data mining' software that can turn text documents, PDFs, formatted ASCII files and other reports into usable data tables. Lavigne discusses how to acquire Monarch, and how to use it. She includes lots of screenshots as examples.

  Tags: monarch; data mining; data analysis

  By Paula Lavigne

  2007

• (IPUMS) Integrated Public Use Microdata Series

  This PowerPoint presentation details the uses of IPUMS, the Integrated Public Use Microdata Series. This microdata can be used when examining census statistics to "build your own tables to answer questions the summary file tables don't answer." PUMS was the Public Use Microdata Sample, which had issues including a \"tricky hierarchal format.\" IPUMS, from the University of Minnesota, is an online data extraction engine that is available free on the Web.

  Tags: PUMS; IPUMS; Integrated Public Use Microdata Series; Public Use Microdata Sample

  By Steve Doig

  2007

• Difficult Analyses: Profiling stories and other challenges

  Sylwester and Doig provide eight tips for reporters who are tackling projects that rely on a lot of data. They explain how to bring data from multiple sources together, deal with holes and/or problems with the data, change data into a usable format and much more. Sylwester and Doig also give a number of story examples that are relevant to the advice they are giving.

  Tags: data analysis; investigations; databases; working with data

  By Mary Jo Sylwester; Steve Doig

  2006

• Importing HTML tables using Microsoft Excel

  This tipsheet is a step by step guide to importing HTML tables into Microsoft Excel. The author includes screen shots to illustrate each step of the process.

  Tags: internet; data formatting; HTML; spreadsheets; data analysis; importing

  By Ron Nixon (updated by Carolyn Edds)

  2006

• Importing data using the Microsoft Excel Import Wizard

  This tipsheet is exactly what the title implies: a guide to importing data into Microsoft Excel. The author takes you step by step through the process, and includes a lot of screen shots to illustrate her directions.

  Tags: computer-assisted reporting; data analysis; data formats

  By Christine Stapleton

  2006

• Simple Web scraping by using macros in Microsoft Excel

  Kaas explains how to \"scrape\" data off of web pages and enter it into an Excel format. He includes screen shots from Excel to illustrate every step of the process.

  Tags: data analysis; internet; data cleaning; computer-assisted reporting

  By Tommy Kaas

  2005