VBA has keyboard and mouseclick emulation, so I have used to automate mindless click-point-A, wait, click-point-B, wait, click-point-Next, wait-longer, repeat - type tasks.

I have helped someone who wanted to replicate a very complex formatting over multiple sheets (quick work that saved few hours) You can populate pre-defined slides, like just pasting data into a template save-as repeat Combine many excel files into one master file I could split 1 file into many based on a selected field name and format the files. If you do a certain type of formatting or combining data from multiple cells into one type thing. You can assign hotkey shortcuts to macros, that can get quick set of things done. You can create custom formulas that can do whatever custom calculations you like If you are looking for cool stuff, here it follows VBA is very versatile especially if you use a lot of Excel, the possibilities are limitless. VBA can be used to automate almost all repetitive tasks around almost all of office suite tools.

Visual basic for excel reddit