Skip to Main Content

Excel Basics

A guide on using Excel for data entry, analysis and visualization.

Tips for managing data in Excel:

Excel makes it easy to access and change data in individual cells, but that also means it is very easy to accidentally erase data or introduce errors.  Here are a few tips for data management in Excel:

  • Never work from the original copy of your data.
    (Always make a copy first, then start working.)
  • Save under a new file name after a major cleaning or processing step is done.
    (Use descriptive file names to retrace your steps.)