Skip to content
Controllingblog

Home❧Software & Data

Software & Data

Excel, Power BI, planning software and data warehouses: which tool fits which task – and how do you get the most out of what you already have?

8 articleswith examples & FAQ
Illustration: laptop with dashboard, database and cloud +12% 4.2 M 98%
What it is about

Good controlling rarely fails because of methods, but often because of tools: files nobody understands any more, data copied by hand every month, reports that arrive too late. The right software – or simply the right use of what you have – saves hours every week.

This section is about practical tool knowledge: the Excel functions you really need, getting started with Power BI, choosing planning software and the basics of a data warehouse – always from a controlling perspective, not an IT one.

Excel

The most important functions and Power Query for everyday work.

Planning

When planning software pays off and how to choose it.

All articles

Read and apply

Illustration: laptop with dashboard, database and cloud +12% 4.2 M 98%

Excel for controllers: the 30 most important functions

Excel is and remains the Swiss army knife of controlling. These 30 functions cover almost everything that comes up in daily work – sorted by task, with examples.

Read more · 16 min →
Illustration: laptop with dashboard, database and cloud +12% 4.2 M 98%

Pivot tables: the 30 most important features for controllers

Pivot tables summarise thousands of postings with a few clicks. These 30 features turn a quick overview into a report that grows with you every month.

Read more · 14 min →
Illustration: laptop with dashboard, database and cloud +12% 4.2 M 98%

Power Query: the 30 most important features for controllers

Power Query does the monthly copying, cleaning and joining of exports for you. Set it up once, and from then on one click on “Refresh” is enough.

Read more · 15 min →
Illustration: laptop with dashboard, database and cloud +12% 4.2 M 98%

Goal Seek, data tables and more: Excel's what-if tools

Which price gives a result of zero? How strongly does profit react to volume and price? Excel has dedicated tools for this – only ten, but they save a lot of trial and error.

Read more · 10 min →
Illustration: laptop with dashboard, database and cloud +12% 4.2 M 98%

Conditional formatting: the 30 most important rules for controllers

Used well, the one critical variance jumps out immediately. Used badly, everything lights up. These 30 rules show how to do it right.

Read more · 12 min →
Illustration: laptop with dashboard, database and cloud +12% 4.2 M 98%

Power BI for controllers: getting started, DAX and your first dashboard

From Excel report to interactive dashboard: what DAX is, which 15 functions you really need and how to build your first controlling dashboard in a few steps.

Read more · 15 min →
Illustration: laptop with dashboard, database and cloud +12% 4.2 M 98%

Planning software compared

When is dedicated planning software worth it – and which one fits? An overview of categories, criteria and the path to the right decision.

Read more · 8 min →
Illustration: laptop with dashboard, database and cloud +12% 4.2 M 98%

Data warehouse explained simply

One truth instead of five exports: what a data warehouse is, how it works and when it is worth it for mid-sized companies too.

Read more · 7 min →