Dashboards

Expandable Conditional Drop Down Lists in Excel

Smart Dep. Drop-Down Lists in Excel: Expandable & Exclude Blank Cells In situations where contents of a dropdown list are frequently changing, it is helpful to have a dynamic dropdown list that can automatically expand, as well as exclude any blank cells

Lookup on Pictures

Dynamic Picture Lookup in Excel Just 5 easy steps - No VBA How can you lookup different pictures based on the value of a cell? Just to give you a heads up. This is a VBA-free tutorial! We saw the dynamic picture

Excel Dependent Drop Down List with Tabular Data

Handle dynamic data validation lists that refer to parts of your table only  Excel Dependent Drop Down List with Tabular Data without Named Ranges   There are some cases where you need to create a dependent drop down list using a source

Symbols in Pivot Slicers

A neat pivot slicer trick Symbols in Pivot Slicers Give your report a customized look by replacing text with symbols in your Pivot Slicers. Obviously you can't do that with every Pivot Table filter, but replacing text with symbols whenever it makes

Excel Pivot Chart with Slicers

Get Weekday name from date and use Slicers Excel Pivot Chart with Slicers   Some reports require an interactive analysis of a large data set. In this example, we have a data set of daily closing prices as shown below: We want

Excel Charts: Special Excel Graphs (InfoCharts)

How can you create this chart in Excel? The first time I saw a similar chart was in a report published by Udemy called Learning Trends & predictions in 2017. They used a similar chart to the one below (this one just has sample data

5 Design Tips for Better Excel Dashboards

What results do you want to show in your Excel dashboard? What should readers take away from it? These five design tips will help you showcase your data clearly and directly. Scroll down for the video. Learn how to create this interactive Excel report