how to create a group calender

hi community,

currently we are using ibm notes as email solution.

we are planning to rollout outlook in end of 2020. we already using different office 365 tools like teams, sharepoint, planner an so on.

we have a excel group calender (see attachment for example - original entries are replaced), which is programmed in excel vba. this group calender reads/gets all calender entries of all group member (office employee). this entries are displayed very clearly.

you can direclty see

- if an employee is in office or out of office (different color)

- if an employee has vacation (different color)

- if a meeting room is reserved

- which emloyee has to do the "special job"

and so on...

to check, who has to do the special job, or who has vacation, to display in different color, we are using prefixes. that means for example your calendar entry starts with "MR1" if you want to reserve meeting room 1.

we got used to this calender and wants to have something similar with the office 365 and outlook.

(q1) does the office 365 calendar already have such a group calendar?

(q2) if not, are there interfaces to the office 365 calendar to recreate something similar to that described above?

sorry for my poor english.

thanks.