Sometimes at work we need to calculate specific metrics, KPIs or just simple percentages, with this principles you can create virtually any calculation you need for work. Having these calculations as ...

As part of the hiring process before I joined the Desktop Build Group as an Excel/VBA specialist at Bloomberg in 2015, they asked me to send over a sample project for them to review. I remember ...

Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...