Terrible title. Nothing to do with automating excel. From what I can tell it seems to be about ingesting spreadsheets into panda (and incredibly narrow use of Excel) and working outside of Excel.
Titles are incredibly hard to get right... but the spirit is about automating what you do with Excel. To the absolute beginner, writing a Python script to ingest a spreadsheet into a dataframe, doing all the manual copy/paste blah blah blah, and the saving back out to an Excel file DOES qualify as automation!