Working with Excel Lists: Summarizing Factulty Data (Part One)

Excel techniques used:

• Apply IF function
• Freeze rows and columns
• Find and replace values in a worksheet
• Create a list range
• Sort data using the custom lists
• Apply conditional formatting

(Zoom in by clicking the pictures)