PowerBI desktop using Excel files

Dear community ,

i am using powerBI in the last few months and really love it.

but i have some understanding questions and some problems that i wandered if someone could help me with.

1. my data sources unfortunatlly are excel files at the moment . but i use around 10 files with a lot of data for 1 report , i was wandering if there is a better way to do this process meaning would it be better to create an Acess DB based from those files and connect it to powerBI , or is it just a waste of time. my understanding problem is - lets say i have new data and i inserted it in my excel files (copy paste of the data into the excel file ) now if i will refreash the report on my powerBI will the data be changed too ?

2. if i use excel files as my data source and then send the powerbi report to someone that dont have access to my drive where the files are - will he be able to see my files ? and if i will update my report , will it be updated for him as well ?

3. is there a powerBI training i can participate - not the videos?

Thank you for your help

Shahar