Power Query and Power Automate both aim to streamline Excel workflows and simplify data manipulation, yet they serve unique purposes and tackle distinct challenges in the battle against slow, …
How to understand the basic elements of Power Automate workflows
One of the most rewarding experiences in my career as an Excel trainer and consultant has been assisting users in transforming their cumbersome, error-prone Excel workflows into streamlined, automated …
Continue Reading about How to understand the basic elements of Power Automate workflows →
How to calculate proportions in Excel with the PERCENTOF()
function
One of the more recent additions to Excel which I haven't seen receive much coverage is the PERCENTOF() function. This function calculates the percentage that a subset represents of a given dataset. …
Continue Reading about How to calculate proportions in Excel with the PERCENTOF()
function →
How to write IF()
statements based on cell fill color in Excel
Many office workers are familiar with using IF() statements to conditionally flag a row for being above a certain value, within a specific date range, etc. However, what if your criteria for these …
Continue Reading about How to write IF()
statements based on cell fill color in Excel →
How to select two noncontiguous columns in an Excel table
Excel tables offer several benefits for data storage and manipulation, one of the most significant being the ability to use structured references to programmatically select different elements of a …
Continue Reading about How to select two noncontiguous columns in an Excel table →
How to remove 0’s from the results of the UNIQUE()
function in Excel
The UNIQUE() function in Excel offers a quick and versatile method to eliminate duplicates from a range or table, though it occasionally produces unexpected results. Consider the following example: I …
Continue Reading about How to remove 0’s from the results of the UNIQUE()
function in Excel →