Contextures

Key Skills > Excel Tips

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

Data Validation | Pivot Tables | Formulas | Macros | Format | Charts | Filters


What's New

Pivot Table Blog: Show extra subtotals in pivot table, without adding columns. Watch for limitations though!. Jan 25, 2023

Debra D Blog: This Ode to Microsoft Excel, for Robert Burns Day, gives humorous "burns" to other spreadsheets. Jan 25, 2022

Contextures Blog: Can ChatGPT write Excel TEXTJOIN formulas? See my test results. Jan 19, 2023

Combine Text: Combine text and numbers from multiple cells with Excel TEXTJOIN function. 7 examples, basic to advanced Jan 18, 2023

Also see: Pivot Table Blog || RSS || Debra D Blog || What's New

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: January 25, 2023 11:32 AM