Skip to content (Press Enter)
  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Macrordinary

Macrordinary

  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Home>power query

Tag: power query

Updated on May 11, 2022May 11, 2022/ Brent Allen

Unique Values from 2 Lists in Excel – Multiple Methods

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 …

Read More
Updated on July 13, 2020July 13, 2020/ Brent Allen

VBA in 2020 – Where does it fit?

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 …

Read More
Updated on May 28, 2020May 28, 2020/ Brent Allen

Import Data into Excel – Multiple Methods

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 …

Read More
Updated on January 25, 2020January 2, 2020/ Brent Allen

Power Query – Clean data for the Data Model

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, …

Read More
Updated on November 27, 2019October 20, 2019/ Brent Allen

Creating a Basic Loan Amortization Schedule Without Code

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 …

Read More

Recent Posts

  • Non-Unique List in Excel: Showing Only Duplicates
  • BYROW() in Excel: A Marginal Tax Schedule Example
  • Unique Values from 2 Lists in Excel – Multiple Methods
  • LAMBDA() in Excel – Generating an Amortization Schedule
  • LET Function in Excel: A Name Parsing Example

Categories

  • dashboards
  • excel
  • financial formulas
  • formulas
  • M
  • office script
  • pivot tables
  • power apps
  • power bi
  • power pivot
  • power platform
  • power query
  • scripts
  • VBA
Copyright © 2023 Macrordinary. Software Company | Developed By Rara Theme. Powered by WordPress.