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

Contextures Blog: Add letter headings in Excel drop down, so it's easy to find items in long list. Optional macros add/remove headings. Jan 21, 2021

Pivot Table Blog: For visual impact in an Excel pivot table, use conditional formatting data bars. Jan 13, 2020

Excel Newsletter: Read the latest issue - Headings in drop down lists, line breaks with TEXTJOIN, and more. Don't miss the next issue - sign up to get it by email. Jan 26, 2021.

Also see: Previous News || Excel Events || RSS || Excel Humour || 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

Don't Miss Our Excel Tips

Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.

Get weekly Excel tips from Debra



My Blogs

Contextures Blog

Pivot Tables Blog

Debra's Blog

Spreadsheet Day



Last updated: January 26, 2021 9:53 AM
Contextures RSS Feed