This page is hosted on AFS file server space, which is being shut down on November 13, 2018. If you are seeing this message, your service provider needs to take steps now. Visit afs.unc.edu for more information.


GETTING AROUND EXCEL
the data analyst's friend
Based on teaching material prepared by
The National Institute for Computer-Assisted Reporting




Excel, like other spreadsheets, is used by reporters and scholars to make the same computations over and over again on a whole bunch of numbers.

They let you sort small lists in different ways, produce lists for publication, clean up files you find on the Internet and organize virtually anything that comes in list form, including notes and chronologies.

Some folks bristle at typing in, say, 30 numbers into a spreadsheet.  You shouldn't.  The reason is that if you want to calculate the numbers by hand, you'll end up typing them into a calculator far more times.

For more information, follow the links:


 
The Basics: Cell addresses and mouse shapes
Selecting Cells: Selecting cells, rows and columns
Entering Data: Entering words and numbers
Tips and Traps: Hints for working with spreadsheets
Working With Formulas
Online Tutorials

Instructions on accessing ATN Tutorial

Return to Syllabus