How I use Excel to understand a problem before it becomes a dashboard

Excel is often the first tool I open in a data analysis project - but not to build anything impressive.

For me, Excel is a thinking space.

Before dashboards, models or visuals, it helps me understand what’s really going on in the data and whether the question I’m answering actually makes sense.

Using Excel to explore, not to present

At this stage, I’m not trying to create a polished output.

I use Excel to:

• quickly scan the data

• check basic structure and consistency

• understand what is available - and what isn’t

It’s about getting familiar with the data, not explaining it to others yet.

Messy sheets, simple pivots and rough calculations are perfectly fine here. This is not the final product - it’s part of the thinking process.

Breaking a big question into smaller ones

When a question feels too broad, Excel helps me break it down.

Instead of trying to answer everything at once, I look for:

• patterns

• obvious gaps

• relationships that are worth exploring further

This often reveals whether the original question needs to be refined or reframed.

Sometimes the most useful outcome at this stage is realising that we need to ask a different question.

Checking assumptions early

Excel is also where I test assumptions quickly.

Simple summaries, filters or comparisons can already show whether an idea holds up or not.

Doing this early saves time later - especially before moving into more complex analysis or building dashboards that might end up answering the wrong question.

Knowing when Excel is enough - and when it’s not

Not every problem needs to go further than Excel.

Sometimes a clear table or a simple summary is enough to support a decision.

Other times, Excel shows me that:

• the data is too large

• relationships are more complex

• the insights need to be communicated more clearly

That’s when tools like SQL or Power BI come in - not as a default step, but because they genuinely add value.

Why this step matters to me

Using Excel this way keeps my work grounded.

It helps me stay focused on understanding the problem before thinking about how it should look visually.

Most importantly, it prevents me from building dashboards or analyses that are technically correct but not particularly useful.

For me, Excel isn’t about formulas or features. It’s about making sense of a problem before moving on.

This way of working fits naturally into how I approach data analysis before opening any tools.