"When you purchase something through one of the links on our site, we may earn an affiliate commission at no additional cost to you."

Excel for Accountants: Mapping Tables is a top-rated Udemy course taught by Jeff Lenning — with over 113414+ students enrolled since it launched.
Automate reporting tasks with a mapping table
Don’t wait! This special offer won’t last long.
Click the button below to Get up to 100% OFF the regular price.
(The discount will be applied automatically at checkout — no code needed!)
Hurry — this discount on Excel for Accountants: Mapping Tables won’t be around forever. Take action now!

Why enroll in the Excel for Accountants: Mapping Tables Udemy Course?
- Udemy gives you access to over 250,000 courses and 85,000 expert instructors worldwide.
- Courses are led by experienced professionals dedicated to delivering a high-quality learning experience.
- Many of Udemy’s most popular courses have hundreds of thousands of students enrolled.
- Udemy offers online coupons, promo codes and voucher for the majority of its courses.
Excel for Accountants: Mapping Tables Udemy Promotion code
Course Sections
Course Introduction
Tables
Conditional Summing
Mapping Tables
Course Recap
Course Description
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. If you do not store your data in tables, you are missing out on a simple way to improve the reliability of your workbooks. Converting an ordinary range into a table provides many special benefits, and we’ll discuss these special properties in the course.
Also with the roll-out of Excel 2007, Microsoft introduced a new worksheet function: SUMIFS. This too is a game-changer. Performing multiple-condition summing in earlier versions of Excel was challenging, and required clever functions such as SUMPRODUCT or array formulas. For many workbooks, these can be replaced with the SUMIFS function. We’ll discuss the function’s arguments and demonstrate several practical applications.
Excel reports often aggregate data. Frequently, the data labels are different than the report labels. For example, the accounting system may export account names, such as Cash or Savings, but the corresponding report labels are financial statement items, such as Cash and Cash Equivalents. When the labels are different, we are prevented from using lookup functions such as VLOOKUP to retrieve values. In this course, we’ll demonstrate the mapping table technique which enables our reports to retrieve values from data tables, even when the labels are different.
The course includes practice Excel files, corresponding answers files, and a solutions video. The course is structured by topic, and within each topic, there is a PowerPoint discussion, a lecture video that works through the item in Microsoft Excel 2013 for Windows, and sample exercises for you to work hands-on. If you use Excel to create reports, this course will help you prepare them more quickly.