Recent JofA Article

Jeff Lenning|April 24, 2014||, ,

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

Posted in , , ,

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.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Free Roadmap

Want to learn Excel?

Our training programs start at $29 and will help you learn Excel quickly.

Training Info

Leave a Comment





Training Programs
Free Resources

Learn by Email

Subscribe to Blog (free)
!
!
Subscribe
Something went wrong. Please check your entries and try again.

Topics

Battle Breakout Chart ChatGPT CHOOSE Comparison Formulas CONCAT CONCATENATE Conditional Formatting COUNTIF COUNTIFS Data Model Data Validation Dynamic Arrays EOMONTH FILTER Filters FlashFill Format Get & Transform Hacks Hyperlink IFERROR INDEX INDIRECT Macro MATCH Named Ranges Named References Names PivotTable Power Pivot Power Query SEQUENCE Sort Spill SUBTOTAL SUMIFS Tables TEXT TEXTJOIN UNIQUE VLOOKUP VSTACK XLOOKUP

Categories