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