I`m looking for the binance account info so I checked out their api doc information on their github page. There`s really good info there but it doesnt say anything about how to import it to excel. I shouldn`t need to write a code to import the data. Because when I need to import something from a public api, I just enter the link and it gets the data.
And that is the difference between Public and Private APIs... the Public APIs are a simple fetch of data which is identical to ALL people. The Private APIs require you to provide info (like your API key and the command you want to run) to the server and it runs the query specific to YOU and then returns the result. They are very different... and the Private API will require more effort to get working.It's not so much that you need to write code to import the data... it's that you need to write code to tell the exchange what data you want (and prove that it is YOU that wants it)
As per the binance API Docs here: https://github.com/binance-exchange/binance-official-api-docs/blob/master/rest-api.md#signed-trade-and-user_data-endpoint-security
USER-DATA calls requires you to create a digital signature (in this case, they use HMAC-SHA256) of the information you're sending... which WILL require that you do some coding, as that stuff just doesn't exist within Excel.
Quote
I`m already using power query and that`s how i connected to public apis but I just dont know how to do it for private apis. I`m not good with coding so I was trying so hard to avoid it and just import the info somewhere then see the data on the sheet.
Unfortunately, that just isn't going to happen if you want to use the Private APIs... 
Quote
I`m sure you already understand what I`m looking to accomplish but Just to give you an example of what I need, Check out this guys excel sheet.
https://www.youtube.com/watch?v=kPLCsKAG57g
Which he has now turned into a full on "commercial" product which he is charging 0.05 ETH for... no doubt because it involved a LOT of work to get going https://www.youtube.com/watch?v=kPLCsKAG57g
I very much doubt you will find a "plug and play" Excel solution... most folks who are interfacing with Exchange APIs are using Python, C#, Perl, Java or shell scripts etc, hence most of the API examples being available in these languages.