HOW TO… Excel: A Truly Non-Volatile Solution for Dynamic Data Tables

This is a follow-up to the last tutorial. Thanks to reddit user /u/small_trunks for noticing my blunder! Unfortunately, 'SUMIFS' couldn't be used on its own to create the dynamic data tables. But don't fret! I have another solution up my sleeve that doesn't rely on volatile functions like 'INDIRECT' and 'OFFSET'! It relies entirely on … Continue reading HOW TO… Excel: A Truly Non-Volatile Solution for Dynamic Data Tables

HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes

Creating a full and cohesive user experience in an Excel based dashboard can be really difficult if you don't know where to start. Often, the easiest way to approach the situation will be to utilise Pivot Tables and Pivot Charts, which come with useful tools like slicers to dynamically filter the data with a touch … Continue reading HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes