How to Automate Excel Spreadsheets? What is Excel Automation? Luckily it's also relatively easy to learn Power Query compared to VBA or even Excel Formulas. phone apps to high frequency trading platforms and everything in between. A ready-made costing template with a detailed description of the formulas allows to learn how to calculate the production cost price from the sphere of trade.