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

Macrordinary

  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Updated on December 19, 2019December 20, 2019/ Brent Allen

INDEX / MATCH – How does it work?

INDEX / MATCH – How does it work?

Up until the release of the XLOOKUP function, there has been significant debate in the Excel community around which function is better – VLOOKUP, or INDEX / MATCH. But, what is INDEX / MATCH? This is a combination of 2 …

Read More
Updated on December 16, 2019December 17, 2019/ Brent Allen

ALL() and CALCULATE() – Percentage of a column

ALL() and CALCULATE() – Percentage of a column

In the last post, we started using the CALCULATE() function to filter out some of the values that we didn’t want on our totals. This was done in order to get a pivot table that didn’t need to use the …

Read More
Updated on December 15, 2019December 9, 2019/ Brent Allen

FILTER and CALCULATE – Removing pre-calculated totals.

FILTER and CALCULATE – Removing pre-calculated totals.

In the last post, we started using the CALCULATE() function to filter out some of the values that we didn’t want on our totals. This was done in order to get a pivot table that didn’t need to use the …

Read More
Updated on December 5, 2019November 22, 2019/ Brent Allen

Sum of a row using CALCULATE()

Sum of a row using CALCULATE()

In the last post, we created a custom field in the Excel data model; however, we still needed to use Excel formulas to calculate the percentage of a row. In this example, we will be using a simple CALCULATE() function …

Read More
Updated on November 27, 2019November 13, 2019/ Brent Allen

Custom Field for Quarterly Data in the Data Model

Custom Field for Quarterly Data in the Data Model

As part of the Quarterly Report case study, we built a report using the data model, but there were still some instances where we used Excel formulas. In this post, we will be creating a custom field so that there …

Read More
Updated on January 1, 2020November 11, 2019/ Brent Allen

Quarterly Report – Using the Data Model

Quarterly Report – Using the Data Model

In this post, along prior two posts, I discussed a hypothetical case where data has been provided and your job (as the analyst) will be to create a quarterly report detailing sales of 2018 new vehicles in Canada. This post …

Read More
Updated on November 27, 2019November 7, 2019/ Brent Allen

Quarterly Report – Pivot Table

Quarterly Report – Pivot Table

In this post, along with the next few posts, I will be discussing a hypothetical case where data has been provided and your job (as the analyst) will be to create a quarterly report detailing sales of 2018 new vehicles …

Read More
Updated on November 7, 2019October 29, 2019/ Brent Allen

Quarterly Report – Using SUMIFS()

Quarterly Report – Using SUMIFS()

In this post, along with the next few posts, I will be discussing a hypothetical case where data has been provided and your job (as the analyst) will be to create a quarterly report detailing sales of 2018 new vehicles …

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
Updated on November 4, 2019October 11, 2019/ Brent Allen

Using PMT() to calculate installments

One of the most commonly used financial functions is the payment function – the PMT() function. This formula replicates the mathematical equation below: Instead of using the mathematical equation, the Excel formula uses a much simpler list of arguments. =PMT(interest …

Read More

Posts navigation

Page 1 Page 2 Page 3 Page 4

Recent Posts

  • LET Function in Excel: A Name Parsing Example
  • Make a KPI Card like Power BI – In Excel!
  • Top N Results from Excel using Dynamic Arrays
  • DA-100 – The Certified Data Analyst Exam
  • Ranges in Office Script – They are different than VBA!

Categories

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