Recent JofA Article

April 2014 Cover_Xcover.qxd

Hi guys! Just wanted to draw your attention to my April 2014 Journal of Accountancy article that discusses the power of mapping tables. If you’ve not experimented with this technique, it is worth checking out.

In summary, a mapping table sits between the data and report sheets and enables you to translate labels and aggregate rows. This technique uses the tables feature and the SUMIFS function. Mapping tables have helped me automate many reporting workbooks, and I hope they can help streamline your work as well!

Here are the relevant links:

Article: The power of mapping

Sample workbook: Download Excel file

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Stay Connected

If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. You can unsubscribe anytime, and I will never sell your email address.

Want to learn Excel?

Our Campus Pass includes access to our entire Undergrad and Masters catalog. Gamification ensures it is the most fun you can have learning Excel :)

Leave a Comment

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.