Boost Your Skills with Our tutorials

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.