Automate a report from SharePoint list

Hi, I am new to SharePoint I need a help to create a report on SharePoint list which need to capture new data from a list on daily basis and send to a person.
The report format is in excel/ any other.