Dashboard techniques Archives - Xelplus - Leila Gharani

Excel Dashboard to Track Budget and Actuals with Variances

Leila Gharani — Fri, 08 Dec 2023 14:25:28 +0000

Learn to build a budget vs actual dashboard in Excel. Master key formulas and chart customization for effective year-over-year variance analysis.

The post Excel Dashboard to Track Budget and Actuals with Variances appeared first on Xelplus - Leila Gharani.

How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick

Leila Gharani — Thu, 09 Sep 2021 08:43:00 +0000

With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

The post How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick appeared first on Xelplus - Leila Gharani.

4 Hidden Excel Dashboard Design Tips for Beautiful Reports

Leila Gharani — Thu, 04 Jun 2020 09:00:00 +0000

You can spend a lot of time on design and formatting when you create Excel dashboards. Discover 4 hidden tips that will make the process a lot easier.

The post 4 Hidden Excel Dashboard Design Tips for Beautiful Reports appeared first on Xelplus - Leila Gharani.

Practical Excel Dashboards Tips – Ideas to Get Creative

Leila Gharani — Wed, 11 Dec 2019 03:18:00 +0000

This Excel dashboard combines 4 strange features to create a dynamic and practical dashboard. It includes FILTER function with XLOOKUP, XOR function, Linked Picture as well as an Icon. You'll find a lot of hidden gems in the way this Excel dashboard was created.

The post Practical Excel Dashboards Tips – Ideas to Get Creative appeared first on Xelplus - Leila Gharani.

How to Present Survey Results in Excel with a Chart

Leila Gharani — Sat, 20 Apr 2019 19:24:00 +0000

What's an effective way to visualize survey results in Excel? Specially results of an employee satisfaction survey? In this tutorial, you'll find an impressive way to chart survey results in Excel. It's not as difficult as you think.

The post How to Present Survey Results in Excel with a Chart appeared first on Xelplus - Leila Gharani.

Expandable Conditional Drop Down Lists in Excel

Leila Gharani — Fri, 20 Jul 2018 07:16:00 +0000

Quickly create dynamic drop-down lists in Excel that are dependent on another list. Automatically exclude blank cells and allow the drop-down to expand as new values are added.

The post Expandable Conditional Drop Down Lists in Excel appeared first on Xelplus - Leila Gharani.

Creative Infographics in Excel

Leila Gharani — Thu, 05 Jul 2018 08:56:00 +0000

Download the infographics Excel template for a quick start. I'll show you how to create this with male, female icons. Update it easily for your needs.

The post Creative Infographics in Excel appeared first on Xelplus - Leila Gharani.

Lookup on Pictures in Excel

Leila Gharani — Tue, 12 Jun 2018 09:15:00 +0000

Create impressive Excel reports by adding a dynamic lookup to your image. This way, every time a cell value changes, your image changes. Download the Excel Workbook and use it to quickly get started.

The post Lookup on Pictures in Excel appeared first on Xelplus - Leila Gharani.

Infographics in Excel: NOT your Usual Bar Chart

Leila Gharani — Fri, 27 Apr 2018 08:39:00 +0000

If you'd like to modernize your Excel reports, check out this tutorial which shows you some simple chart tricks to create a bar chart that doesn't quite look like a bar graph. It uses icons and shapes in a dynamic way.

The post Infographics in Excel: NOT your Usual Bar Chart appeared first on Xelplus - Leila Gharani.

Excel VBA: Control WordArt Fill with Macros

Leila Gharani — Thu, 15 Feb 2018 17:37:00 +0000

Find out how you can use Excel Macros to control the fill color of Word Art showing a percentage value connected to a cell with a formula. Pick up plenty of VBA techniques while you're at it.

The post Excel VBA: Control WordArt Fill with Macros appeared first on Xelplus - Leila Gharani.