Dynamic Arrays Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dynamic-arrays/ Bestselling Excel and Power BI Courses Mon, 11 Dec 2023 12:06:20 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Dynamic Arrays Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dynamic-arrays/ 32 32 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.

]]> Excel VSTACK Function – The One Excel Formula to Append Them All https://www.xelplus.com/excel-vstack-function/ Thu, 26 May 2022 23:55:00 +0000 https://www.xelplus.com/?p=9237 This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

The post Excel VSTACK Function – The One Excel Formula to Append Them All appeared first on Xelplus - Leila Gharani.

]]> How to Properly Use the Excel TEXTSPLIT Function https://www.xelplus.com/excel-textsplit-function/ Thu, 31 Mar 2022 08:00:00 +0000 https://www.xelplus.com/?p=9374 Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

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

]]> New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE) https://www.xelplus.com/new-excel-functions-vstack-textsplit-tocol/ Thu, 31 Mar 2022 05:20:00 +0000 https://www.xelplus.com/?p=9390 Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

The post New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE) appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel SUMIFS on Multiple Criteria in a Single Column https://www.xelplus.com/sumifs-multiple-criteria-in-a-single-column/ Thu, 26 Aug 2021 06:49:00 +0000 https://www.xelplus.com/?p=9844 Learn how to sum values based on multiple criteria in a single columns. You probably know that you can use SUMIFS to sum values based on criteria from multiple columns. But there is also an easy way you can sum values if your criteria is in the same column.

The post How to Use Excel SUMIFS on Multiple Criteria in a Single Column appeared first on Xelplus - Leila Gharani.

]]> How to Calculate the Number of Days Between Two Dates in Excel https://www.xelplus.com/calculate-working-days-excel-exclude-some-days/ Thu, 05 Aug 2021 08:00:00 +0000 https://www.xelplus.com/?p=9907 It's easy to calculate the difference between dates in Excel and exclude weekends and holidays. But how can you exclude ANY weekday of your choice? There is an Excel trick you can use.

The post How to Calculate the Number of Days Between Two Dates in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) https://www.xelplus.com/excel-switch-columns-multiple-values/ Thu, 29 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9917 Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

The post Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) appeared first on Xelplus - Leila Gharani.

]]> Top Excel Interview Questions – Be Ready for your Next Interview https://www.xelplus.com/excel-job-interview-questions/ Mon, 12 Jul 2021 06:49:00 +0000 https://www.xelplus.com/?p=9965 In this article, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions. You'll be surprised at the level of Excel that's currently required for some of these positions.

The post Top Excel Interview Questions – Be Ready for your Next Interview appeared first on Xelplus - Leila Gharani.

]]> How to Generate Random Numbers in Excel https://www.xelplus.com/excel-generate-random-numbers/ Thu, 24 Jun 2021 08:00:00 +0000 https://www.xelplus.com/?p=9988 This tutorial shows you different methods to generate random numbers in Excel (including no repeats). You might need random numbers if you're preparing test data. Or if you need to share your files with consultants and have to replace official values with random ones.

The post How to Generate Random Numbers in Excel appeared first on Xelplus - Leila Gharani.

]]> When to Use the Hash Sign (#) in Excel Formulas https://www.xelplus.com/excel-hash-sign-formulas/ Thu, 21 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10332 What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

The post When to Use the Hash Sign (#) in Excel Formulas appeared first on Xelplus - Leila Gharani.

]]>