In the top menu of Excel select Data > Get Data > From File > From PDF. Browse your files and select the PDF with the table in it. Now select Import. Choose the table from the list that appears and ...
The simplest way to think about SCAN is that it applies a custom calculation to each element in a range/array and returns every intermediate result it produces along the way. If that sounds abstract, ...