Teaching analytics with modern Excel
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 →
PERCENTOF() functionOne 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 →
IF() statements based on cell fill color in ExcelMany 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 →
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 →
UNIQUE() function in ExcelThe 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 →
I asked ChatGPT: if the 7 wonders of the modern world were modern Excel features, which would they be and why? Here's what I got back: 1. Great Wall of China - Power Query The Great Wall is …
Continue Reading about What are the seven wonders of Modern Excel? →
