Using Excel for Data Clean-up and management

Some techniques are IF statements, the TEXT function, PivotTables and Filtering, Grouping, VLOOKUP, HLOOKUP and MATCH. IF Statements For example, this allows you to summarize the data by showing how many questions were asked at the help desks and tho...