Goal: To create a macro approach to an earlier video on removing characters from the left of each cell in a selection. Download Spreadsheet Vault…
Automatically highlight the active row in Excel
Goal: To write a simple worksheet macro event, which will highlight the active row that our cursor is on. Download Spreadsheet Vault SpreadsheetVault – Highlight…
XIRR formula across multiple sheets
Goal: We want to calculate the respective IRR for each entity on the summary sheet. Each entity contains its own worksheet, thus we need to…
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…
Excel VBA Dynamic Ranges in a Pivot Table
Goal: A macro to allow Excel users to dynamically update a change source data range in a Pivot Table. This tutorial will explore one way…