Excel Essentials for Everyday Work

Build Clean Data beginner

Apply the methods in build clean data to realistic work.

1. Build Clean Data
   1. Structure data as a reliable table 18 min · required
   2. Enter dates, numbers and text consistently 18 min · required
   3. Assessment: Build Clean Data assessment

Calculate and Inspect intermediate

Apply the methods in calculate and inspect to realistic work.

1. Calculate and Inspect
   1. Use SUM, AVERAGE and COUNT 18 min · required
   2. Use IF for simple logic 18 min · required
   3. Assessment: Calculate and Inspect assessment

Filter and Share Safely intermediate

Apply the methods in filter and share safely to realistic work.

1. Filter and Share Safely
   1. Sort and filter without breaking records 18 min · required
   2. Validate and review before sharing 18 min · required
   3. Assessment: Filter and Share Safely assessment

Final assessment

Final assessment