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
5
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
107
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
18
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
4
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
11
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
35
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
1
VBA Assumes the Active Workbook and Active Worksheet in Excel
Bottom line: Learn 2 critical assumptions that VBA makes when running our macros in Excel, and avoid errors & disaster.
Skill level: Beginner
17
Only Display Used Fields on Pivot Table Show Details Sheet
Bottom line: Learn how to create a Show Details Drill Down Sheet from a pivot table that only contains the fields (columns) used in the pivot table.
Skill level: Intermediate
28
18 Excel VBA Macro Shortcuts for 2018
Bottom line: Learn 18 tips & shortcuts to save time with writing VBA macros for Excel or other Office applications.
Skill level: Intermediate
