This video will outline how to write a VBA dynamic ranges macro. It will enable users to seamlessly select a changing data range. We will…
Remove x characters from left of cell in Excel
Goal: Use Excel functions to remove x number of characters from the left of a cell. This video will present a non-macro approach to remove…
Creating a Three Dimension Data Table in Excel
This video will outline a way to create a three-dimension data table in Excel. It will be based on variables: unit price, units sold and number of sellers.
Goal: Create a what-if analysis using data table based on three variables.
How to extract the first word in a string with Excel VBA
Goal: A macro that will extract the first word in each cell string in a selected cell range. This post will show you one way…
How to extract the last word in a string with Excel VBA
This macro that will extract only the last word in a string across a selected cell range.
XMATCH – Practical Uses in Excel
Goal: Show users some practical applications of the Excel function, XMATCH This is a follow up to an earlier video that explored the new XLOOKUP…