22
Column Chart That Displays Percentage Change or Variance
Bottom line: Learn how to create a column chart that displays the percentage change or variance between the columns.
Skill level: Intermediate
12
7 Shortcuts for Working with Worksheet Tabs in Excel
Bottom line: Learn time saving tips and shortcuts for selecting and copying worksheet tabs. Includes a few simple VBA macros.
Skill level: Beginner
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
6
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
50
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
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
12
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
45
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