SEQUENCE Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sequence/ Bestselling Excel and Power BI Courses Tue, 25 Jun 2024 05:21:24 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png SEQUENCE Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sequence/ 32 32 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.

]]> 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.

]]> Must-Know Excel Functions for 2024 https://www.xelplus.com/excel-functions-office-365/ Thu, 07 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10369 This is the list of the most useful, new Excel Functions you need to know. These will save you from wasting time with complex formulas!

The post Must-Know Excel Functions for 2024 appeared first on Xelplus - Leila Gharani.

]]> How to Create a Calendar in Excel https://www.xelplus.com/calendar-excel-formula/ Thu, 12 Nov 2020 10:00:00 +0000 https://www.xelplus.com/?p=10532 Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.

The post How to Create a Calendar in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Get Top Values in Excel with the FILTER Function https://www.xelplus.com/excel-top-values-filter-function/ Thu, 07 May 2020 09:00:00 +0000 https://www.xelplus.com/?p=11346 Create an Excel report with the top values and categories. Sort them by ranking and also handle duplicated (tied) values. Get it done fast with Excel new dynamic array Sort & Filter formulas.

The post How to Get Top Values in Excel with the FILTER Function appeared first on Xelplus - Leila Gharani.

]]> Practical Excel Dashboards Tips – Ideas to Get Creative https://www.xelplus.com/excel-hash-2019/ Wed, 11 Dec 2019 03:18:00 +0000 https://www.xelplus.com/?p=11674 This Excel dashboard combines 4 strange features to create a dynamic and practical dashboard. It includes FILTER function with XLOOKUP, XOR function, Linked Picture as well as an Icon. You'll find a lot of hidden gems in the way this Excel dashboard was created.

The post Practical Excel Dashboards Tips – Ideas to Get Creative appeared first on Xelplus - Leila Gharani.

]]>