Excel Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/ Bestselling Excel and Power BI Courses Tue, 20 May 2025 13:55:32 +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 Python in Excel vs. VBA: Which One Should You Use? https://www.xelplus.com/python-in-excel-vs-vba/ Tue, 20 May 2025 13:55:30 +0000 https://www.xelplus.com/?p=28320 Python or VBA in Excel? Use this guide to decide—plus get a free one-pager cheatsheet to know when to use what.

The post Python in Excel vs. VBA: Which One Should You Use? appeared first on Xelplus - Leila Gharani.

]]> How to Find Circular References in Excel (and Fix Them Easily!) https://www.xelplus.com/find-circular-references/ Tue, 18 Mar 2025 10:55:16 +0000 https://www.xelplus.com/?p=27977 Learn how to find and fix circular references in Excel to avoid calculation errors and keep your formulas working correctly.

The post How to Find Circular References in Excel (and Fix Them Easily!) appeared first on Xelplus - Leila Gharani.

]]> How to Move Columns in Excel https://www.xelplus.com/how-to-move-columns-in-excel/ Wed, 12 Mar 2025 07:56:21 +0000 https://www.xelplus.com/?p=27950 Learn how to move columns in Excel with easy steps. Download our free practice file and start practicing right away!

The post How to Move Columns in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Calculate Standard Deviation in Excel https://www.xelplus.com/standard-deviation-excel/ Sun, 08 Dec 2024 09:41:08 +0000 https://www.xelplus.com/?p=27398 Learn how to calculate standard deviation in Excel with easy steps. Download our free practice file to get started today!

The post How to Calculate Standard Deviation in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Combine Two Columns in Excel https://www.xelplus.com/combine-two-columns-excel/ Fri, 29 Nov 2024 10:52:20 +0000 https://www.xelplus.com/?p=27330 Learn how to combine two columns in Excel with step-by-step methods. Download our free practice file to master the skill!

The post How to Combine Two Columns in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Wrap Text in Excel https://www.xelplus.com/wrap-text-in-excel/ Thu, 28 Nov 2024 14:41:07 +0000 https://www.xelplus.com/?p=27291 Learn how to wrap text in Excel with step-by-step tips. Download our free practice file to master this essential skill today!

The post How to Wrap Text in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Alphabetize in Excel – Easy Guide to Sort Data https://www.xelplus.com/alphabetize-in-excel/ Wed, 27 Nov 2024 14:46:30 +0000 https://www.xelplus.com/?p=27218 Learn how to alphabetize in Excel step by step. Download a free practice file to master sorting with ease!

The post How to Alphabetize in Excel – Easy Guide to Sort Data appeared first on Xelplus - Leila Gharani.

]]> How to Password Protect an Excel File https://www.xelplus.com/password-protect-excel/ Tue, 26 Nov 2024 10:41:33 +0000 https://www.xelplus.com/?p=27178 Learn how to password protect an Excel file step by step. Keep your data safe and secure with this easy guide!

The post How to Password Protect an Excel File appeared first on Xelplus - Leila Gharani.

]]> How to Use the GROUPBY Function in Excel https://www.xelplus.com/groupby-excel/ Wed, 06 Nov 2024 12:42:22 +0000 https://www.xelplus.com/?p=26517 The Excel GROUPBY function is a powerful tool for quickly summarizing and analyzing data. Whether you need totals, averages, percentages, or even custom calculations, GROUPBY allows you to organize data dynamically with just one formula—no Pivot Tables required.

The post How to Use the GROUPBY Function in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Delete a Pivot Table https://www.xelplus.com/how-to-delete-a-pivot-table/ Wed, 25 Sep 2024 13:28:29 +0000 https://www.xelplus.com/?p=26193 Tired of Pivot Tables cluttering your Excel sheets? This guide walks you through how to delete without losing your data. Whether you're looking to clear space or start fresh, you'll learn the easiest methods step-by-step. Perfect for beginners!

The post How to Delete a Pivot Table appeared first on Xelplus - Leila Gharani.

]]>