This video will present a solution for returning the largest value across a data range, which contains text, errors and blanks. In normal circumstances we…
How to change from exponential to number format in Excel – Advanced
Welcome, this is a follow-on video to an earlier presentation with solving exponential number format problems with numerical cells, especially when dealing with Excel csv…
XLOOKUP formula across multiple sheets
Download Spreadsheet Vault SpreadsheetVault – XLOOKUP formula across multiple sheets (solution).xlsb
SLOPE & INTERCEPT function to forecast ROI
This video will present you one way to forecast data based on historicals. In this example, we will plot the relationship between the Cost per…
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…
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…