Search Results

In this tutorial, we tackle a matrix lookup scenario, where you want to return the column header based on the value inside the matrix as well as the row header. INDEX/MATCH to the rescue.

Dashboards are not only charts and graphs. Tables are ideal when you want to present the data in more detail, allowing report consumers to look up individual values and perform one-to-one comparisons. In this tutorial, you will find best practices when it comes to designing tables – how to organize and format them effectively.

In this tutorial you’ll find out to how to use Pivot Slicers in Excel and create Slicers for months based on dates. You’ll also learn how to create a dynamic Pivot Chart controlled by the slicer.

If the conditional formatting icon selection doesn’t meet your needs, you can customize your design and still make it dynamic with the help of the IF function and symbols. Explore the example of a project planning dashboard tracking overdue tasks.

Find out the difference between the WORKDAY and NETWORKDAYS functions. You can use them to calculate the end date based on the number of allocated working days or calculate the number of working days you have before a deadline. Both are useful for creating project timelines and reporting timetables.

If you want your charts to grab attention, it’s worth spending some time on customizing the shapes and conditionally formatting them in a dynamic manner, so that the highlighted value changes with the data. In this tutorial, we will walk through an example of customizing a chart in Excel.

If you follow the 5 dashboard design tips you’ll learn in this tutorial, you are guaranteed to create effective, informative dashboards.

Find out how to format the standard stacked chart to improve readability and comparison between the different categories and stacks. My tips include adding total values outside the last stack, adding percentages to the stacks, and creating a dynamic legend, putting the labels of each of the stacks on the right-hand side of the last category.

In this video tutorial, you will learn how to sum different columns based on user selection with the SUMIFS or SUMPRODUCT function. It’s a useful technique for interactive dashboards.

Dynamic column and bar charts are great for showing variances. In this tutorial, you will find 4 methods of visualizing variances in Excel: with conditional formatting – by inverting fill color for negative values, with the help of error bars, and by adding conditionally formatted arrows on top of or under the chart.

The INDIRECT() function comes very handy when need to feed different ranges to certain formulas, especially when you refer to ranges in other sheets. This tutorial explains how the INDIRECT() function works and how to use in a real-life scenario, gathering data from different tabs.

Learn how to create dependent dropdown list in Excel lists using the INDEX, OFFSET, CHOOSE and INDIRECT functions.