Start Your Lambda Journey With This
Welcome to my blog! I’m excited to introduce you to the power of Excel’s Lambda functions. I recently recorded a video on
Deep Dive into Conditional Formatting to Find Anomaly
Conditional Formatting in Excel is a powerful tool that allows users to highlight cells based on specified conditions. It enables formatting based
Toggle all Power query Columns Auto-Fit
When loading data into an Excel Table using PowerQuery, the Table columns may automatically resize each time the query is refreshed. This can affect the
Shell.Application Weird Behavior: Prevent Debugging Headaches Now!
Exploring VBA (Visual Basic for Applications) can sometimes feel like finding your way through a complex puzzle, especially when working with the
3 Techniques for Character Validation in VBA
In VBA we need to check if a character is valid or not. So, let me give some examples: 1️⃣ File Name
Win and MAC Compatible File Selector
Recently I have found one post on File Selector for windows to use in power query. I would suggest you to checkout
Case Insensitive Text.Replace In Power Query.
By default Text.Replace do case sensitive replacing. Sometimes we need to do case-insensitive replacement. I have created a custom function that will
Secret Power Of Web.Contents PQ Function: Options[Content] Parameter – Part 5
I am sure you have rarely used this or know about this. Yes, You can use the POST HTTP method using Web.Contents.
Secret Power Of Web.Contents PQ Function: Options[Headers] Parameter – Part 4
This post is about the third most important parameter and that is Headers. We can pass data to a HTTP Call and
Secret Power Of Web.Contents PQ Function: Options[Query] Parameter – Part 3
This post is the center point of Web.Contents PQ Function. Please learn it well. In this post, I am going to introduce
