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 write your first Office Script for Excel
In a previous post we delved into the distinctions between VBA (Visual Basic for Applications) and Office Scripts for Excel: To summarize, although many Excel automation tasks can be …
Continue Reading about How to write your first Office Script for Excel →
How to compare Office Scripts and VBA for 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 →
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 →