How to create Macros in Excel without Scripting

If you are someone who often spend time cleaning and processing raw and dirty data in spreadsheets you know how repetitive some tasks can be like filtering the data, sorting it, trimming unwanted spaces or writing same function several time. I mean y...