Tag Archives: Free Excel Training Online

Alternative to Merged Cells (Quick Tip)

Typically, many users are drawn to the Merged Cells feature in Excel, despite it having some significant disadvantages (especially related to copy/paste of ranges). Frequently, Merged Cells are used in areas to group cells together visually, which can be done … Continue reading

Posted in Quick Tips | Tagged , , , , | 6 Comments

VBA Walkthrough #2: Message Encoder & Decoder

This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros. The lesson covers these specific areas of VBA usage: – For…Next loop (including nested loops) – … Continue reading

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

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