Skip to content
Excel Off The Grid Logo
  • Home
  • Blog
  • Courses
  • Books
  • Consultancy
  • Member Login

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 fix the Formula.Firewall error in Power Query (2 ways)
  • Advanced dynamic array formula techniques (3 methods)
  • How to use dynamic arrays with other features (7 scenarios)
  • RANDARRAY function in Excel (How to + 4 Examples)
  • SEQUENCE function in Excel (How to + 5 Examples)
Theme by Out the Box
  • Home
  • Blog
  • Courses
  • Books
  • About
  • Terms and conditions
  • Privacy policy
  • Affiliate disclosure
  • Contact

14-Day Free Trial
Is the Automation Academy right for for you? Try it for free!   

Get started
X