A slicer in Excel is a user-friendly tool which allows to filter pivot tables. It is an advanced version of the standard filter option available for pivot tables. Apart from filtering a single pivot table, slicers are often used in dashboards for filtering several pivot tables and charts together. In this article, we will cover… Read more How to use Excel Slicers with PivotTables

# Category: Data Analysis

## Excel XIRR Function Examples

Excel function XIRR is a financial function which returns the internal rate of return for a series of cash flows, occurring at irregular period intervals. The XIRR function includes an initial investment and net income values. This function is derived from the IRR function which does the same calculation but works only with regular (equal)… Read more Excel XIRR Function Examples

## Best Uses for Conditional Formatting in Excel

Conditional formatting is a very useful Excel functionality that helps us visualize data based on certain criteria. In this tutorial we will cover some of the best uses for it and show you how to create your own Conditional Formatting rules using Excel formulas. Topics covered in this tutorial: Creating a conditional formatting rule Comparing… Read more Best Uses for Conditional Formatting in Excel

## How to Make a Histogram with Pivot Table

A histogram is a chart presentation of data grouped in equal intervals. In this step by step article, we will show you how to make a pivot chart histogram in Excel using pivot table as a data source. A histogram is often used to present the number of students with a number of points in… Read more How to Make a Histogram with Pivot Table