Excel general tips Archives - Page 5 of 6

Lesson#115: Information functions with Conditional Formatting

By Puspendu Roy Karmakar Posted on October 17, 2018 Posted in Excel Features, Excel Funtions, Excel general tips No Comments Tagged with CONDITIONAL FORMATTING

Here I will share general tips about Conditional Formatting and some Information functions. These functions are ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT. You can use these functions to highlight the specified types of values among an array. ISBLANK function highlights blank cells among an array of …

Lesson#115: Information functions with Conditional Formatting Read more »

Lesson#103: 4 Ways to find duplicate values in a worksheet

By Puspendu Roy Karmakar Posted on September 1, 2018 Posted in Excel Features, Excel Funtions, Excel general tips No Comments Tagged with CONDITIONAL FORMATTING, COUNTIF, MODE, MODE.MULT, PIVOTTABLE

Often we need to find the duplicate values in an Excel worksheet. Here in this post, I will discuss 4 Ways to find duplicate values in a worksheet. 1st Method: Function MODE and MODE.MULT The Excel MODE function returns the …

Lesson#103: 4 Ways to find duplicate values in a worksheet Read more »

Lesson#102: How to avoid name conflict error when copying a sheet in Excel

By Puspendu Roy Karmakar Posted on August 31, 2018 Posted in Excel Features, Excel general tips No Comments Tagged with NAME MANAGER

How to avoid name conflict errors when copying a sheet in Excel. In this post, I will discuss a serious problem faced by many Excel users. Whenever we try to copy a sheet Excel sometimes shows an error. The name …

Lesson#102: How to avoid name conflict error when copying a sheet in Excel Read more »

Lesson#92: How to highlight a column value depending upon the other column values

By Puspendu Roy Karmakar Posted on August 13, 2018 Posted in Excel Features, Excel general tips No Comments Tagged with AND, CONDITIONAL FORMATTING

Hello Friend! I am back again with my other post. This post is about Conditional Formatting. Here I will show how to highlight a column value depending on the column values next to it. In the above picture, I am …

Lesson#92: How to highlight a column value depending upon the other column values Read more »

Lesson#85: Adding or subtracting to Time is not same as Date in excel

By Puspendu Roy Karmakar Posted on June 20, 2018 Posted in Excel general tips No Comments

Hello my reader friend how are you? Hope fine. Today I will discuss a small but important topic in Excel. It is adding or subtracting to Date and Time. Almost all of us know how to add to date value …

Lesson#85: Adding or subtracting to Time is not same as Date in excel Read more »

Lesson#84: Separate text in different columns easily

By Puspendu Roy Karmakar Posted on June 15, 2018 Posted in Excel Features, Excel general tips No Comments Tagged with TEXT TO COLUMNS

Here I will discuss a very useful feature Text to Columns. We can use this feature to split the data into cells throughout the column and split it into many columns very easily. In the above picture, we can see …

Lesson#84: Separate text in different columns easily Read more »

Lesson#83: How to add a drop-down in an excel sheet

By Puspendu Roy Karmakar Posted on June 15, 2018 Posted in Excel Features, Excel general tips No Comments Tagged with DATA VALIDATION

I always hear a common question from beginner Excel users “How to make a drop-down menu in Excel?”. I would like to ask them have used the feature Data Validation. Select all the cells on which you want to create …

Lesson#83: How to add a drop-down in an excel sheet Read more »

Lesson#74: Input a name shows its length in the message box

By Puspendu Roy Karmakar Posted on April 26, 2018 Posted in Excel general tips, VBA and Macro No Comments Tagged with MSGBOX

This post will make you learn how to get an input box and show the length of the input text with VBA. 1. Go to Developer Tab. 2. Click on Insert. 3. Select Button (Form Control). 4. Put the button …

Lesson#74: Input a name shows its length in the message box Read more »

Lesson#73: Take input by input box and show it in the message box

By Puspendu Roy Karmakar Posted on April 26, 2018 Posted in Excel general tips, VBA and Macro No Comments Tagged with MSGBOX

This post will make you learn how to show an input box in VBA. Take input by input box and show it in the message box. 1. Go to Developer Tab. 2. Click on Insert. 3. Select Button (Form Control). …

Lesson#73: Take input by input box and show it in the message box Read more »

Lesson#72: Select an area by clicking a button in Excel with VBA

By Puspendu Roy Karmakar Posted on April 24, 2018 Posted in Excel general tips, VBA and Macro No Comments

Here I will show you how to select an area by clicking a button in Excel with VBA. 1. Go to Developer Tab. 2. Click on Insert. 3. Select Button (Form Control). 4. Put the button on the worksheet by …

Lesson#72: Select an area by clicking a button in Excel with VBA Read more »

Category: Excel general tips