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.

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.

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.

Our visual guide helps you find the most popular commands on the Ribbon in Excel 2016 and 2019 for Windows, along with keyboard shortcuts for performing each action.