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 …
Category: excel
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 …
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 …
XLOOKUP – New abilities
In my last post, I detailed how to replace existing VLOOKUP and other lookup formulas with XLOOKUP. However; XLOOKUP is more than just a replacement to the VLOOKUP and INDEX / MATCH functions! XLOOKUP adds some additional functionality that was …
How to use XLOOKUP in Excel to replace existing LOOKUP functions.
In September 2019, Microsoft introduced a new function to help speed up the way that data lookups are performed. As of February 2020, the XLOOKUP in Excel function is still in testing; however, upon release, it will change the way …
What is Advanced Excel?
Advanced Excel is a skill that is in high demand. A quick query on LinkedIn showed over 68,000 jobs worldwide requesting advanced Excel, as of January 2020. The jobs that were showing on LinkedIn are generally for financial jobs, such …