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

Matching Items: Pick a region namefrom a drop down list, and Excel formulas show all the employee names from the selected region. No macros!

Pivot Tables: Build 2 pivot tables on one Excel sheet, from the same source data. Then add a Slicer to quickly filter both pivot tables

Excel Newsletter: Read the latest issue - Pivot table trick, multi-criteria lookup, and more. Don't miss the next issue - sign up to get it by email.

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.

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




Get weekly Excel tips from Debra




pivot power free




Excel Data Entry Popup List


DebraD on Twitter

Contextures on Twitter

Contextures on YouTube

Contextures on Facebook



Last updated: July 31, 2020 2:41 PM
Contextures RSS Feed