Icons Archives - Xelplus - Leila Gharani

Office 2021 – New Functions and Enhancements

Leila Gharani — Thu, 14 Oct 2021 08:10:00 +0000

Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

The post Office 2021 – New Functions and Enhancements appeared first on 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 Easily Import Data from Web to Excel

Leila Gharani — Sun, 15 Dec 2019 02:53:00 +0000

Quickly learn how to import data from a web page into Excel with these 2 practical examples. The advantage of importing data this way is that whenever the data on the website is updated, you'll just need to "refresh" the data in Excel to get the latest information. It's super easy!

The post How to Easily Import Data from Web to Excel 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 Use PowerPoint SLIDE ZOOM

Leila Gharani — Sat, 13 Jul 2019 17:49:00 +0000

Quickly learn how to use PowerPoint's Slide Zoom feature to make more exciting and dynamic PowerPoint presentations. Take a look at this "before" and "after" slide presentation. What a difference a small feature can make!

The post How to Use PowerPoint SLIDE ZOOM appeared first on Xelplus - Leila Gharani.

Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA

Leila Gharani — Sun, 05 May 2019 10:48:00 +0000

In this Excel VBA & macros tutorial, you will learn how to create a ListBox that contains the names of the worksheets. You can select multiple names and then print the sheets as one print job instead of separate ones.

The post Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA appeared first on Xelplus - Leila Gharani.

All about Excel Comments (Notes): Shortcut Keys, Customize Background & More

Leila Gharani — Fri, 15 Feb 2019 23:33:00 +0000

Find out what the most useful shortcut keys are when working with excel comments or notes. Format a note by adding images, change font of comment and update background color, copy and paste comments and much more.

The post All about Excel Comments (Notes): Shortcut Keys, Customize Background & More 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.