Excel Tips and Tutorials

An extensive collection of easy-to-follow Excel tutorials, with videos, free workbooks and step-by-step instructions.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z | Pivot Tables Blog

Newsletter Index | Pivot Table Index | VLOOKUP | COUNT | SUM

What's New

Interactive Filter: Interactive dynamic filter for Excel 365 table. Change filter settings with drop down lists, no macros. Nov 25, 2021

Contextures Blog: How to fix an Excel table that doesn't expand automatically for new data. Nov 25, 2021

Cluster Stack Pivot Chart: See how to create a Cluster Stack Pivot Chart from a pivot table. Use named Excel table or see how to unpivot data with Power Query. Sept 27, 2021

Excel Newsletter: Read the latest issue - List every 3rd item, make a flexible formula, and more. Nov 16, 2021

Also see: Previous News || RSS || Debra D Blog

Note: Some Excel tutorial links are to Contextures Blog and Contextures Pivot Table blog.

Popular Tutorials

Select Multiple Items from Drop Down

Excel Cluster Stack Chart

VLOOKUP Function

Excel Count Functions

Conditional Format Examples

Create a Pivot Table

My Blogs

Contextures Blog

Pivot Tables Blog

Debra's Blog

Spreadsheet Day



About Debra

Last updated: November 25, 2021 3:51 PM