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
Microsoft just released a new update to Excel 2016 for Mac with two BIG new features: PivotCharts and a new VB Editor.
Bottom line: Pivot Charts are now available on Excel 2016 for Mac (Office 365).
Skill level: Beginner
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
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
Bottom line: Learn why using an Excel Table as the source of a pivot table can save time and prevent errors.
Skill level: Beginner
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
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
Bottom line: Learn how to use the AutoSum feature and keyboard shortcut to create SUBTOTAL formulas.
Skill level: Beginner
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
Grab My Free Cheat Sheet!
VLOOKUP Essentials Guide
