Loading...

The new Excel Dashboards course is here!

Now available on Udemy

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

GET 75% OFF THE COURSE
Free Ebook

Latest Tutorials

Excel Reverse Matrix Lookup

Are you familiar with INDEX MATCH? If you're familiar with Index and Match you know how to solve a matrix lookup problem. You want to find a value inside the matrix by looking up

  • Excel Table Design Report Dashboards

Excel Table Design

Use data tables when you want the reader to look up individual values and do exact one-to-one comparisons. Data tables are ideal for effectively presenting different types of data - such as costs, quantities, ratios,

  • excel weekday pivot slicer

Pivot Slicers for Dynamic Charts

Pivot slicers can be used for pivot charts as well and they are an easy way to create interactivity in your Excel reports. In this example I cover two topics: How to get Weekday

  • Conditional formatting in Excel using custom symbols and icon sets

Conditional Formatting Symbols

How to use Own Symbols in Excel and Conditionally Format Them You'd like to use symbols in your reports to bring attention to certain tasks or results? You find the icons available in Excel's

  • excel dashboards charts leila gharani xelplus reports

Quick Gantt Chart

How can you create a Quick Gantt Chart in Excel? A Gantt Chart is great for visualizing and presenting your project plan. But let's say, you just setup a preliminary project plan in Excel.

Trusted by