Here is where the magic of VBA (Virtual Basic for Applications) comes in. It's an undiscovered Excel feature for creating custom functions, which has entirely changed how I handle my spreadsheets.

Learn how to enable or disable Trust access to Visual Basic Project in Word, Excel, PowerPoint. Turn it on or off using REGEDIT, GPEDIT, and in-built settings.

Become an Excel expert. For a limited time, you can get The Complete Microsoft Excel Course Including How to Program in Excel for 75% off $40 at just $10.

Using VBA makes quick work of entering dates into the future or past into a Microsoft Word document. Here's how to use it.