10x Your Excel Capabilities

12,627 students use ExcelMinded to massively improve their Excel & Data Analysis skills

Why you should make Dashboard Glossaries mandatory on your reporting

Over many years creating dashboards for our clients we have found that no matter the business there will always be some level of ambiguity around the true meaning of metrics on a dashboard.  This is only natural, given the varying terminology, different departments and lines of of businesses...

READ MORE

4 ways to mitigate single point of failure risk for Excel processes

If you run a small business of almost any kind you'll be all too familiar of single point of failure risk, even if not by that name. You've got a great member of staff who is building better ways of doing things, creating new spreadsheets, new processes and helping the business perform better...

READ MORE

How to drive dashboard engagement through rethinking RAG status markers

Does red still mean red anymore? So many of the dashboards we come across are red all over, and when you see that, it's time to change. Adding a Red Amber Green status to your key metrics is a long established way to get managers to pay attention where it matters. What's key though is that the...

READ MORE

5 reasons to stop using pie charts today

Pie charts are an almost guaranteed element of most dashboards, but that doesn't make them great ways to Display data. Here's 5 reasons not to use pie charts in your dashboards: 1. They're difficult to visually gauge proportions  Got a category on your pie chart at 7%? Could you spot that it was...

READ MORE

How to ensure your dashboards are always understood as expected

One risk in business analytics is that of false conclusions being drawn from dashboards and analytics. It may well be that the dashboard itself is factually correct, but terminology, layout and aesthetics can have a large impact on how a report is interpreted. Consider the following: Set a...

READ MORE

Driving Audience engagement in MI through competition

If your business has reports or dashboards regularly refreshed, how do you maintain engagement in the report over time? Metrics can get stale, and those profile can drop. Lack of engagement can be a red herring. Just because something gets less discussion or engagement doesn't make it less...

READ MORE

Why you need to finally learn how to VLOOKUP

Ask any excel geek what the most common question they get asked and invariably VLOOkUPs come up. How do you look up a value in one table and return an adjacent column from that table? I guess one of the problems with excel is that it can feel technically difficult or daunting just by the way the...

READ MORE

7 things every dashboard should include

Despite the popularity of dashboards in business, there's a huge variability in the quality of dashboard design and setup. We recommend 7 key characteristics that every great dashboard should have. Do your dashboards have these? A Clean layout Still using primary colours and 3D pie charts? I...

READ MORE

How to implement self service business intelligence in Excel

In the modern analytics software world, we are spoiled for choice for functionality, flashy charts and a utopian promise of self service analytics. We have seen examples of clients not implementing software right, and in many cases end up reverting to Excel reports. Amazingly, you can still...

READ MORE

5 reasons why self service analytics is overrated

The world of analytics and business intelligence has been taken by storm in recent years by the idea of 'self service' - where staff across a business can create their own reports, add their own data and build out their own analytics solutions rather than relying on IT departments.  Whilst the...

READ MORE