Special Character Meaning in MS Excel that You Must Know About

Special Character Meaning in MS Excel

Maximum people are using ms excel in corporate and small business, but very few people know the meaning of special character, which is very different in excel. actually, we know these characters with a name but as per excel there names or meanings are totally different. so here in this post, we have explained to … Read more

“If, Else” Formula in Excel with 4 Examples (Very Easy) | if else example in excel

if formula in excel

The Formula “If” “Else” is very important in excel, with the help of If-Else we can do filter anything easily in excel, so here in this article we will tell you some example of If-Else formula. So let started with example as given here under. Example No. 1 for “If- Else” Formula in Excel : … Read more

How to Find Duplicates in Excel within 10 Seconds (with Example)

how to find duplicate in excel

Within 10 seconds we can find duplicates in excel. Finding duplicates in a excel sheet is very easy now these days, we don’t need any type of formula for it. We just need to follow these steps and we can find duplicate cells. How to Identify Duplicates in Excel : To find duplicates in excel … Read more

How to create a Drop-down list in Excel (with in 30 Seconds-With Example)

drop-down-list-in-excel

Give 5 minutes to read this article and you will learn, How to make Dropdown list in excel. this is a very important command in excel to minimize your time work. So first of all I want to tell why the dropdown list is important for us- For example:- There are a lot of people … Read more

How to Protect & How to Unprotect an Excel Sheet with a Password

Sometimes we work on a very important sheet and suddenly somebody comes and delete our data from our excel sheet and we have to prepaid that data again, so friends don’t worry here is a solution, do you know that we can protect our excel sheet with a password, if not, then you can learn … Read more

How to Lock an Excel file with a Password (very easy)

protect excel bypassword

Most of the people didn’t know that how to protect excel file with a password. So in this tutorial I am going to tell you that how can be an excel file protect by a password, that will make your excel data secure. Follow these steps to protect your excel file with a password. Protecting … Read more

How to Create a Form in Excel (containing submit button-with example)

Friends do you know that we can make small software in Microsoft excel using by the formulas and menu buttons. So in this article I am going to tell you that how to create form in MS Excel. How to Create Menu in MS Excel:- First of All Click on Menu Icon and click on “Excel … Read more

How to Learn Pivot Table Quickly in MS Excel (With Example)

pv table, create a pivot table, pivot table tutorial, how to create a pivot table, how to make a pivot table, how to create pivot table, create pivot table, what is a pivot table, pivot tables for dummies, how to use pivot tables, what are pivot tables, refresh pivot table, pivot table,

Pivot Table is a very important command in MS Excel. It reduces our working time and reduces the chances of error in calculation. So, first of all I want to tell you what we can do with the help of pivot table- We will take an example to understand the pivot table in MS Excel. … Read more

Using of Vlookup Command in Excel (With Example)

Hay Viewers, Do You know how to use vlookup command in excel. if no, then this is a very important article for you to learn about use of vlookup command in ms excel. So first of all let me tell you, what is vlookup in micro soft  excel. vlookup stands for Vertical lookup. Vertical Lookup … Read more