Create Dynamic Pivot Chart Titles with a VBA Macro
Bottom line: Learn how to automatically create more descriptive and dynamic chart titles that display the filter criteria with VBA macros.
Skill level: Intermediate
How to use Chart Templates for Default Chart Formatting
Bottom line: Learn how to use Chart Templates in Excel to quickly apply formatting and settings to new and existing charts. Includes instructional videos.
Skill level: Beginner
Excel Shortcuts to Move the Selected Range with the Arrow Keys
Bottom line: Learn how to create custom shortcuts to move the selection to an adjacent range. This technique is great for selecting rows or columns that contain blank cells.
Skill level: Intermediate
5 Uses for VBA Macros in Excel with Your Job
Bottom line: Learn 5 ways to use VBA macros to automate Excel tasks you do frequently at work.
Skill level: Beginner
3 Tips for Writing Formulas with VBA Macros in Excel
Bottom line: Learn 3 tips for writing and creating formulas in your VBA macros with this article and video.
Skill level: Intermediate
Formula Challenge: Find the First Transaction for Each Month
Bottom line: In this Excel formula challenge you will learn how to write a formula to find the first date for each month in a set of data.
Skill level: Intermediate
Why Table Number Formatting Doesn’t Copy Down and How to Fix It
Bottom line: Learn why the number formatting for new rows of a table doesn’t always get copied down and how to fix it.
Skill level: Beginner
How to Turn Off GETPIVOTDATA Formulas for Pivot Tables
Bottom line: Learn how to turn the GETPIVOTDATA formulas on/off when you create a formula that references a cell inside a pivot table.
Skill level: Beginner
How to Change Date Formatting for Grouped Pivot Table Fields
Bottom line: Learn how to change the date formatting for a grouped field in a pivot table.
Skill level: Intermediate
Expand and Collapse Entire Pivot Table Fields – VBA Macro
Bottom line: Learn how to add buttons to your pivot tables and pivot charts to quickly expand/collapse entire fields using a VBA macro.
Skill level: Intermediate
