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.

Watch Window: Save Yourself the CTL + Page Up/Down

One hidden gem of a tool in Excel allows you to see the formulas and outputs of cells across sheets, making work and validation easier than ever before!

Office GuidesMatthew Di MinnoApril 27, 2020Excel, 365, watch, window, tool, efficiency, audit, data, manipulation, learning, Efficiency, Guides, improvementComment

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

Text To Columns: The splitting tool you always wanted but didn’t know you had!

This lesser known tool can simplify the extraction of valuable information for massive data sets all within seconds, and according to your needs.

Office GuidesMatthew Di MinnoFebruary 3, 2020Excel, Guides, Learning, Efficiency, Text, To, Columns, tool, data, manipulationComment