Contextures

Contextures Excel Resources

Find the Excel resources that you need, here on Contextures. There are hundreds of Excel tutorials, step-by-step training videos, and sample Excel workbooks to download.

Author: Debra Dalgleish

Excel Tutorials

There's always something new to learn in Excel! Here are the links to some of my recent Excel tutorials.

FN0063

Compare 2 Lists -- See how to compare two lists to find new items, using the COUNTIF function. There are written instructions, a step-by-step video, and an Excel file to download

   
bingo cards

Bingo Cards - Create printable sets of 3 unique Bingo cards, filled with numbers or pictures. There are written steps, and 4 different Excel files to download

   
PT0046 Seating Plan -- Select guest names from a drop down list, and those names appear at the selected table in your seating plan. There are written steps, and an Excel file to download
   

Many More Excel Tutorials

Next, you can check out these popular Excel tutorials.

1 -- Key Skills in Excel - Do you know all of these key Excel skills?

2 -- How to Count Specific Cells - Count items in a list, based on one or more criteria

3 -- How to Do a VLOOKUP - Find a lookup item in a table, such price for a specific product

4 -- Create a Pivot Table - Summarize thousands of rows of data, with a few clicks, and no formulas!

For many more tutorials, go to the Excel Tips page. You'll find an Excel topic list there, with links to the tutorial pages.

Excel Video Training

Get started with these video training pages, for popular Excel topics - Drop Down Lists, Pivot Tables, Data Entry Tips, and VLOOKUP Examples.

 
     
 

 

Here is one of my latest Excel videos, and most of the Excel tutorial pages include a video too.

Excel Sample Files

Here are the download links for a couple of my latest Excel sample workbooks, and most of the Excel tutorial pages include a sample file too.

  • More Workbooks: For even more sample files, go to the Excel Sample Files page, where there are 200+ files for you to choose from.
  • Sample Data: If you need Excel sample data for practice or training examples, take a look at the data workbooks on the Excel Sample Data page.
CF0013 Canada and USA Flags
Choose a country name from drop down list. Conditional formatting shows the flag for the selected country. (No macros) Click this link to download the Country Flag workbook.
   
filter to different sheet Send Data to Different Sheet: Use an Advanced Filter to send the data to a different worksheet, based on criteria (No macros)

 

About Contextures

I'm Debra Dalgleish, the founder of Contextures, located in Canada.

Click here to learn more about me, and my Contextures site.

learn these key excel skills

Affiliate Disclosure: Debra Dalgleish is an Amazon Associate. As an Amazon Associate I earn from qualifying purchases

 

About Debra

Last updated: July 20, 2022 3:49 PM