
UdemyFree and discounted course coupons, posted every day.
Taught by award-winning instructor Jeff Lenning, CPA, this course is built around the technique he described in his Journal of Accountancy article The Power of Mapping Tables. It covers three connected skills: storing source data in real Excel Tables, using SUMIFS for multi-condition summing, and using a mapping table to translate data labels into report labels when the two don't match.
Accountants and finance professionals who build reports in Excel and want faster, more reliable ways to summarize and label data.
Includes practice files, answer files, and a solutions video, demonstrated in Excel 2013 for Windows.
Mark your own learning status. Opening a course link does not establish enrollment.
Loading saved status…
From the Udemy page
In this course, author and award-winning instructor Jeff Lenning CPA demonstrates the technique featured in his Journal of Accountancy article The Power of Mapping Tables. If you use Microsoft Excel to generate reports, this course is for you. We discuss the benefits of storing source data in tables, how to use the SUMIFS function to conditionally sum transactions, and how to translate labels with a mapping table.
Microsoft introduced tables in Excel 2007, and this feature is a game-changer. …
Advertisement
Yes. It's free on Udemy.
No Korshub reviews yet.