Unpivot, The Tool We Never Knew We Needed!

Where many people are familiar with Pivot Tables, most have never heard of the unpivot feature, and yet it has been included into Excel for years now! It is part of the suite of tools available through Power Query, and it is easier (and more useful) to use than you might initially expect.

Office GuidesMatthew Di MinnoSeptember 8, 2022Excel, Unpivot, Query, analysis, blogs, business, Power-BI, data, efficiency, guides, hard skills, improvement, skills, Learning, Problems, reporting, Guides, visualization, workflow, AnalyticsComment

Building a Dashboard: Top Five Mistakes People Make

Dashboards and data summaries are an essential part of the workplace. Whether they be for weekly updates or executive level presentations, having a classy and functional approach to visualising data will not only save you time, but allow you to effectively communicate through graphics.

Skills & ToolsMatthew Di MinnoOctober 12, 2020analysis, data, language, manipulation, blogs, business, Power-BI, Problems, Columns, datasets, decision, guides, engageent, Efficiency, formatting, software, Guides, hard skills, improvement, visualization, skills, Learning, management, comparison, projections, operations, Text, trends, use case, ExcelComment

XLOOKUP: Just One More Reason Microsoft365 Is Worth The Cost!

XLOOKUP is a new function Microsoft has begun to integrate into their 365 subscription platform. This function looks to replace the likes of VLOOKUP and the INDEX/MATCH format. How does it hold up in comparison? Is it worth upgrading to Microsoft365? Download a free Excel workbook to test out the differences between all three functions!

Office GuidesMatthew Di MinnoJuly 20, 2020analysis, data, Problems, datasets, Excel, Efficiency, formatting, guides, Guides, improvement, skills, Learning, learning, tool, reporting, software, tools, Analytics, xlookupComment

Nested IF(S): A Guide to Decision Tree Logic in Excel

The IF function is one of the first that many people learn. It can be even more powerful when used with a more intricate decision logic structure!

Office GuidesMatthew Di MinnoMarch 23, 2020Excel, improvement, Guides, tools, conditional, data, Efficiency, formatting, learning, skills, manipulation, Problems, AnalyticsComment

What’s Your Problem?: Properly Interpreting Pain Points, How It Can Save You Time And Money

Often times what people may describe as being a problem, is really only scratching the surface of what is going on. Learn how to dig deep, and really find out what’s wrong.

Skills & ToolsMatthew Di MinnoFebruary 3, 2020Problems, operations, improvement, continuousComment