10 Super Tips in Microsoft Excel
In the article, you will learn 10 super tips in Microsoft Excel. You can improve you productivity in Excel using these tips- Learn 10 Pivot table useful tips- 10 Super
Tag: Excel Formula
Wildcard in Microsoft Excel
In this article, you will learn how to use Wildcard in Microsoft Excel. Wildcard is very useful in excel and can make your work very easy. What is Wildcard? Wildcards
Calculate Ratio in Excel
In this article, we have explained how to Calculate Ratio between two number in Excel. We have used the Excel formula as well as the User defined function in VBA to
RandBetweenText Formula in Excel
In this article, we have created a user defined function RandBetweenText Formula in Excel. This function returns random text from the selected range. You can use this function to distribute
Search Text from Specific or all columns in Excel
In this article, you will learn how to use Advanced Conditional Formatting to search text in data. Here we have taken the example for employee Performance rating data. We two
Highlight and get birthdays count from Date of Birth
In this article, you will learn how to get count of persons from a Date of Birth data whose birthdays are in the specific month. You will also learn how
Highlight Unmatched Cells using Conditional Formatting in Excel
In this article you will learn how to Highlight Unmatched Cells Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the
Highlight the Consecutive Duplicates in Excel
In this article you will learn how to highlight the Consecutive Duplicates in Excel using Conditional Formatting. You will also learn how to highlight consecutive weekly off in an Attendance
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
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