Become an Excel Expert

Contextures can help you become an Excel expert, with hundreds of Excel tutorials, videos, and sample files, time-saving Excel tools, and our popular Excel newsletter.

Click the links below, to get started now!

Excel Tutorials

Start with these popular tutorials, or go to the full index on the Excel Tips page.

• Excel, Key Skills
• How to Count Specific Cells
• How to Do a VLOOKUP
• Create a Pivot Table

Next, check out what's new. Here are the latest tutorials:

• FILTER Function Lookup
• Compare Cell Values
• EXACT Function
• Seating Plan, Guest Tables
• Show Target Range in Line Chart
• Show Hidden Data in Chart or Sparkline
• Pivot Table - Highlight Weekend Dates
• Report Diagnostic - Pre-Print Check
• WORKDAY and WORKDAY.INTL Functions
• Copy & Paste Problems
• Interactive Dynamic Filter
• Cluster Stack Pivot Chart
• Remove Duplicates - Number Problem
• Fix Conditional Formatting Extra Rules
• Change Excel calculation options
• Sum or Count Based on Date Range
• Drop Down List - Top Items

And here's one of my latest Excel videos:

Excel Files

1. You'll find Excel workbooks on most of the Excel tutorial pages.
2. For even more sample files, go to the Excel workbooks page, where there are more than 200 files for you to select from.

Excel Tools

Save time with these free Excel tools from Contextures.

• Pivot Power Free Add-in - Time-saving tools for pivot table users
• Excel Free Backup Tool - Quickly save a copy of your active file, in the current folder

About Contextures

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

Click here to learn more about Contextures

 

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