Select Page

Excel Video 400 Table Styles

Wow! We’ve made it to 400 Excel Videos. Thanks to each of you for watching and promoting these Excel Videos. Excel Video 400 starts with some simple tricks to add polish and professionalism to your Tables. If you’ve ever suffered manually shading every other row or...

Excel Video 399 Structured References in Tables

The message of Excel Video 399 is that structured references are easy to read, but hard to write. The syntax of the structured references is too involved, just mouse or arrow over to the cell you want and let Excel build the formula for you. Once the formula’s built,...

Excel Video 398 Resizing Tables

Excel Video 397 showed you how to add data to a Table, but if you need to change the size of a Table, watch Excel Video 398. The example in the video that I’ve done most often is when I need to add data to the left of a table. The Resize Table button will let you...

Excel Video 397 Adding Data to Tables

Watch how easy it is to add more data to Tables in Excel Video 397. If you’ve ever manually shaded every other row in a report, I hope those days are over with this Excel Video. Watch how I can add a formula to one adjacent cell in a Table and Excel will automatically...