There are many times where you will need to acquire a unique value from not just one list of values, but from two separate lists. Getting a unique value from a single list is straightforward, and can be accomplished in …
Tag: power query
VBA in 2020 – Where does it fit?
Since 1993, Visual Basic for Applications has been the first choice for Excel automation. As a programming language that was available for business users, millions of macros have been created in VBA. But, is VBA still relevant in 2020? Popularity …
Import Data into Excel – Multiple Methods
There are many different methods to import data into Excel! However; it is still commonplace to cut and paste data from the data source (normally another spreadsheet) into Excel. There are several different methods to import data into Excel. Use …
Power Query – Clean data for the Data Model
In previous exercises, we used the FILTER() function in order to remove the totals from our data model. Using Power Query, clean data is provided to the data model. Filtering before the data model improves the performance of the model, …
Creating a Basic Loan Amortization Schedule Without Code
An amortization schedule contains details with respect to a loan, including the following: The principal amount of the loan. The interest on the loan (typically reflected in annual terms). The length of the loan (typically reflected in years; except in …