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.
Read MoreDashboards 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.
Read More