data visualization Archives - Xelplus - Leila Gharani

PowerPoint Design Tips for Memorable Presentations

Leila Gharani — Thu, 08 Oct 2020 09:00:00 +0000

How do you create professional looking PowerPoint slides? It comes down to small things. Most of which we don't notice when we watch presentations we love. I've broken it down into 5 tips which you can apply to your PowerPoint slides.

The post PowerPoint Design Tips for Memorable Presentations 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.

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.

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.

Dynamic WordArt in Excel with Bar in Bar Chart

Leila Gharani — Fri, 09 Feb 2018 07:38:00 +0000

Learn how to have dynamic Word Art that is controlled with a formula and how to create bar-in-bar Excel charts. You don't need VBA, you just have to get creative.

The post Dynamic WordArt in Excel with Bar in Bar Chart appeared first on Xelplus - Leila Gharani.

Corporate Report Makeover: Alternative for Excel Doughnut Charts

Leila Gharani — Thu, 19 Oct 2017 14:18:00 +0000

Doughnut charts get a bad reputation, but they are still used in corporate reports. In this tutorial, we offer a better alternative. A bar chart with automatic sorting will tell the story in one glance. Learn, how to set it up.

The post Corporate Report Makeover: Alternative for Excel Doughnut Charts appeared first on Xelplus - Leila Gharani.

BMW Corporate Report Makeover in Excel: Graph Versus Table (Part 1)

Leila Gharani — Thu, 19 Oct 2017 13:47:00 +0000

In this case study we take a look at the 2015 Annual Report from BMW and look at ways we could improve on some of the tables and graphs used in the report. When comparing sales volume difference year over year, a cleverly formatted bar chart will be much more effective in telling the story than a simple table.

The post BMW Corporate Report Makeover in Excel: Graph Versus Table (Part 1) appeared first on Xelplus - Leila Gharani.

Excel Quick Gantt Chart

Leila Gharani — Wed, 02 Aug 2017 07:17:00 +0000

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.

The post Excel Quick Gantt Chart appeared first on Xelplus - Leila Gharani.

3 Steps to Make Great Excel Charts

Leila Gharani — Wed, 26 Jul 2017 11:17:00 +0000

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.

The post 3 Steps to Make Great Excel Charts appeared first on Xelplus - Leila Gharani.