In this article, we will learn how to prevent duplicate entries in a range with Data Validation. We will learn how helpful and useful this feature is and its uses to avoid any typing errors or mistakes. It not only … Continue reading
In this article, we will learn how to prevent duplicate entries in a range with Data Validation. We will learn how helpful and useful this feature is and its uses to avoid any typing errors or mistakes. It not only … Continue reading
In this article, we will learn how to create dynamic drop down list in Microsoft Excel. As we know Data Validation feature improves the efficiency of data entry in excel and reduces mistakes and typing errors. It is used to … Continue reading
In this article, we will learn how to create drop down list using data validation in Microsoft Excel. Data Validation feature improves the efficiency of data entry in Excel and reduces mistakes and typing errors. You can have restricted entries … Continue reading
So far in this Data Validation series, we have learnt to create normal drop down list and dynamic drop down list using different techniques with data validation in Excel. And, today, in this chapter, we will show you how to … Continue reading
In this article, we’ll learn the use of Color scales option in conditional formatting. Also, answer questions like, why we use it in our reports and its impact in our report for the better understanding. Basically Conditional formatting option is … Continue reading
How to Insert an Excel document in Word file? In this article we will learn how we can embed the Excel file or insert the Excel table into word file. Why we embed the Excel file and what is the … Continue reading
In this article we will learn how to highlight the Incell graph on the basis of high score in Microsoft Excel. To solve this problem we will use Conditional formatting along with AVERAGE function. Conditional formatting will help to highlight … Continue reading
In this article, we will learn how we can highlight every alternative row and every 3rd column in Microsoft Excel. We will use Conditional formatting option along with MOD and ROW functions. Let’s take an example and understand:- Below is … Continue reading
What is MS-Excel ribbon and its uses? We no longer need to find on which pull-down menu or toolbar the command resides. The ribbon shows us the most commonly used commands and options to perform a particular task, which is … Continue reading
In Excel, we can use minimize option as per our requirement. If we want to see the full screen of Excel and don’t want to see the Ribbon, then we can always minimize the Excel ribbon. In Excel, we have … Continue reading