Excel for Accountants: Mapping Tables

Automate reporting tasks with a mapping table
4.44 (8412 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Excel for Accountants: Mapping Tables
112,867
students
31 mins
content
Sep 2017
last update
FREE
regular price

What you will learn

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

Screenshots

Excel for Accountants: Mapping Tables - Screenshot_01Excel for Accountants: Mapping Tables - Screenshot_02Excel for Accountants: Mapping Tables - Screenshot_03Excel for Accountants: Mapping Tables - Screenshot_04
331738
udemy ID
10/30/2014
course created date
11/2/2019
course indexed date
Bot
course submited by