Welcome to my blog! I’m excited to introduce you to the power of Excel’s Lambda functions. I recently recorded a video on

Conditional Formatting in Excel is a powerful tool that allows users to highlight cells based on specified conditions. It enables formatting based

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

Exploring VBA (Visual Basic for Applications) can sometimes feel like finding your way through a complex puzzle, especially when working with the

In VBA we need to check if a character is valid or not. So, let me give some examples: 1️⃣ File Name

Recently I have found one post on File Selector for windows to use in power query. I would suggest you to checkout

By default Text.Replace do case sensitive replacing. Sometimes we need to do case-insensitive replacement. I have created a custom function that will

I am sure you have rarely used this or know about this. Yes, You can use the POST HTTP method using Web.Contents.

This post is about the third most important parameter and that is Headers. We can pass data to a HTTP Call and

This post is the center point of Web.Contents PQ Function. Please learn it well. In this post, I am going to introduce

If you haven’t checked the different parameters of Web.Contents function, then please check them from MSDN. In this post, we are going

I wish I knew all of this or could find one place to learn everything about Web.Contents power query function. I used