Scripting allows you to automate frequent computer tasks like backing up folders and
VBA is great for automating tasks in Microsoft office. It integrates tightly with the applications allowing for detailed control. Most of my experience is manipulating data in Excel. VBA allows extending Excel forms to be very powerful.
Python is great for manipulating data and creating reports. It has a lot of powerful libraries for processing data. This is a great step up from VBA if you need something more powerful.
AutoHotKey is meant for binding hotkeys to common tasks. It can be used to automate interaction with forms that need to be completed frequently or to open frequently used applications. It is also excellent at navigating deep application menus or typing frequent responses with the press of a button.