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…
XLOOKUP – Practical Uses in Excel
This video will look into the new XLOOKUP function, compare it to the VLOOKUP and HLOOKUP and see it’s practical applications in spreadsheets.
Excel SUMPRODUCT financial modelling examples – part 2
This feature explores further practical applications of Excel SUMPRODUCT. This is a follow-up to an earlier video on uses to the SUMPRODUCT function.
Excel SUMPRODUCT financial modelling examples
This case study will present practical uses of the Excel SUMPRODUCT function. The SUMPRODUCT function is still a viable alternative to SUMIF or SUMIFS.