Tables are one of the best features of Excel. While it is possible to use the standard cell referencing with a Table, they have their own referencing style called structured references. We have to think a little differently to create a running total in an Excel Table using structured references. We will look at all Read More
Category: Modern Excel
An introduction to Modern Excel
Back in 2007, the Excel data revolution started. At the time we saw a few new features, a new menu layout, a new file format, and 983,040 additional rows. We had no idea of the plans Microsoft had for Excel, but it was all laying the groundwork for what was to come. In the following Read More