A collection of Excel VBA macros, organized as .bas code modules for easy reuse and import into any Excel workbook. These macros cover: Data cleaning and transformation Smart exports (CSV, Markdown) ...

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

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

On the Developer tab, click the Visual Basic button in the Code group. A Microsoft Visual Basic for Application window will open. Click the Insert tab and select Module in the menu. A new model is ...

Microsoft Excel allows you to control the program display in various ways, including complete personalisation of the top ribbon. If you're finding the large top ribbon to be troublesome, we'll show ...