Solver in Excel VBA
Hello friends! Today we’ll be learning to use Solver in Excel VBA. I’ve also attached the reusable file to download in the end of the tutorial.
Read morePercentage (%) of Total using DAX in PowerBI
Hello friends! Today we’ll be learning to calculate percentage of total using DAX in Power BI.
Read moreWorking with dates in Power BI
Hello friends! Today we’ll be learning to working with dates in Power BI.
Read moreDifferent time interval Sales in Power BI
Hello friends! Recently I started working on Power BI. I had to calculate the sales for different intervals This week, Last week, This Year sales etc. I’ve compiled all the calculations here for different intervals and I’ll keep adding more.
Read moreDynamic Parameter in Tableau
Hello friends!! We’ll be learning how to create the dynamic parameter range in Tableau.
Read moreCAGR line in Excel Charts
Hello 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 moreTarget vs Actual Chart in Excel
Hello 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 moreMEDIAN IFs and QUARTILE IFs in MS Excel
Hello 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 more