1
Create Keyboard Shortcuts to Select the First or Last Sheet in Excel
Bottom line: Learn how to create a keyboard shortcut to select the first or last sheet in Excel. There is no dedicated shortcut for this, so this solution uses a macro.
Skill level: Intermediate
7
How to Copy or Import VBA Code to Another Workbook
Bottom Line: Learn how to insert VBA code into your worksheets using four different techniques.
Skill Level: Beginner
44
Excel Table of Contents that Automatically Updates
Bottom Line: Learn to create a Table of Contents sheet that automatically updates whenever changes are made to sheets in an Excel workbook.
Skill Level: Intermediate
13
Macro Buttons to Add Fields to Pivot Tables
Bottom Line: Learn how to create simple macro buttons that users can click to instantly add or remove fields to Excel pivot tables.
Skill Level: Intermediate
7
2 Ways to Assign Keyboard Shortcuts to Macros
Bottom Line: Learn two different ways to create keyboard shortcuts to run macros, and discover the pros and cons for both methods.
Skill Level: Intermediate
46
Refresh Pivot Tables Automatically When Source Data Changes
Bottom Line: Learn how to use a simple macro to refresh pivot tables automatically whenever changes are made to the source data. I also share a non-macro solution to update the pivot tables when the file is opened. Includes video tutorial and Excel file download.
Skill Level: Intermediate
How to Enable the Developer Tab in Excel for Windows
Bottom Line: Learn how to enable the Developer tab on the ribbon so that you can access commonly used functions for Macros, VBA, and Add-ins. Works on all versions of Excel for Windows (Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Office 365).
Skill Level: Beginner
2
Keyboard Shortcuts for the VBA Intellisense Drop-down Menu
Bottom line: Learn two keyboard shortcuts for displaying the Intellisense menu, so you can autocomplete words in the VB editor.
Skill level: Intermediate
8
How to Create VBA Macro Buttons for Filters in Excel
Bottom line: Learn how to create macro buttons that apply filters to multiple columns in a filtered range or Table.
Skill level: Intermediate
1
How to Clear Filters with VBA Macros
Bottom line: Learn how to clear all filters, and filters on a single column with VBA macros. Includes code examples for regular ranges and Excel Tables.
Skill level: Intermediate
