Publications du canal EXCEL FEATURES | BI & AI

📍BIG NEWS!
Microsoft Excel just got a huge upgrade with new REGEX functions! 🎉

Think REGEX is just for the pros? Think again! 😲
In the video 👇 Leyla shows how ANYONE can use these powerful new functions.


🔍 Here's what you'll learn:

- Grab email addresses from long text - even multiple ones.
- Get website addresses - even messy ones from long text.
- Extract dates hidden in text.
- Clean up text by removing special characters.
- Format numbers for readability - like phone or credit card numbers.
- Remove those annoying leading zeros.
- Break up words that are stuck together.
- Extract data inside brackets.

Watch the video and get ready for the time when these functions become available in your Office 365 version.
They are currently in the beta version in Excel Insiders.

https://youtu.be/YFnXV2be9eg?si=_6suMsH2veqNa0Eq

📍📈 Macros and VBA for beginners
What are VBA Macros in Excel? VBA Macros use the Visual Basic Application in Excel to create custom user-generated functions and speed up manual tasks by creating automated processes. Additionally, VBA can be used to access the Windows Application Programming Interface (API).

To learn more about, check out the video ⬇️

https://youtu.be/IJQHMFLXk_c?si=d3viozD3QqdXndW6

🚗 🧮 How to calculate Car loan payments

The key question for most people when taking out a car loan is “What will my monthly payment be?” Fortunately, Excel has been around the block a few times with this kind of question, and there is a special function just for this calculation, called PMT. You can watch this video for better understanding ⬇️

https://youtu.be/Ht70lweo3Wo?si=ZewjaGudOLdrR1jg

🧮📚Financial analysis
In this video you will learn how to calculate NPV and IRR in Excel.
Net present value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time.
By contrast, the internal rate of return (IRR) is a calculation used to estimate the profitability of potential investments.

https://youtu.be/YDpf00QHY0I?si=BR-J4lXuEhy1iJh3

✅👉Some of useful tips how to use SCAN function in Excel.

The Excel SCAN function progressively applies a LAMBDA to each element in an array and returns an array of all intermediate values. This function is particularly useful for generating running totals, cumulative statistics, or constructing sequences based on the array elements and a specified operation.

Check it out ⬇️

https://youtu.be/7vC5Ot6fu6s?si=3_rkn2IKmexOfVBM

✅ 10 essential Excel formulas in 2024
To be competitive, you have to keep up with the new features that enable you to improve productivity, or you’ll be left behind. In this video you can find 10 must know modern Excel functions that simplify common tasks. These functions will not only make your life easier, they’ll also make you the go-to expert at your workplace.

https://youtu.be/rTHrTfcFSB0?si=wFjFkbnxaWEFXp1f

🧮 How to make Stock Control Sheet In Excel. Inventory Management. Inventory Control Sheet In Excel

https://www.youtube.com/watch?v=Cs7OVqDaLqg

🔥 High income Excel skills worth learning in 2024.
Surprisingly, over 50% of job postings in various industries highlight Excel proficiency as a crucial requirement. Whether you're an administrative assistant, sales manager, data analyst, or in other roles, having advanced Excel skills can significantly impact a company's financial success. In this video⬇️ it is explained three key Excel skills that can accelerate your career progression.

https://youtu.be/McLQ3gEGbHQ?si=9EZ2D6e8g-xJrmFI