Inconsistencies in data can occur when data is entered manually, or when data is imported from diverse resources. Inconsistencies can consist of misspellings, unique capitalization, or variants in data structure. Excel presents A variety of instruments to assist with data formatting and cleaning.