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.)