Formulas Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/formulas/ Bestselling Excel and Power BI Courses Fri, 21 Mar 2025 16:07:48 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Formulas Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/formulas/ 32 32 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 Use the Excel TRANSLATE Function https://www.xelplus.com/excel-translate-function/ Thu, 01 Aug 2024 06:29:52 +0000 https://www.xelplus.com/?p=25731 Learn how to use Excel's TRANSLATE and DETECTLANGUAGE functions. Includes a free practice workbook download!

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

]]> COUNTIFS Function in Excel https://www.xelplus.com/excel-countifs-function/ Wed, 05 Jun 2024 06:22:14 +0000 https://www.xelplus.com/?p=24151 Master the COUNTIFS function in Excel. Count cells based on multiple criteria with this powerful tool. Free practice file included.

The post COUNTIFS Function in Excel appeared first on Xelplus - Leila Gharani.

]]> Regex in Excel https://www.xelplus.com/regex-in-excel/ Wed, 22 May 2024 16:44:26 +0000 https://www.xelplus.com/?p=23390 Discover the power of regex in Excel. Learn how to use regular expressions to clean data, validate entries, and format text efficiently.

The post Regex in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Remove Blank Rows in Excel https://www.xelplus.com/remove-blank-rows/ Fri, 17 May 2024 13:22:31 +0000 https://www.xelplus.com/?p=23208 Learn how to remove blank rows in Excel and keep your spreadsheets clean and error-free. Discover different methods for data cleaning.

The post How to Remove Blank Rows in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use SUMIF Function in Excel https://www.xelplus.com/sumif-excel/ Thu, 09 May 2024 16:36:35 +0000 https://www.xelplus.com/?p=23121 Excel's SUMIF function is like a smart calculator. It helps you add up numbers that meet a certain rule you set.

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

]]> How to Insert a Check Mark in Excel https://www.xelplus.com/check-mark-excel/ Sun, 28 Apr 2024 08:37:40 +0000 https://www.xelplus.com/?p=22787 Learn how to insert check marks and cross marks in Excel and understand the difference between check marks and checkboxes.

The post How to Insert a Check Mark in Excel appeared first on Xelplus - Leila Gharani.

]]> CAGR Formula in Excel https://www.xelplus.com/cagr-excel/ Wed, 24 Apr 2024 15:42:43 +0000 https://www.xelplus.com/?p=22740 Learn how to calculate CAGR using Excel and find out the average growth rate of your investments over time.

The post CAGR Formula in Excel appeared first on Xelplus - Leila Gharani.

]]> XLOOKUP vs VLOOKUP https://www.xelplus.com/xlookup-vs-vlookup/ Tue, 19 Mar 2024 10:17:31 +0000 https://www.xelplus.com/?p=21968 For a long time, VLOOKUP was the go-to way to find things in Excel. But now that more people can use XLOOKUP, VLOOKUP's top spot is in question. XLOOKUP is a newer, better tool for looking up things in Excel. It's more powerful than VLOOKUP. Let's compare the two.

The post XLOOKUP vs VLOOKUP appeared first on Xelplus - Leila Gharani.

]]> VLOOKUP Function https://www.xelplus.com/vlookup-function/ Wed, 06 Mar 2024 18:41:54 +0000 https://www.xelplus.com/?p=21764 Explore Excel's VLOOKUP function with this detailed guide. Master the art of searching and retrieving spreadsheet data, from basics to advanced techniques. Ideal for enhancing Excel skills and boosting productivity. Start using VLOOKUP with confidence today.

The post VLOOKUP Function appeared first on Xelplus - Leila Gharani.

]]>