What is an Excel Slicer? The slicer is a filtering tool that was introduced in Excel 2010. Unlike dropdown menus, it gives you interactive buttons to filter your PivotTables and tables. You can narrow down your data with a single click and the best part is, you’ll always

Data Bars Data Bars are premade types of conditional formatting in Excel used to add colored bars to cells in a range to indicate how large the cell values are compared to the other values. Here is the Data Bars part of the conditional formatting menu: Data Bars

Top/Bottom Rules Top/Bottom Rules are premade types of conditional formatting in Excel used to change the appearance of cells in a range based on your specified conditions. Here is the Top/Bottom Rules part of the conditional formatting menu: Appearance Options The web browser version of Excel offers the following

WHAT IS ADVANCED FILTER? Excel Advanced Filter – as the name suggests – is the advanced version of the regular filter. You can use this when you need to use more complex criteria to filter your data set. EXCEL ADVANCED FILTER (Examples) EXAMPLE 1:Extracting a Unique list You can