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.

SEE: How to use Find All to manipulate specific matching values in Excel (TechRepublic) Listing A shows a macro that automates the simple two-column sort that we ran in the last section.

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

Learn how to create a calendar in Microsoft Excel with data using a pre-designed template, Visual Basic code, or a manual method.