Tag Archives: Advanced Excel Tutorial

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: 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

VBA Walkthrough #1: Purchase Order Generator

VBA Macro Walkthrough One of the best ways of learning VBA is to take a look at completely functioning macros & code to see how others approach a problem.  In this video lesson, I walk you through a Purchase Order … Continue reading

Posted in VBA / Macros | Tagged , , , , , , | 19 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

Excel Training Lesson Plan Posted

I just updated the site with a proposed lesson plan to give everyone an idea of the topics that I plan on covering throughout the course. I may jump around between topics depending on what makes more sense and what … Continue reading

Posted in News / Updates | Tagged , , , , , , , , , , | 3 Comments

Welcome to Excel Exposure!

I’ve created this site as part of the University of Reddit course (this information is posted here as well). The goal is to expose the world to the amazing functionality of Microsoft Excel. I hope to make this site an … Continue reading

Posted in News / Updates | Tagged , , , , , , , , , , | 1 Comment