Microsoft Excel allows us to create Custom Excel Functions or User Defined Functions using VBA. We can create Custom Excel Functions with the functionality we want and they can be accessed in the ...

One of the great things about Microsoft Excel is the ability to automate useful functions. When a business spreadsheet contains hundreds or even thousands of rows, you may find it difficult to ...

As an Excel user, you may be familiar with the basic concepts of cells and ranges. But when it comes to using Visual Basic for Applications (VBA) to work with Excel, it’s important to have a deeper ...

I use my coding skills to solve real business issues in will to improve key business processes. This repository demonstrate some of excel and google sheets scripts I developed, all presented scripts ...