This video will look into the new XLOOKUP function, compare it to the VLOOKUP and HLOOKUP and see it’s practical applications in spreadsheets.
Random selection (no duplicates) from a list in Excel
This video is a follow-on to an earlier video (https://youtu.be/m0_3e9DVtIQ), which looked at one approach to generate random, yet specific values from a list in…
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.
Shuffling data with HLOOKUP
Here is a great and effective approach to shuffle columns of data. It will use the Excel HLOOKUP function, and not require any VBA macros or complicated re-engineering of this summary worksheet.
Converting between the two Excel Date Systems in Financial Modelling
Excel supports two date systems, the 1900 and 1904 date system, which can pose potential problems in financial modelling. The 1900 date system is synonymous with Microsoft Excel for Windows, whilst Excel for Mac © (Apple) apply the 1904 date system.
5 Potential Problems using Excel VLOOKUP
This financial model illustrates the potential problems or pitfalls with the Excel VLOOKUP function in financial analysis. In this example, we are using a VLOOKUP to reference the Last price for the following Dow Jones Industrial Average stocks.