Skip to content
Excel Off The Grid Logo
Member login      Free gift
  • Home
  • Blog
  • Newsletter
  • Books
  • Training Academy

Category: Modern Excel

Running total in an Excel Table

Running total in an Excel Table

Posted on March 17, 2022October 31, 2022 by Excel Off The Grid

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

Posted in Blog, Formulas, Modern Excel, Tables, Tips & Tricks 2 Comments
An introduction to Modern Excel

An introduction to Modern Excel

Posted on August 5, 2018October 31, 2022 by Excel Off The Grid

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

Posted in Blog, Miscellaneous, Modern Excel 1 Comment

Awards

Microsoft MVP:

Where to find me

YouTube:

 

Twitter:
Follow @exceloffthegrid

Books

100 Excel Macros Book

Tell me more…

Recent Posts

  • How to FILTER by a list in Excel (including multiple lists)
  • Excel number formats for accounting & finance you NEED to know
  • How to expand columns dynamically in Power Query
  • How to run Excel macros from Power Automate Desktop
  • How To Create Sheets For Each Item In PivotTable Field
Theme by Out the Box
  • Home
  • Blog
  • Newsletter
  • Books
  • Training Academy
  • About
  • Terms and conditions
  • Privacy policy
  • Affiliate disclosure
  • Contact