Jon Acampora - 5/16 - Excel Campus
Jon Acampora

Author Archives: Jon Acampora

24

## How Slicers and Pivot Tables are Connected + Filter Controls Error

Bottom line: Learn about the pivot cache that creates an invisible relationship between slicers and pivot tables.  I also explain how to fix and prevent the connected filter controls error.

Skill level: Beginner

30

## Hide & Unhide (Filter) Columns with a Slicer or Filter Drop-down Menu

Bottom line: Have you ever wanted to use a slicer or filter to hide/unhide columns on a regular worksheet range or table?  Normally our data has to be in a pivot table to make use of the column filtering capabilities, but this simple macro allows us to hide and unhide worksheet columns with a slicer or pivot table filter.

16

## The NBC Olympic Commercials Dashboard

I love watching the Olympics.  It’s cool to see the best athletes in the world compete in fun, weird, and exciting sports.  And I’m always amazed at how close their results are.  Gold medals are often decided by a hundredth of a second.

As my wife and I started watching the Olympics on TV last week, we quickly noticed that there were a lot of commercial breaks during NBC’s nightly prime time coverage (NBC is the TV network that broadcasts the Olympics in the U.S.).  It seemed like there was a commercial break every 5 minutes.  We started wondering how many commercials we were watching.

So the Excel geek in me had to investigate…

39

## Excel Add-in Ribbon Disappears After Installation

Bottom line: A recent Microsoft Office security update has caused add-in Ribbon Menu Bars to disappear when Excel is opened.  This article contains a few solutions for this issue.

40

## Calculate Percentage Change for Negative Numbers in Excel

Bottom line: Learn how to create percentage change formulas in Excel with negative numbers.

Skill level: Intermediate

23

## How to Quickly Create Percentage Change Formulas with a Macro

Bottom line: Percentage change formulas require a lot of typing to create a simple calculation.  This macro will create the entire formula for you, including the IFERROR function.

Skill level: Intermediate

22

Bottom line: In this post I explain how to create a custom keyboard shortcut to jump to any row or column.  This solution uses a simple macro, and is much faster than the built-in methods in Excel.

Skill level: Intermediate

4

## How to Avoid the Select Method in VBA & Why

The first TV I remember us having as a kid did NOT have a remote control.  How inconvenient, right?

Every time someone in the family wanted to change the channel or volume, we had to get up off the couch and walk over to the TV to press a button.  You didn’t want to be the one sitting closest to the TV unless you needed some exercise… 🙂

12

## How to Prevent Excel from Freezing or Taking A Long Time when Deleting Rows

Bottom line: This quick tip will save you a lot of time when deleting rows from a filtered range or table in Excel.  Learn how to prevent Excel from freezing or crashing when deleting rows.

Skill level: Beginner

12

## Filter a Pivot Table or Slicer for the Most Recent Date or Period

Bottom line: Learn how to filter a pivot table, pivot chart, or set a slicer for the most recent date or period in the data set.

Skill level: Intermediate