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
There's always something new to learn in Excel! Here are the links to some of my recent Excel tutorials.
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 - Create printable sets of 3 unique Bingo cards, filled with numbers or pictures. There are written steps, and 4 different Excel files to download
|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|
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.
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.
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.
|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.
|Send Data to Different Sheet: Use an Advanced Filter to send the data to a different worksheet, based on criteria (No macros)|
I'm Debra Dalgleish, the founder of Contextures, located in Canada.
Click here to learn more about me, and my Contextures site.
Last updated: July 20, 2022 3:49 PM