VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.

How do you navigate between worksheets in Excel? In Microsoft Excel, there are several ways you can navigate between worksheets in Excel, such as using shortcut keys, hyperlinks, using the VBA editor.

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.

Microsoft Excel’s sheet view collaboration feature is not new, but now it supports hiding rows and columns and applying groups.