Turn raw spreadsheets into reliable analysis with lookups, PivotTables, Power Query and clear charts.
4 modules · 11 lessons · about 6 hours of guided content
A practical course for people who already use Excel but want to work faster and more reliably. You will clean messy exports, build lookup-driven models, summarise thousands of rows with PivotTables, and present results that decision-makers understand.
Module 1
Formulas that don't breakReferences, named ranges and logical functions. · 3 lessons · quizModule 2
Summarising dataConditional aggregation and PivotTables. · 3 lessons · assignmentModule 3
Cleaning with Power QueryRepeatable data preparation. · 3 lessonsModule 4
Presenting resultsCharts and a one-page dashboard. · 2 lessons · assignmentCertificates confirm completion of BDIM training. They are not an academic qualification or professional accreditation.
Tell us whether you are an individual learner, a group or an organization, and your preferred format. Pricing is negotiable.
