Data analysis · Beginner to intermediate · 16 live learning hours

Certificate of completion

Learners who meet the course participation and practical assessment requirements receive a Solid Elf certificate of completion.

What you will learn

Clean and structure messy workbooks
Use formulas, lookups, tables and PivotTables confidently
Build charts and dashboards for decision-making
Document a repeatable analysis and reporting workflow

Course outline

Week 1: Workbook structure, data cleaning, tables and validation
Week 2: Core formulas, lookups, conditional logic and error checks
Week 3: PivotTables, PivotCharts and analytical summaries
Week 4: Dashboard design, reporting automation and quality review

Practical project

A cleaned workbook, analytical model and decision-focused Excel dashboard.

Before you start

Basic computer skills and access to a compatible version of Microsoft Excel. A Microsoft 365 or Excel licence is not included.

Learning format

Fully online and live. 4 weeks · 8 sessions · 2 hours per session, twice each week. Cohort dates and weekly meeting days are agreed during enrolment.

Exercises should use synthetic, de-identified or otherwise authorised material. Do not bring confidential client records or live credentials into a training session.

What the fee includes

Live tuition, guided exercises, reusable templates, feedback on your practical assignment and a certificate of completion for learners who meet the course participation and assessment requirements. Software licences and internet access are not included.

Software and reference material

Explore official reference material ↗. Training is independently offered by Solid Elf; no software-vendor accreditation or certification is claimed unless explicitly stated.

Excel for Data Analysis & Reporting