Skip to content

Excel for Accountants: Mapping Tables

Teacher

Jeff Lenning

Position

Categories

Reviews

4.4/5
4.4

Tutorial Price

$Free
https://www.udemy.com/course/excel-for-accountants-mapping-tables/

Level

NYR

Duration

31min

# of Reviews

5073

Module Type

On demand video

Store data in tables so that new rows are automatically included in related formulas. Perform conditional summing with the SUMIFS function. Create an intermediate mapping table so that Excel has the information needed to translate labels and aggregate data rows

Instructors

Jeff Lenning

Link to Course

Sign Up