UDF for Evaluate a Formula in Excel
In this article you will learn how to create a User Defined Function to evaluate a formula in Excel. You will also learn how to get text of formula using
Tag: Excel Formula
Excel Tip : Fill the blanks cells in your data
Many times we have zig-zag data which has to be formatted in proper manner to create some report or dashboard. In this article you will learn how we can Fill
Highlight the Specific data point in a Line Chart Dynamically
In this chart we have explained how to Highlight the Specific data point in a Line Chart Dynamically. You can highlight the Minimum, Maximum and Selected data points in a
Highlight Top and Bottom Performer using conditional formatting
In this article you will learn how to use Conditional Formatting to Highlight Top and Bottom performer on the base of performance score. Top performer has been highlighted in green
Project Plan (Gantt Chart) in Excel
Crafting a Project Plan (Gantt Chart) in Excel can initially appear to be an intimidating task. This is particularly true for those who are not well-versed with the nuances of
Dynamic Calendar in Excel
The dynamic calendar template is a must-have for keeping track of important dates and appointments. It's easy to change the month and year and the calendar updates automatically. Form Control
Age Calculator in Excel
Tallying the number of years that have passed since a person's date of birth is a time-consuming and convoluted task, particularly when multiple individuals are involved. But have no fear,