Now Reading:
Intro to Data Spreadsheets
Full Article 2 minutes read

Intro to Data Spreadsheets

TRAINER: CINDY ROYAL

Spreadsheets are a powerful productivity tool. A spreadsheet allows you to organize and analyze numbers and text. It is the foundational skill set of many jobs that require basic to advanced analysis. Knowing how to use a spreadsheet can be helpful in securing a job, but also in performing in a variety of positions. There are a few different spreadsheet packages, like Microsoft Excel, but Google’s productivity offering includes a free spreadsheet product.

This guide will cover:

•Filtering data
•Hiding rows and columns
•Formatting and labeling cells
•Performing mathematical functions on cells
•VLookUp
•Functions
•Sorting
•Pivot Table
•Charting
•Import feature

Trainer Cindy Royal originally presented this tutorial at an IJJ’s data visualization workshop for nonprofits and journalists in San Jose, Calif., in Feb. 2014.

Cindy is a 2014 John S. Knight Fellow at Stanford University, developing an online training platform for teaching coding and data skills to journalists. She is an associate journalism professor at Texas State University, teaching digital and data-driven media skills and concepts. She has been recognized with several teaching awards, including the Presidential Award for Excellence from Texas State University in 2013. Prior to earning a doctorate in journalism, she had a career in marketing at Compaq Computer (now part of Hewlett-Packard) in Houston and NCR Corp. in Dayton, Ohio.

Leave a Reply

Your email address will not be published. Required fields are marked *

Newsletter
Get highlights of the most important news delivered to your email inbox

Input your search keywords and press Enter.