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

  In this video tutorial I explain how to keep a chart visible when scrolling up or down through a worksheet.  I explore two methods: Click here to download the featured file (including code) Video Table of Contents 00:00 – Introduction 00:18 – METHOD 1: Freeze Panes 00:49 – METHOD 2: VBA – see code… Read More »How to Keep a Chart (or Charts) Visible when Scrolling in Excel?

In this video I explore eight reasons why filtering in Excel might not be working properly (or at all!). Video Table of Contents Please use these time stamps to navigate the video – or watch the whole video instead! 00:00 – Introduction 00:09 – REASON 1: Data contains blank rows or columns 02:32 – REASON… Read More »Filter Drop-Down Not Working in Excel | Not Filtering All Columns or All Rows