Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...

It's time to have a look at some of my older posts. In this post I'm going to have another look at these Power Automate ideas ...

Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.

Microsoft Power Query requires less specialized knowledge when trying to find duplicate records in a Microsoft Excel sheet. There are several ways to find duplicates in a Microsoft Excel sheet. You ...

Often when working in business, and sometimes in a personal situation as well, we will be asked to perform periodic, repetitive and routine computer-related tasks. These routines such as copying files ...

One of my clients, takes many photos as part of their data entry process using a Canvas app. We need to compress the photos ...