Sharepoint Excel Document Library Setup

Being a new SharePoint/O365 poweruser I need to ask a few questions. Back-story: In Office 2013, I have simple form that I am trying to adapt for SP usage. I have 5 Document Properties that I need to set as Required, so they get populated to the correct SP columns. I am trying to use this section to fill cells progrmatically. This is important because I need the information in both the printed version(or PDF) as well as an online record kept in SP.
Attachment 381161
Title is not needed or wanted I would prefer to hide that column.

I am referencing an older post from here and another web page. These would lead me to believe that this should be easy and not as complicated as I'm trying to make it.

I don't think I use need to use macros, see the second page where it works in Word.