Hello Friends!! In this blog post, we will explore a Power Query M script that performs a series of transformations on a table from an Excel workbook. This script refines and reshapes the data, making it more structured and analysis-friendly. Let’s break it down step by step and file attached to download.
Read moreHello friends!! We’ll be learning how to add CAGR line in bar or Line in single chart in Excel. I’ve attached the workbook to download and reuse.
Read moreHello friends!! We’ll be learning how to create bar and stack bar in single chart in Excel. I’ve done something similar in Tableau in my previous post Profit Gap Analysis in Tableau. Also I’ve attached workbook to download and reuse.
Read moreHello friends!! today we’ll be learning how to calculate Median and Quartile values with multiple conditions. I’ve attached the Excel workbook for download and reuse. So it is MEDIAN IFs and QUARTILE IFs but there is no direct formula we’ll create one.
Read moreHello friends!! We’ll be learning quick way to convert Excel sheets to PDF in VBA . These quick VBA tip will help you to save lot of time.
Read moreHello Friends! What-IF Analysis is the way/process to check the affect of values in a formula.
Hello friends! I was playing with VBA and create this Tic Tac Toe game in Excel. Comment if you want to learn how to create how to create Tic Tac Toe in Excel using VBA.
Today we’ll be learning how to solve Linear Programming problem using MS Excel? Linear programming (LP) is useful for resource optimization. There are so many real life examples and use of linear programming. We’ll see one of the real life examples in the following tutorial.
