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, 2022March 17, 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, 2018May 9, 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:


Acquisition International:
Business Excellence Awards 2021

Spreadsheet Instructional Expert of the Year

Where to find me

YouTube:

 

Twitter:
Follow @exceloffthegrid

Books

100 Excel Macros Book

Tell me more…

Recent Posts

  • Weighted Average in Excel
  • Power Query – Connect to OneDrive Personal files
  • Power Query – Connect to OneDrive or SharePoint
  • Unblock Macros downloaded from the internet
  • Using an Excel Table within a data validation list
Theme by Out the Box
  • Home
  • Blog
  • Courses
  • Books
  • About
  • Terms and conditions
  • Privacy policy
  • Affiliate disclosure
  • Contact

Special Offer: Join the Automation Academy for $5.
Limited time only

Join now!
X