Working with Data

Topics Covered

• Data entry techniques
• AutoFill and Flash Fill
• Cell formatting
• Number formats
• Tables
• Sorting and filtering
• Data validation
• Find and Replace
• Freeze Panes
• Workbook organization

Module Description

• This module teaches participants how to efficiently organize, clean, and structure business data while using Copilot to automate formatting and data preparation tasks.

Hands-on Lab

• Build a structured sales dataset.
• Use Copilot to clean and format imported data.