Tag Archives: Free Excel Lessons

Video Lesson: Advanced Pivot Tables – Round 1

Pivot Tables are extremely useful in Excel.  This Advanced Excel video lesson is a follow-up to the Introduction to Pivot Tables and covers the first round of advanced topics. The lesson goes over some additional Pivot Table options and features including: … Continue reading

Posted in Data Input & Manipulation | Tagged , , , , , | 67 Comments

Video Lesson: Math and Statistical Functions

This Excel video lesson is about the Experience Level 1 Math and Statistical Functions in Excel.  Here is the level 1 function list extract from the Master Workbook that goes along with the video lesson. The formulas discussed in the video are as … Continue reading

Posted in Function-Related Lessons | Tagged , , , , , , , , , , , | 34 Comments

Video Lesson: Formula Auditing & Evaluation

Formula Auditing and Formula Evaluation are powerful components in Excel, and today’s video lesson goes over the following uses of the Formula Auditing features: Show Formulas:  How to change view to show formulas instead of cell results. Formula Evaluation:  See … Continue reading

Posted in Workbook/Reference Lessons | Tagged , , , , , , , , , | 5 Comments

Video Lesson: Advanced Lookup – Index & Match

The versatility and usefulness of the Index and Match functions are cherished by Excel veterans, but many less experienced users have either not encountered them, or are a bit confused by the usage of the two. This Excel Video Lesson … Continue reading

Posted in Function-Related Lessons, Workbook/Reference Lessons | Tagged , , , , , , , , , | 5 Comments

Video Lesson: Conditional Formatting in Excel

Conditional Formatting can be very useful when presenting data in a spreadsheet, or for allowing information to jump out to you easily. In the following video lesson I go over the following uses of it: – Formatting based on numerical … Continue reading

Posted in Formatting | Tagged , , , , | 88 Comments

Video Lesson: Introduction to Macros & VBA

Using macros in Excel requires knowledge of Visual Basic for Applications (VBA).  In this video lesson you will get an introduction to how macros work within Excel and how to build them.  The video lesson includes the following topics: – … Continue reading

Posted in Data Input & Manipulation, VBA / Macros | Tagged , , , , , , | 28 Comments

Video Lesson: Introduction to Pivot Tables

Pivot Tables are an extremely useful way of analyzing large sets of data quickly and easily in Excel. This video lesson provides a beginner’s introduction to Pivot Tables. Download the most recent Master Excel Workbook to follow along. Now that you … Continue reading

Posted in Data Input & Manipulation | Tagged , , , , | 70 Comments

Video Lesson: Advanced Filtering in Excel

Using auto-filters in Excel provides a useful way to drill down and extract data from spreadsheets. This video lesson explains multiple ways you can use filters in Excel. Make sure to download the most recent Master Workbook so that you … Continue reading

Posted in Data Input & Manipulation | Tagged , , , , , , | 16 Comments

Video Lesson: Logical Functions and Formulas

This Excel video lesson is about Logical Functions and Formulas in Excel.  Here are the formulas that I go through in the video lesson (click below for larger image): Logical formulas are extremely useful in more advanced Excel spreadsheets/methods and … Continue reading

Posted in Function-Related Lessons | Tagged , , , , , , , | 28 Comments

Quick Tip: Remove Duplicate Values from List

This gallery contains 2 photos.

Many times there are instances when you’ll have a large amount of data and you’ll want to be able to extract a listing of one specific column with only one line for each item type. For example, you may have … Continue reading

More Galleries | 14 Comments