CAGR 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 moreTag: Excel
Target 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 moreSave Each Worksheet as a Separate PDF in VBA
Hello 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 moreWhat-IF Analysis in Excel
Hello Friends! What-IF Analysis is the way/process to check the affect of values in a formula.
Tic Tac Toe in Excel using VBA
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.
Solve linear programming problem using Excel
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.
VLOOKUP and HLOOKUP functions in Excel
Today we’ll be learning about the one of most important functions in Excel that VLOOKUP and HLOOKUP. Read more