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 MoreWhat is a process? what is a workflow? how are they different? and how are they similar? Let’s dive in to find out why people often use these terms interchangeably, and how we can use them to better how we work on a daily basis. Hint: It’s easier than it may seem!
Read More