Search Results

Conditional formatting is great at bringing attention to specific values, whether high/low, deviations, variances. It makes interpreting the data easier. But it can also significantly slow down your workbook. There is a faster alternative. You can use Custom Number Formatting to bring attention to data. Learn how to use it, how to add color-coded up/down errors and percentage deviations.

Conditional formatting is great at bringing attention to specific values, whether high/low, deviations, variances. It makes interpreting the data easier. But it can also significantly slow down your workbook. There is a faster alternative. You can use Custom Number Formatting to bring attention to data. In part 2, learn how to add any symbol to custom number format, how to use up/down arrows for percentage variances, and how custom formatting works with thresholds and icons.

Learn how to perform a matrix lookup, i.e. when you need to return the value based on the header row and the category column, in a scenario where you have more than one header. The powerful INDEX/MATCH combo is capable of handling that a couple of ways.

There is no built-in Gannt chart in Excel, but in this tutorial, you will find two workarounds, one using a scatter plot, and another with stacked bar chart. Error bars come to the rescue in both versions. You’ll get a quick version, and a fully featured one, where you can switch between actual and plan scenarios.

Learn how to add series lines or shaded background to a stacked column chart by combining it with a stacked area chart. It’s a good way of displaying the trend for each category (stack).

In this tutorial, I share the 3 principles, along with some examples, for effective data visualization, that you should apply to your charts and dashboards in Excel. When designing a chart, keep it simple, clear and consistent.

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.