spill range Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/spill-range/ 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 spill range Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/spill-range/ 32 32 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.

]]> Excel Dynamic Arrays – Excel will never be the same https://www.xelplus.com/excel-dynamic-arrays-how-excel-will-change/ Tue, 30 Oct 2018 04:06:00 +0000 https://www.xelplus.com/?p=9576 With the new Excel Dynamic Arrays, we can solve complex tasks with simple formulas. Find out just how much time and frustration you end up saving by being able to Filter, Sort and quickly find Unique values.

The post Excel Dynamic Arrays – Excel will never be the same appeared first on Xelplus - Leila Gharani.

]]>