Like any Office tool, Excel has a lot of "hidden" features. I've been learning some of them. One of the really good parts of these features is the automation that is built in to them. Some of these features have been around since 2007, but they have been rarely talked about. I am going to provide links to free webinars, videos and articles talk about these features:
Get & Transform > Data Modeling > Tables > PivotTables > PivotCharts > Dashboards ... (PowerBI)
At the very end of the wiki there are links to free download PDF ebooks about these features.
Sorry for the run around. The wiki editor is freaking out again, wasting my time. I've cut the contents out of here and put them into a Word document that you can download from my OneDrive
https://1drv.ms/w/s!Am8lVyUzjKfpoBGWeAh0z876s7ri - Word Doc in OneDrive