Excel Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/ 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 Excel Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/ 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.

]]> Number Rows in Excel – Dynamic Solution with SEQUENCE https://www.xelplus.com/number-rows-in-excel-sequence-function/ Tue, 26 Sep 2023 14:08:36 +0000 https://www.xelplus.com/?p=18384 Learn how to create self-numbering lists for Excel tables and traditional lists using the SEQUENCE function.

The post Number Rows in Excel – Dynamic Solution with SEQUENCE 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.

]]> Import Power BI Data into Excel https://www.xelplus.com/power-bi-in-excel/ Thu, 14 Sep 2023 09:00:00 +0000 https://www.xelplus.com/?p=18646 Learn how to export data from Power BI and use it in Excel. The data can be enhanced by Excel and receive updates from Power BI when new data is added to the Power BI Data Model.

The post Import Power BI Data into Excel appeared first on Xelplus - Leila Gharani.

]]>