Jacky Yiu
Last answered:

08 May 2020

 Posted on:

06 May 2020
0

Intro to MS Excel - Mapping the Rows in the Database Sheet

Hi Instructor, In the video at 00:48, you mentioned "assigning a macro category to various P&L account". Are you referring to the Macro function in the excel?  If yes, can you advise how to create the Marco to do the mapping?
3 answers ( 0 marked as helpful)
Ned Krastev
Instructor
Posted on:

07 May 2020
0
Hi Jacky, Sorry for the confusion. I'm not referring to the macros functionality. What i mean is that you have 'macro' categories and sub categories. So, for example one macro category can be:
  • Operating expenses
Some of its sub categories are: -- Cost of personnel  -- Travel costs  -- Rent, etc. And then we also have sub sub categories of Cost of personnel: --> Wages --> Social security --> Bonuses, etc. Hope this makes sense! Best, Ned
Jacky Yiu
Posted on:

08 May 2020
0
Hi Ned,  Thanks for the clarification. :) Jacky.
Ned Krastev
Instructor
Posted on:

08 May 2020
0
Most welcome!

Submit an answer