Excel and Excel-VBA Built-In and Custom Tools for Productivity

How to automatically consolidate data from multiple workbooks and worksheets using VBA

Sometimes we have a task to go through a number of files and make some changes in each of them or pull data from them. In this article we will have a look at the Excel-VBA code which allows to do all of that.

Excel VBA Basics - Express Guide & Ready-To-Go Code

All you need to know to get rid of 80% of your routine and focus on more interesting tasks

In the first part we will discuss instruments, which I wish I have known how to use when I have started my first job as a Budget Analyst. They would have allowed me to automate 80% of the routine and save hundreds of hours of time.