Dashboards, Charts & Features Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/dashboards-charts-and-features/ Bestselling Excel and Power BI Courses Wed, 20 Dec 2023 07:30:27 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Dashboards, Charts & Features Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/dashboards-charts-and-features/ 32 32 How to Create a Drop-Down List in Excel (6 Easy Steps) https://www.xelplus.com/how-to-create-a-drop-down-list-in-excel/ Wed, 20 Dec 2023 07:30:20 +0000 https://www.xelplus.com/?p=20565 Learn how to create a drop-down list in Excel with our easy guide. Perfect for beginners, this post offers step-by-step instructions and practical tips.

The post How to Create a Drop-Down List in Excel (6 Easy Steps) appeared first on Xelplus - Leila Gharani.

]]> 5 Hidden Excel Features for Busy People https://www.xelplus.com/excel-useful-features/ Fri, 08 Dec 2023 14:38:35 +0000 https://www.xelplus.com/?p=19832 Learn five amazing time-saving features in Excel that you likely have never tried or even knew existed. Turn hours of work into seconds.

The post 5 Hidden Excel Features for Busy People appeared first on Xelplus - Leila Gharani.

]]> Excel Dashboard to Track Budget and Actuals with Variances https://www.xelplus.com/excel-budget-actual-dashboard/ Fri, 08 Dec 2023 14:25:28 +0000 https://www.xelplus.com/?p=19902 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.

]]> Excel’s Checkboxes Are Incredibly Cool! Here’s why https://www.xelplus.com/excel-checkboxes/ Tue, 21 Nov 2023 16:18:58 +0000 https://www.xelplus.com/?p=19747 Excel's new Checkbox feature makes lists and interactive reports easier than ever. See how to add, customize, and use the new checkbox feature in a creative and interesting ways.

The post Excel’s Checkboxes Are Incredibly Cool! Here’s why appeared first on Xelplus - Leila Gharani.

]]> How to Fix Slow Excel Spreadsheets https://www.xelplus.com/how-to-fix-slow-excel-spreadsheets/ Mon, 06 Nov 2023 17:50:39 +0000 https://www.xelplus.com/?p=13496 Poor design slows down your spreadsheets. There are several frequent offenders to watch out for. Find out what they are and how you can optimize your workbooks.

The post How to Fix Slow Excel Spreadsheets appeared first on Xelplus - Leila Gharani.

]]> Best New Excel Features https://www.xelplus.com/best-excel-features-2023/ Mon, 16 Oct 2023 06:50:48 +0000 https://www.xelplus.com/?p=19094 Don't miss out on these exciting new Excel features. These will boost your productivity, improve workbook navigation and automate workflows.

The post Best New Excel Features appeared first on Xelplus - Leila Gharani.

]]> Insert Image in Excel Cell (and Lookup Images) https://www.xelplus.com/excel-insert-image-in-cell/ Tue, 26 Sep 2023 14:58:44 +0000 https://www.xelplus.com/?p=18599 Learn how to use the new "Image in Cell" feature in Excel to store and lookup images from cells.

The post Insert Image in Excel Cell (and Lookup Images) appeared first on Xelplus - Leila Gharani.

]]> Convert Excel to PDF https://www.xelplus.com/convert-excel-to-pdf/ Fri, 15 Sep 2023 09:00:00 +0000 https://www.xelplus.com/?p=18297 Learn how to save Excel data as a PDF file and the Best Practices for creating the perfect print version of Excel data.

The post Convert Excel to PDF appeared first on Xelplus - Leila Gharani.

]]> You Won’t Believe These Excel PIVOT TABLE Hacks! https://www.xelplus.com/pivot-table-pro-tips/ Thu, 24 Aug 2023 15:21:37 +0000 https://www.xelplus.com/?p=17817 Discover 10 pro hacks that will make creating pivot tables easier. Learn how to customize layouts, create dynamic reports, conduct in-depth analysis.

The post You Won’t Believe These Excel PIVOT TABLE Hacks! appeared first on Xelplus - Leila Gharani.

]]> Excel Find and Highlight Duplicates https://www.xelplus.com/excel-find-and-highlight-duplicates/ Thu, 24 Aug 2023 15:12:21 +0000 https://www.xelplus.com/?p=17558 Learn to locate duplicate values in a list, between multiple lists, as well as duplicate rows in a table. Generate a report that lists all duplicates.

The post Excel Find and Highlight Duplicates appeared first on Xelplus - Leila Gharani.

]]>