8
2 Ways to Remove Duplicates to Create a List of Unique Values in Excel
Bottom line: In this article and video I explain 2 ways to remove duplicates to create a list of unique values. We look at the Remove Duplicates feature and a macro that makes the process much faster.
Skill level: Intermediate
2
New VB Editor for Excel 2016 for Mac
Bottom line: A new updated VB Editor has just been released for Excel 2016 for Mac to make it easier to write VBA Macros.
Skill level: Beginner
31
3 Ways to Delete Entire Blank Rows + Video Tutorial
Bottom line: Learn a few ways to delete entire blank rows from a data set or table in this article and video.
Skill level: Beginner
33
How to Stop Pivot Table Columns from Resizing on Change or Refresh
Bottom line: Learn how to prevent or disable the columns in a pivot table from resizing when the pivot table is updated, refreshed, changed, or filtered.
Skill level: Beginner
12
2 Keyboard Shortcuts to Select a Column with Blank Cells
Bottom line: Learn a few keyboard shortcuts to select all the cells in a column of the used range. This is a solution for when the Ctrl+Shift+Down Arrow or Ctrl+Shift+End shortcuts don’t work.
Skill level: Intermediate
33
The For Next and For Each Loops Explained for VBA & Excel
Bottom line: The For Next Loops are some of the most powerful VBA macro coding techniques for automating common tasks in Excel. This article explains how the loop works to repeat actions on a collection of items, which saves us a ton of time with our jobs.
Skill level: Intermediate
22
Automatic Default Number Formatting in Excel Pivot Tables
Bottom line: Save tons of time by automatically formatting the numbers in the Values area of your pivot tables with a VBA macro. Number formatting is automatically applied when you drag a field into the Values area in one single step.
Skill level: Intermediate
14
3 Tips to Save and Close All Open Excel Workbook Files + Macro
Bottom line: Learn a few shortcuts and tips to save and close all open Excel workbooks.
Skill level: Beginner
9
The SUBTOTAL Metrics Macro – Create a Summary Table of All Function Types
Bottom line: The SUBTOTAL Metrics Macro creates a summary table with SUBTOTAL formulas for each calculation type in the SUBTOTAL function.
Skill level: Intermediate
12
VBA Code Modules & How to Run Macros Based on User Events
Bottom line: In this post we compare the different places to store macros, functions, & VBA code in Excel. We specifically look at the Code Modules, Sheet Module, and ThisWorkbook Module to learn the differences between how each works. We also learn how to run macros based on events or actions by the user.
Skill level: Intermediate
