@bigexcelenergy: You should be using Excel more like PowerPoint. That might sound a bit weird but it's an absolute game changer for people that work on reports or presentations in Excel. This whole thing is possible because Excel has layers. We can use pivot tables, charts and text boxes to pull data out of the cell grid and have waaay more flexibility to design your spreadsheets. Layers: so the first thing to understand is that Excel has layers just like PowerPoint. You can insert shapes, text or images and then move them forward and backwards. When you start stacking those elements together you can make almost anything that you'd make in a slide deck. Pivot Tables: if we use pivot tables and pivot charts we can process all our data, get the metrics we want, and then use them dynamically. So we can basically add data to our report and our pivot tables and pivot charts will update automatically. Text boxes: instead of leaving your data in a cell, you can pull it and place it in a text box using the formula bar - I have a ton of tutorials showing how this is done. #pivottables #microsoftambassador #betterspreadsheets #exceltutorial #exceldashboards