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.
Excel VBA how to move a sheet x times to the right
This video will show how to move a worksheet multiple times to the right in a workbook. Users will choose how many sheets to the right to move the worksheet.
Excel VBA insert columns all sheets
We are going to present one approach to insert multiple columns, in the same active column across all worksheets in an active workbook.
Insert multiple rows across sheets using VBA in Excel
Goal: To insert the same number of specified rows across all worksheets in a workbook. This article presents one approach in using a macro to…