4
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
49
New Excel Features: Dynamic Array Formulas & Spill Ranges
Bottom Line: Learn about the new Dynamic Array functions and formulas that will eventually replace the Ctrl+Shift+Enter array formulas.
Skill Level: Beginner
43
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
10
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
5
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
44
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
8
7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel
Bottom Line: Save time by learning seven ways to select cells and ranges using keyboard shortcuts.
Skill Level: Beginner
19
How to Add New Rows to Drop-down Lists Automatically – Dynamic Data Validation Lists
Bottom Line: Learn to create dynamic data validation lists. These in-cell drop-down lists automatically expand to include new rows that are added to the source data range.
Skill Level: Intermediate
7
How to Create Drop-down Lists in Cells – Data Validation Lists
Bottom Line: The complete Excel guide on how to create drop-down lists in cells (data validation lists). Includes keyboard shortcuts to select items, copying drop-downs to other cells, handling invalid inputs, updating lists with new items, and more.
Skill Level: Beginner