The concept of recording a macro (telling a computer the steps you want it to do, and then it repeating it) is very different to telling the computer the outcome you want and it working out the steps.

Going back to the 'help me calculate the financial implications of a house purchase' example - making a macro might make your work repeatable, but doesn't avoid users needing to learn excel or needing to put in the effort to build the spreadsheet.