This article and video will show you one way to break external links from only selected cells in an Excel workbook. As we can see,…
Excel Goal Seek across columns
This article and video will outline one approach to generate a Goal Seek across multiple columns in Excel. As per the following screenshot, we have…
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.
Insert multiple columns using Excel VBA
This video will outline an approach via VBA, to insert multiple columns at once into an Excel worksheet. This insert multiple columns macro will give us the flexibility, to choose numerous columns to insert simultaneously.
Insert multiple rows using Excel VBA
Presently Excel only allows users to insert one row at a time. But what if we had the capacity to choose and insert numerous rows simultaneously? This video will outline one way, via Visual Basic for Applications or VBA, to insert multiple rows simultaneously into an Excel worksheet.
Excel Flash Fill in Financial Modeling
This article illustrates how to use the Excel tool, Flash Fill, for the purposes of financial modeling and business planning. Excel Flash will be demonstrated across a number of instances, and highlight how it can be an incredibly powerful and time-saving tool in financial modelling. This is especially so with large data sets.