17 Amazing Features of Excel Tables

In general, any organised data is called a table. But in excel they are not. You need to format your data as a table on excel to get the benefits of ...

How to find the total of table in Excel

In this article, we will learn How to find total of table in Excel Scenario : Sometimes you may want to calculate the sum of a group of non-...

How to Apply Colors to Top/Bottom Values in a List in Excel

In this article, we will learn How to Apply Colors to Top/Bottom Values in a List in Excel. Scenario : Conditional Formatting is used to...

How to Color cell Based on Text Criteria in Excel

In this article, we will learn How to Color cell Based on Text Criteria in Excel. Why do we use conditional formatting to highlight cells in Ex...

How to Draw Lines between Sorted Groups in Excel

In this article, we will learn How to Draw Lines between Sorted Groups in Excel. Why do we use conditional formatting to highlight cells in Exc...

How to Apply Formatting to List/Table in Excel

In this article, we will learn How to Apply Formatting to List/Table in Excel. Scenario: There are two types of cell formatting in excel. On...

How to use table sorting in Excel

In this article, we will learn How to use table sorting in Excel. What is Sorting ? Sorting is any process of arranging items systematically...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.