Understanding data: make better decisions with Excel & dashboards

Foundation · Course
Understanding data: make better decisions with Excel & dashboards
You learn how to turn raw ERP exports into clean decision material and how to create an Excel dashboard step by step that is actually read in a Swiss SME. The course combines data understanding, practical Excel skills, KPI logic and simple quality checks.
🎓
Das erarbeitest du
✓ Read & clean up data✓ KPIs & charts with a message✓ Your KPI dashboard: build, maintain, present
📦 3 modules
📚 60 lessons
🏆 Certificate at 60%
🇨🇭 German
Didactically built, not just filled – from 15 years of teaching practice.

What you will learn

  • ✓ You distinguish data types such as numbers, text, dates, categories and unique keys in typical SME exports.
  • ✓ You recognize relevant data sources in the company and assess which source is suitable for which decision.
  • ✓ You open and secure a monthly ERP export in such a way that raw data, working copy and analysis remain cleanly separated.
  • ✓ You clean tables in Excel using sorting, filtering, duplicate checks, format corrections and simple formulas.
  • ✓ You recognize data quality problems such as missing values, incorrect formats, duplicates, outliers and unclear terms.
  • ✓ You understand the basic idea of VLOOKUP and XLOOKUP and know when a lookup table helps.
  • ✓ You use PivotTables as a first preview to condense many rows and make patterns visible.
  • ✓ You create a first data dictionary so that KPIs, columns and rules are understood the same way in the team.

Course content

1
Read & clean up data
20 lessons · 5 quiz questions
🔒
2
KPIs & charts with a message
20 lessons · 5 quiz questions
🔒
3
Your KPI dashboard: build, maintain, present
20 lessons · 5 quiz questions
🔒
🧠
199.00 CHF
One-off payment · certificate included · no subscription
📈 Take your CV to the next level – with verifiable AI competence that employers can see.
Private proof of learning issued by Alpasana GmbH — not a state-recognised certificate or one issued by a trademark owner.
⚡ Buy now & start
Immediate access after payment
Everything included
🤖 Personal AI learning coach in every lesson – never get stuck alone again
🎮 XP, levels & badges – learning that keeps you going
✓ Start immediately – no waiting
✓ 3 modules with 60 lessons
✓ Instant feedback on every quiz
✓ Verifiable certificate – add it to your LinkedIn profile with 1 click
✓ Tamper-proof via public verification URL
✓ German · Swiss practice