Teaching analytics with modern Excel
One of the most essential tools for making computers work for you is conditional logic—"if this, then that" logic. It's simple yet incredibly powerful, and much of how computers function today relies …
Continue Reading about Power Automate for Excel: How to understand conditional flows →
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 →
Traditionally, filtering a dataset by multiple AND/OR conditions involved use of the Advanced Filters feature. While menu-driven, Advanced Filters can be difficult to manage and applies filters …
Continue Reading about How to filter a dataset by one or more criteria using Excel formulas →
It's wild to think that everything we do with computers comes down to manipulating its 0 and 1 states. So, it makes sense that using Boolean logic (that is, the manipulation of 0 and 1 or FALSE and …
Continue Reading about Three-way lookups in Excel with SUMPRODUCT() →
