HLookup in Excel

How to use HLookup in Excel? The Letter “H” in HLOOKUP in excel stands for Horizontal Lookup. It is an in-built function in Microsoft Excel that allows you to search a specified value in the first or top row of a table (dataset) and retrieve a value in the same …

Read more

VLookup in Excel

Function – VLookup in Excel Vlookup in excel is a very useful in-built function in Microsoft Excel. VLOOKUP stand for Vertical Lookup and it allows you to search a specified value in the first/Leftmost column of a table vertically and retrieve a value in the same row from another column on the right side.  …

Read more

Sorting in Pivot Table

Sorting in Pivot Table in Excel Sorting in Pivot Table in Excel is a fundamental feature that allows you to arrange and analyze large sets of data more effectively. It enables you to rearrange and prioritize the data according to specific criteria, making it easier to identify patterns, trends, and …

Read more

Timeline in Excel

What is Timeline in Excel? In Microsoft Excel, a timeline is a visual representation of data that allows you to easily filter information within a specific time period. Timeline was first introduced with Excel 2013. Creating a timeline in Excel can be a useful way to filter data in a …

Read more

Slicer in Excel

What is a Slicer in Excel? A slicer in excel is a user interface (UI) feature used primarily on Tables, Pivot Tables, and Pivot Charts to filter data and perform interactive analysis on large amounts of data. It provides buttons that you can click on to filter the data. In …

Read more

Date Filter in Pivot Table in Excel

Date Filter in Pivot Table A date filter in pivot table allows you to filter data based on date criteria. This is especially useful when you have a large dataset with date-related information and you want to focus or analysis on specific date ranges or periods.  Let’s discuss some important …

Read more

Filter Data Using Search Box in Pivot Table

Filter Data Using Search Box Filter data using Search Box in Pivot Table allows you to quickly find and display specific items by typing keywords or search terms. This feature helps you efficiently navigate and locate data within your pivot table. See below how to use search box in pivot …

Read more

Label Filters in Pivot Table

Label Filters in Pivot Table Label filters is an in-built feature of Pivot Table. You can use the feature of the Label Filters in the Pivot Table to filter data based on specific criteria/conditions. It allows you to select specific items based on text values in the rows/columns level filter of …

Read more

Value Filter in Pivot Table in Excel

Value Filter in Pivot Table Value filter in Pivot Table is a tool used to filter and display specific data based on the values in one or more columns or fields within the pivot table. This filter allows you to focus on specific data points or ranges that meet certain …

Read more

Filter data in Pivot Table in excel

Filter data in Pivot Table Filter data in Pivot Table in Excel is used to quickly focus on specific data in your pivot table summary. It can be filtered by date, value, top or bottom rankings, and many more. Types of Filters in a Pivot Table There are many options …

Read more

Index