Data analysis of learners assessment data using Excel

• The file was customized for easy access to tools.
• Data was organized by splitting columns into rows.
• Tables were merged using XLOOKUP.
• The data was cleaned.
• A column for average scores was added.
• A filter formula was designed for records post-2020/11/25 with average scores below 60.
• This filter was applied.
• The data was converted to an Excel Table.

• A Pivot Table was created to explore trends.

• Insights were visualized with charts.
• A dashboard was compiled using best practices.