Subject Line Centralized View – Connect one Slicer to two pivot tables Overview Sometimes you may need to link one Slicer with two Pivot tables based on the same data source. Slicer is a powerful way to filter pivot table data. We can click on an item in a slicer to filter the data in
Subject Line Gantt chart is the perfect graphical tool for your project Overview Sometimes you may need to track the progress of the project from start to finish. A Gantt chart is a horizontal bar chart used in project management as a tool to visualize progress. Working You have data below for sequential steps for building a website along
Subject Line Use Advanced Filter for simplification of complex search Overview Sometimes you have filter data based on multiple and complex criteria. With the help of advanced filter you can filter data based on complex criteria. This works as a SEO or search engine which searches on multiple criteria. Working Let’s understand the working of
Subject Line Combo offer for charts Overview Sometimes you may have to show different type of information on a single chart. You will have to combine two or more charts in a single chart. We can use Combo chart in excel to create such charts. It is like a combo offer where you can enjoy
Working Let’s take an example of Sales information which looks as below. We want to summarize sales amount by Screen size by grouping products by Large Display, Small Display & Others. Step 1: Select the Sales table from A1 to G25 Step 2: Go to INSERT Tab Step 3: Click on Pivot Table Step 4:
