Expandable Conditional Drop Down Lists in Excel

Smart Dependent Drop-Down Lists in Excel: Expandable & Excluding Blank Cells In situations where the contents of a drop-down list are frequently changing, it's helpful to have a dynamic drop-down list that can automatically expand, as well as exclude any blank cells

Creative Infographics in Excel

Creative infographics in Excel (Male, Female icons) Using fillable icons on charts is a good way to visualize data. In this example, the male and female icons will be used. To do this: Set up the data table Insert a clustered column

Infographics in Excel: NOT your Usual Bar Chart

In this tutorial you learn how to create a bar chart that includes the male/female icon in a dynamic way. Let's assume you'd like to show the percentage of male/female visitors to your store - and you'd like to show it, like the image

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

Excel Charts: Dynamic Line Series Labels

Default legends are too much work. Not for you, because they are there by default but they can be a lot of work for your readers. They need to think more than they should about which color or texture belongs to which category. Do

Why Managers Might Not be a Fan of Business Dashboards

According to the Oxford dictionary, a business dashboard is “A graphical summary of various pieces of important information, typically used to give an overview of a business” An effective dashboard fulfils the following criteria* 1.Simple, communicates easily 2.Minimum distractions...it could cause confusion 3.Supports organized

How to Incorporate Excel Dashboard Techniques in your Reports

Data tables in reports are often difficult to read and analyse. To make out which product or business areas are performing better than estimated, can often require some time going back and forth between the numbers. The smart use of symbols and colour can