In this tutorial we are going to look at two ways of creating a dynamic range of data. We are summing up sales data and want to automatically, or dynamically adjust the range to sum as we incorporate additional rows or columns. One way will be using Tables and the other the OFFSET function. Let’s […]
Tag Archives | Tables
Often we receive data in a format that is similar to a PivotTable, but that is not conducive to using that data to create a PivotTable to analyze that data. In order to convert the data to a tabular format to create our PivotTable, in this tutorial we will use Power Query to accomplish this.
Here are some of the benefits of using Named Ranges and Tables with formulas in Excel…..
Here is a great tip I learned from Excel TV on how to create absolute cell references in Tables in Excel…..
Here is a quick look at all the great features and functions available with Excel’s Quick Analysis tool…..
Did you know that your charts will dynamically adjust as you filter the underlying data? Let’s see how…..