PowerQuery
Now known as Get Data and Transform, this beauty allows you to automate repetitive cleaning and formatting of datasets. Any cleaning Excel can do, PowerQuery can do and more besides, so just dictate the task order once and you’ll never need to again. Use it quite literally take back weeks from your annual workload.
Powerpivot
Eliminates all the problems of pivot tables including only being able to run a pivot table from a single dataset, not being able to create complex calculations in pivot tables and hefty data usage. If you don’t fancy Power BI then use Powerpivot which has virtually the same analytical capabilities.
Solver
Got an end number, but not sure what inputs you need to get to that number? Goal seek might be the answer but if the problem is more complex then Solver is definitely worth learning. Take all the time and effort out of supplier, customer and bank statement recs or maybe even advanced budgeting?
