In this video tutorial I explain how to get data to sort automatically when that data is changed or added to. Download the featured file here. Method 1: Using a Formula to Auto Sort Data Click here to view this part of the video. Only use this formula if you don’t use Excel 365. … Read More »Excel: Automatically Sort When Data Changes or Added | Auto Sort Excel Formula | Auto Sort Macro

  In this video tutorial I look at how to extract numeric and/or text characters from a text string in Microsoft Excel. The video looks at three different ways this can be achieved. Click here to download the featured file. Method 1: Using Power Query Click here to view this part of the video. If… Read More »How to Extract Numbers from Text in Excel | 3 Methods – Power Query, VBA & TEXTJOIN

  In this video tutorial I demonstrate how to create date sensitive alerts or notifications in Microsoft Excel. My worksheet tracks invoice due dates and I need it to notify me when an invoice is overdue. Click here to download the featured file. Method 1: Use a Formula Click here to view this part of… Read More »Due Date Pop-up Alert in Excel | Date Due Tracker – Formula & Due Date Color Change Notifications