How to sort columns in pivot table in Excel

When the amount of data in a pivot chart or PivotTable is large, sorting it is quite important. Sorting is a way of keeping your data organized to make it…

Comments Off on How to sort columns in pivot table in Excel

How to create a pivot table in Excel

Excel offers a lot of powerful features to use while working with spreadsheets. Pivot tables are among them. A pivot table allows the user to group large data sets accordingly.…

Comments Off on How to create a pivot table in Excel

How to use conditional formatting in decorating pivot tables

Formatting cells to be different from other cells makes them to stand out and get noticed. Conditional formatting enables you to create rules that automatically change the cells formatting based…

Comments Off on How to use conditional formatting in decorating pivot tables

How to Concatenate Values of Pivot Table

Concatenate is an excel function that allows you to join two or more strings together. When creating Pivot table you may want to combine data from two or more columns…

Comments Off on How to Concatenate Values of Pivot Table

Excel Pivot Table with nested rows

A Pivot table is one of the powerful features in excel for any data analyst. The feature allows you to extract data from a large dataset. You can also create…

Comments Off on Excel Pivot Table with nested rows