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
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
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
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
Bottom line: The SUBTOTAL Metrics Macro creates a summary table with SUBTOTAL formulas for each calculation type in the SUBTOTAL function.
Skill level: Intermediate
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
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
Bottom line: Learn 17+ Excel shortcuts to help you work faster in the new year.
Skill level: Beginner
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
Watch in full screen HD or on Youtube.
Bottom line: In this video you will learn one technique to quickly filter a column for duplicate values.
Skill level: Beginner
Grab My Free Cheat Sheet!
VLOOKUP Essentials Guide
