City of St. Catharines Learning & Development

To take this course you must have a solid understanding Excel Course 1B and Excel Course 2B. You should consider yourself an Intermediate or better Excel user.

Sharpen your data reporting skills by learning how to clean up messy spreadsheets quickly and effectively. This course teaches practical techniques to tidy your data and keep your reports accurate, efficient, and easy to manage.

Import & Fix Text Files

• Import .CSV, .TXT, .PRN
• The Text Import Wizard
• Fix Bad Dates and Bad Numbers
• Transpose
• Finding Duplicates

Splitting Data

• Using Flash Fill to Split Columns
• Using Text to Columns

Concatenating

• Combining Cell Contents
• Combining Different Data Types

Use Test Functions to Fix Data

• Left / Mid / Right / Len
• Search / Trim / Text / Clean
• Lower / Upper / Proper / Value
• NumberValue / Substitute / FormulaText
• TextBefore / TextAfter / The IS Functions