Skip to content

Tutorial

Find & Replace Multiple Words or Characters at Once in Excel | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro

    In this video I demonstrate how to find and replace multiple words at once in Excel. I explore three methods that can be used to achieve this. Click here to download the featured file Video Table of Contents 00:00 Introduction 00:44 METHOD 1: Use VLOOKUP or XLOOKUP for whole word find and replace Here’s the… Read More »Find & Replace Multiple Words or Characters at Once in Excel | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro

    Excel: Copy Filtered Data to Another Worksheet Automatically | Advanced Filter (With VBA) & FILTER

      In this Microsoft Excel video tutorial I demonstrate how to copy filtered data to another worksheet automatically. I explore two methods: Click here to download the featured file METHOD 1: Use the Advanced Filter with VBA The advanced filter allows you to copy filtered results to another worksheet but it doesn’t update automatically if you… Read More »Excel: Copy Filtered Data to Another Worksheet Automatically | Advanced Filter (With VBA) & FILTER

      Jump to Today’s Date in Excel | Hyperlink Formula or VBA Macro to Find Today’s Date in Worksheet

        In this video I demonstrate how to find and select a cell containing today’s date. I explore two methods. The first method uses the HYPERLINK, MATCH and TODAY functions within a single formula, and the second method uses a VBA macro. Click here to download the featured file. Table of Contents 00:00 – Introduction 00:16… Read More »Jump to Today’s Date in Excel | Hyperlink Formula or VBA Macro to Find Today’s Date in Worksheet