Excel Examples

Data Validation the Date of Current year

This post will guide you how to allow a user to enter only dates of current year in excel. How do I set the limitation to allow a user to enter the date of current year in a cell in excel. And this post will talk that how to use data validation with a custom… read more »

Creating in-cell bar Chart

This post will guide you how to insert a bar chart in a cell in excel. And How do I insert a bar chart into a cell with conditional formatting function in excel. How to insert a bar chart into a cell in excel with the REPT function. In-Cell Bar charts with the REPT Function… read more »

Dynamic Command Button Name

This post will guide you how to make a dynamic command button so that its name is labeled as the results of a specific cell in excel. For example, if you create a command button and want its name be read from cell B1. So if the value of Cell b1 changed, and the command… read more »

Sort Cells by Specific word or words

This post will guide you how to sort cells or text values in a column based on a specific word even if the word is in the text string in the cell. How do I sort cells in a column by the number of a specific word or words in excel. Sort Cells by Specific… read more »

Add a Picture to a Command Button

This post will guide you how to insert a picture to a command button in excel. How do I embed a picture in a command button in excel. Add a Picture to a Command Button Normally, after you add a command button in your current worksheet, you are used to set a text label for… read more »

Highlight overlapping dates

This post will guide you how to find overlapping date ranges in excel, then highlight the overlapping dates. How do I highlight overlapping dates with conditional formatting function in excel. Highlight overlapping dates If you want to highlight overlapping dates, you need to find the overlapping date ranges firstly, so you need to create a… read more »

Find and Replace Tildes and Wildcard Characters

This post will guide you how to find or replace a character such as a tilde, an asterisk or a question mark using Find & Replace function in excel. How to find or replace wildcard characters in excel. Wildcards are special characters that can be used to take any place of any character. And there… read more »

Calculate Thanksgiving Date

This post will guide you how to calculate the thanksgiving data based on a specific year date in excel. How do I get the thanksgiving date based on a specific years in excel. Calculate the US Thanksgiving Date You can use a simple arithmetic to calculate the possible date range for the US Thanksgiving, it… read more »

Finding the Max and Min value in an Alphanumeric Data

This post will guide you how to find the maximal and minimal value or string from an alphanumeric data list in excel. How do I retrieve or get the max or min string value based on alphabetic order from a string data in excel. For example, if you want to find the Maximal or minimal… read more »

Using Data Validation to Limit Calculated Cell

This post explains that how to limit calculated cell using Data Validation in excel. You can use the Data Validation function to limit what a user can type in a cell. And you can also use the data validation to limit user to whole number, dates, a list of selections or a specific range of… read more »

Sidebar