Tag Archives: Microsoft Excel Help

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: Information Functions in Excel

In the following lesson I go through the Experience Level 1 Information Functions.  These functions are used to obtain information about formatting & referencing about specific cell or range references.  In this lesson I review the following functions: ISBLANK – … Continue reading

Posted in Function-Related Lessons | Tagged , , , , , , | 7 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

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

Excel Video Lesson: Data Validation

This Excel video lesson walks you through how to set up Data Validation rules.  The main purpose of Data Validation is to set up rules so that only certain types of information can be entered into cells (which helps to … Continue reading

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