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 …
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 …
#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 …
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 …
PowerApps – What should I use for my first app?
PowerApps is one of the key elements of the Power Platform. Its low-code environment makes it a great platform for users who are used to developing in VBA. As of May 2020, there are over 260 connectors to data sources …
Excel VBA Forms vs. PowerApps
Since the inception of VBA, one method of getting input from users has been through VBA forms. However; one of the major new elements of the Power Platform is the low-code environment PowerApps. It allows users to develop applications much …
Excel Data Tables – The Second Thing You Need to Know
If you have been just introduced to Excel, the first things you should learn are the basics. These include formulas like SUM(), how to format cells, and other basic ways to format results. The second thing that you need to …
Using Shapes for Better Dashboards
In most cases when working with data in Excel, you will be adding data directly into cells, or deriving data through pivot tables or formulas. But when working with dashboards, it is important to consider visual elements for end users. …
3 different ways to get unique values in Excel
It is very common to require a list of unique values from a list that contains duplicates. While it may be easiest to take a single approach to get these values, there are cases where a different approach may be …
Using XLOOKUP and TRANSPOSE
With XLOOKUP , it is now possible to return multiple values from a single function. However; when these values are returned, they show in multiple columns. If we want to have them appear by row, we have to use the …