Tearing down the 5 pillars of Excel inefficiency

We like to think we are efficient in our jobs. However, there are 5 time-wasting activities that Excel users do without even thinking about it. In this session, we look at how Power Query enables us to remove these inefficiencies, which releases us to spend more time doing the things we love.

The 5 pillars are:

• Incorrect naming convention methodology
• Lack of parameterisation
• Calculating on information
• Copy and pasting
• Updating formulas