Tuesday, February 23, 2010

Summary: Correcting & Expanding Upon Worksheet Data

Checking for errors is always a great idea. Checking for corrections in formulas or numeric values should always seem obvious, but Excel has a Spelling Checker feature. This feature highlights possibly-misspelled words and gives a lists correctly spelled words. There is also a translation, and a thesaurus feature.

Summary: Finding and Replacing Data

Some worksheets in Excel contain very little data in which it is very easy to find mistakes and correct them. However, worksheets contain billions of cells. When there is a ton of information in a worksheet it becomes difficult to find certain data among a pile of data. Learning to use the Find & Replace feature is very important as it may save one a whole lot of time and frustration.