Excel is often perceived as a simple tool for calculations and tables. It is a powerful decision-support platform when used correctly.
In this webinar, we move beyond basic spredsheet usage and explore how Excel can be used to analyze data, identify patterns, and support informed decision-making in real-world scenarios.
The session combines demonstrations, explanations, and hands-on examples to show how Excel can evolve from a passive data container into an active decision tool.
The webinar lasts 1½ hours, and the pace is high, but you will have possibility to ask questions during the webinar or at the end. You also have the possibility to re-see the webinar as many times as you like, and at your own speed.
Objective
After this webinar, you will be able to:
- Understand how Excel supports decision-making, not just data storage
- Structure and prepare data for analysis and insight
- Use key Excel features to evaluate scenarios and trends
- Translate data into clear insights that support business decisions
- Recognize when Excel is sufficient and when other tools may be needed
Agenda
Part 1 - Excel beyond Spreadsheets:
- Common misconceptions about Excel
- Typical decision-making mistakes in Excel
- Examples of good vs. poor Excel-based decisions
Part 2 - From Raw Data to Structured Insight:
- Data cleaning and preparation principles
- Tables, naming, and consistency
- Avoiding manual and error-prone workflows
Part 3 - Decision-support Tools in Excel:
- PivotTables and PivotCharts
- Conditional formatting for insight
- Basic scenario and comparison techniques
- Simple KPIs and indicators
Part 4 - Communicating Decisions:
- Designing clear and focused outputs
- What decision-makers need to see
- Common visualization pitfalls
Part 5 - Wrap-up and Key Takeaways:
- Best practices checklist
- When Excel is the right tool and when it isn't
- Q&A
If you have any questions about the contents of the webinar, you can contact Lone Jelgren of Jelgren Consult, by phone - 22 24 00 75 or by email -
lj@jelgrenconsult.dk.
Requirements
To get the most out of the webinar, participants should have:
- Basic experience using Microsoft Excel (formulars, basic charts)
- Microsoft Excel installed (Windows version is used in the webinar). Som features may differ if you are using Excel for Mac or Excel Online.
