by admin | Aug 2, 2018 | microsoft-excel-blog
In Excel 2016 you will find a new awesome chart called the TreeMap chart. The TreeMap is like a square pie chart, but it has the added ability to show a hierarchy. The data we will use is shown below. We have states broken down by segments, each with a value. Four...
by admin | Mar 14, 2018 | microsoft-excel-blog
The core of a profitable business is one that operates effectively and efficiently; one where every employee works hard at doing their part to meet the overall company objectives. Having had the opportunity to peer inside the operations of multiple successful...
by admin | Jan 9, 2018 | microsoft-excel-blog
Prior to Microsoft Excel 2016, it was quite a time-consuming task if you needed to evaluate multiple conditions that ended up with multiple results. You would solve this the old way with multiple nested IF functions as show in the example below:...