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

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