The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

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

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

Super Learner
0
Votes
3
Answer

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

365 Team
0
Votes

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

Super Learner
0
Votes

Hi Ned, 
Thanks for the clarification. 🙂
Jacky.

365 Team
0
Votes

Most welcome!

×
Ready to Learn
Data Science?
50% OFF