Teaching analytics with modern Excel
If you've spent any time in Excel as an analyst, you're well aware of the significant amount of busywork involved. Manually adding different formats, PivotTables, removing unwanted columns, creating …
Continue Reading about How to compare Office Scripts and VBA for Excel →
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? →
