Tutorial on how to use API and connect it to Excel

I need the values to reflect to my excel file. Is that possible?

I would also like to know if this is possible. There are things I can do in Excel that are not possible in Monday, like highlighting formula columns, and I can easily create Pivot charts in excel.