Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text according to alphabets A to Z and Z to A. We can also sort … Continue reading
Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text according to alphabets A to Z and Z to A. We can also sort … Continue reading
Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And, we can also sort the text according to alphabets A to Z and Z to Ain Microsoft … Continue reading
To group and summarize the data, we can create an outline up to eight levels in the data list. To expose the detail for each group, use an outline to quickly display. If you have data in the same cells … Continue reading
In Microsoft Excel,we can sort the data by using the AutoFilter sort’s data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text according to alphabets A … Continue reading
In this article, we will learn how to add a data field that calculates the difference between two data fields in pivot table report. In PivotTable, we can calculate the difference between two data fields. Let us take an … Continue reading
In this article we will learn how to delete the unnecessary blank character from a cell, we will use “TRIM” function in Microsoft Excel 2010. TRIM: Trim function is used to remove additional leading and trailing spaces from the text … Continue reading
Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text according to alphabets A to Z and Z to A. We can sort by … Continue reading
In this article, we will learn about how we can hide the group and outline in Microsoft Excel 2010. Outline: -An Outline helps to separate top level and details. It is easy to create an Outline using Auto Outline option … Continue reading
If you have a range of date, and if you want to filter the data as per year or month, you can do it by using the Format Cells and Auto filter option in Microsoft Excel. In this article, we … Continue reading
In this article, we will learn how we can copy the subtotals summary in Microsoft Excel 2010. Subtotal: – This option is used to calculate rows of related data quickly by inserting subtotals and totals. Before copying the … Continue reading
