Contextures Excel Resources

Debra Dalgleish - Contextures

Thanks for visiting my Contextures site! I'm Debra Dalgleish, and you'll find hundreds of Excel tutorials that I've written, along with my step-by-step training videos, and tons of sample Excel workbooks that you can download. If there's a topic that you'd like me to add, let me know!

Excel Tutorials

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

FN0063

Printable Calendar - Type year and month number, to create a printable Excel calendar with the month's holidays highlighted. Or, get the printable event calendar - it shows 5 events per day.

FN0063

Count Blanks - In a pivot table, see how to count blanks in source data cells. Fix problem, get correct count of empty cells. Video, written steps, Excel file

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
MORE For many more tutorials, go to the Excel Tips Index page. You'll find an Excel topic list there, with links to the tutorial pages.

Excel Videos

I love to make Excel videos, and here's one of my latest ones.

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.

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)

 

DATA Sample Data: If you need Excel sample data for practice or training, take a look at my Excel Sample Data page.
MORE

More Workbooks: For even more sample files, go to the Excel Sample Files page, where there are 200+ files for you to choose from.

Excel Topics

Here are a few of the most popular Excel topics that I cover in my tutorials and videos. You can also check the Excel Tips Index page for links to specific topics.

FN0063

Pivot Tables -- Use Excel Pivot Tables to quickly summarize data from a list or Excel table. See how to get started, then learn more about the power of pivot tables!

To learn more, go to the Excel Pivot Table topic page.

bingo cards

Formulas - Use Excel formulas and functions to summarize data, return values from a lookup table, do mathematical calculations, and much more!

To learn more, go to the Excel Formulas topic page.

PT0046

Data Validation -- Use the Excel data validation feature to create drop down lists on a worksheet. Or, use data validation rules to control what can be entered into worksheet cells.

To learn more, go to the Excel Data Validation topic page.

MORE For more Excel Topics, go to the Excel Topics Index page.

About Contextures

Debra Dalgleish - Contextures

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

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

Get Monthly Excel Tips!

Be sure to get my monthly newsletter, with quick Excel tips, links, news, and a bit of fun. Just add your email, then click Subscribe.

 

 

learn these key excel skills

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

Last updated: June 13, 2024 3:10 PM