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: Instead of complex Excel formulas, use a pivot table to show MIN IF or MAX IF numbers. Mar 15, 2023

Unpivot with Power Query: Unpivot Excel data using Power Query, to create normalized column layout. Step-by-step guide, sample file. Mar 8, 2023

Contextures Blog: How to turn off the grey "Page 1" on your Excel worksheet. Mar 9, 2023

Debra D's Blog: Enter start and end dates on a Microsoft Access form, to use as date range criteria for a query. Mar 13, 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: March 22, 2023 12:52 PM