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 ...

This is the code you'll need to add a personal formula in Excel VBA to calculate distances in KM between two differents pairs of latitude, longitude coordinates(as in -XX,XXXXXX;-XX,XXXXXX / ...

Microsoft's office software Excel is a powerful tool to perform day-to-day activities with, like simple arithmetic, sorting, filtering, arranging and summarising data in various formats. Excel has a ...

Learn how to insert local pictures into Excel cells using a formula and a simple VBA hack. Perfect for dashboards, reports, and data visualization. #ExcelTips #VBAHack #PictureInCell #ProductivityHack ...

Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance. I want to start off this post by thanking everyone ...

Hamza is a certified Technical Support Engineer. The “Compile error in hidden module” error occurs when you open a VBA project in Microsoft Excel. It occurs when ...

If Excel is not highlighting cells in the formula, read this post to know how to fix the issue. The default behavior of Excel is to highlight the cells that are part of a formula when a user ...