Tag Archives: Free Excel Training

Video Lesson: Beginner’s Introduction to Excel

One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works.  I’ve created this lesson in … Continue reading

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

VBA PO Generator: Homework Solution Part 1

The following is a guest video lesson provided by Chris H. (reddit: Kristofmic). In this video series we’ll follow along with solutions to the advanced homework for the VBA Purchase Order Generator Walkthrough. In Part 1 of the homework solution, … Continue reading

Posted in VBA / Macros | Tagged , , , , , , , | 3 Comments

Video Lesson: Basic Excel Formatting Techniques

Today’s video lesson goes through some of the basic formatting techniques in Excel 2010: – How to Use the Auto-Fill Drag Handle / Fill Series Options – How to Use the Format Painter – Freeze / Unfreeze Panes – Sheet … Continue reading

Posted in Formatting | Tagged , , , , , , , | 96 Comments

Guest Excel Lesson: Introduction to Tables

User VertexVortex has been helping users out on r/Excel for quite a while.  After reaching out to him on Reddit, he agreed to help out by creating a lesson of his own specifically for this site.  Here’s his guest lesson on … Continue reading

Posted in Data Input & Manipulation | Tagged , , , , , , | 8 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