36

## 2 Ways to Use the Ctrl+Enter Keyboard Shortcut in Excel

Bottom line: Learn a few quick ways to use the Ctrl+Enter keyboard shortcut to save time with entering data or formulas.

Skill level: Beginner

45

## Progress Doughnut Chart with Conditional Formatting in Excel

Bottom line: Learn how to create a progress doughnut chart or circle chart in Excel.  This chart displays a progress bar with the percentage of completion on a single metric. We will apply conditional formatting so that the color of the circle changes as the progress changes.  This technique just uses a doughnut chart and formulas.  It is pretty easy to implement.

Skill level: Intermediate

80

## 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

30

## 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

22

## 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

17

## 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

94

## 17 Excel Shortcuts for 2017

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

Skill level: Beginner

11

## 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.