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: Video shows MID formula to reverse first and last names in Excel. See how it works, and see a longer formula too. Apr 15, 2021

Pivot Table Blog: Analyze sales data with Pivot Table Top 10 filters. Change settings on worksheet, macro changes multiple pivot table filters automatically. Apr 7, 2021

Data Validation: Use simple data validation rules to limit budget entry amounts that can be entered in Excel budget plan. Video, written steps, free Excel workbook Mar 23, 2921

Excel Newsletter: Read the latest issue - Hide used items in drop down list, currency symbol switch, and more. Don't miss the next issue - sign up to get it by email. Apr 6, 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

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: April 15, 2021 2:40 PM
Contextures RSS Feed