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

Macrordinary

  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Updated on December 10, 2020December 10, 2020/ Brent Allen

LET Function in Excel: A Name Parsing Example

LET Function in Excel: A Name Parsing Example

The LET function is one of the most exciting formulas to be added to Excel in 2020. This formula allows a spreadsheet maker the ability to create names for calculations (within a cell). These names not only make your formulas …

Read More
Updated on November 18, 2020November 18, 2020/ Brent Allen

Make a KPI Card like Power BI – In Excel!

Make a KPI Card like Power BI – In Excel!

In Power BI, one of the frequently used visuals is a key performance indicator, or KPI card. It allows to quickly hone in on key values for your dashboard. To avoid overwhelming users with incredibly high values, numbers are also …

Read More
Updated on November 8, 2020November 8, 2020/ Brent Allen

Top N Results from Excel using Dynamic Arrays

Top N Results from Excel using Dynamic Arrays

Getting the Top N results from a list of data, such as a Top 10 list is a very common Excel request. While this was possible before dynamic arrays, it has been made much easier using dynamic arrays. In this …

Read More
Updated on September 30, 2020September 30, 2020/ Brent Allen

DA-100 – The Certified Data Analyst Exam

DA-100 – The Certified Data Analyst Exam

On September 25, 2020, I wrote and passed the DA-100 exam to become a Microsoft Certified Data Associate. This exam measures skills that are required in order to be successful at modeling data in Power BI. Some of the questions …

Read More
Updated on September 21, 2020September 21, 2020/ Brent Allen

Ranges in Office Script – They are different than VBA!

Ranges in Office Script – They are different than VBA!

Most of the time that you are working in Excel, you will be working with ranges. And working with ranges in Office Script is very different than working with ranges in Visual Basic for Applications! Using a very simple macro, …

Read More
Updated on September 10, 2020September 9, 2020/ Brent Allen

Recording an Office Script in Excel Online

Recording an Office Script in Excel Online

The newest form of automation in Excel is Office Script; this uses the power of TypeScript and the web to automate spreadsheets! In this post, we’ll be recording an Office Script using the script recorder. This recorder provides an easy …

Read More
Updated on August 19, 2020August 19, 2020/ Brent Allen

Cube Formulas – The Best Excel Formulas You’re Not Using

Cube Formulas – The Best Excel Formulas You’re Not Using

Cube formulas have been around in Excel for a long time. Not like VLOOKUP (which has been around since the beginning)… but they have existed since 2007. These formulas were initially designed to extract values from SSAS cubes. However; with …

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 June 10, 2020June 10, 2020/ Brent Allen

#SPILL! error – What causes it to occur?

#SPILL! error – What causes it to occur?

With the introduction of dynamic arrays comes a new type of error; the spill error. Other errors, such as #N/A, #NUM! and #REF! have existed in Excel for many years. In many cases, workarounds for these errors have been created …

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

Posts navigation

Page 1 Page 2 … 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.