getting started, again

[snippsat]

On the question of Librarys, I started to look into a few of them, there seems to be thousands complimented by their authors or script writers. So basically the way I'm starting to see it, instead of writing the same ol same ol scripts, just call a script from the library, right ?

Yes there are two main Standard Library(comes with Python) | PyPi(3-party library).

Standard Library:

>>> import math
>>> 
>>> # 8^2 in math
>>> math.pow(8, 2)
64.0

PyPi(here need to us pip to install)
Example Requests
pip install requests

>>> import requests
>>> 
>>> r = requests.get('https://www.python.org/')
>>> r.status_code
200
>>> r.encoding
'utf-8'
>>> r.headers['date']
'Mon, 16 Jul 2018 22:25:42 GMT'

If that is the case, looking at my current Excel VBA project that runs OK, eventually I can create my own set of .py Library scripts, and use my own folder to call those scripts ?
The goal is to move away entirely from Excel, even create my own GUI ?

Yes can create own small libraries and module/packages,there are som stuff to be learn if want to share with world like on PyPi.

There are many tools for Excel in Python like Pandas, openpyxl, pyexcel.
Pandas with Jupyter notebook is one of the strongest as you get a look similar to excel(can replace Excel all together).
Common Excel Tasks Demonstrated in Pandas
Python Excel Tutorial: The Definitive Guide