Jon Acampora

Author Archives: Jon Acampora

78

## 3 Tips for Calculating Week Numbers from Dates in Excel

Bottom line: Learn a few tips and techniques for calculating week numbers from dates, the number of weeks between dates, and how to display the week number in cells for reporting.

Skill level: Beginner

18

## 2 Ways to Reverse Number Signs Positive Negative in Excel

Bottom line: Learn 2 ways to reverse the sign of a number from positive to negative or negative to positive in Excel.

Skill level: Beginner

27

## 3 Ways to Display (Multiple Items) Filter Criteria in a Pivot Table

Bottom line: Learn how to create a list of the (Multiple Items) that are filtered for in the pivot table Fields area.

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

15

## The Excel SUBTOTAL Function – Calculations on Filtered & Visible Cells Only

Bottom line: Learn how the SUBTOTAL function works in Excel to create formulas that calculate results on the visible cells of a filtered range or exclude hidden rows.

Skill level: Beginner

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

91

## 17 Excel Shortcuts for 2017

Bottom line: Learn 17+ Excel shortcuts to help you work faster in the new year.

Skill level: Beginner

10

## Pivot Table Defaults to Count Instead of Sum & How to Fix It

Bottom line: Learn how to get the pivot table to default to a Sum calculation instead of Count when the source data field contains numbers.

Skill level: Beginner

## Video: How to Default the Pivot Table Calculation Type to Sum

Watch in full screen HD or on Youtube.

10

## How to Filter for Duplicates with Conditional Formatting

Bottom line: In this video you will learn one technique to quickly filter a column for duplicate values.

Skill level: Beginner

## Filter Multiple Columns – Free Video Training Series – Part 3 of 3

Bottom line: In this 3rd video of the series on Excel Filters you will learn how to filter multiple columns.  I explain the rules Excel uses when multiple columns are filtered, and how to use OR logic.

Skill level: Beginner