مَسِيْرَةُ ⚖ مُحَاْسِبْ

إعلان مؤقت "غير ممول"

التسجيل في القرعة الأمريكية "اللوتري 2025":
سجل باليانصيب (بمبلغ رمزي)، وربما يحالفك الحظ وتفوز باليانصيب وتسافر أمريكا بدون تعب

الشروط:

1. صورة شخصية رسمية و تكون واضحة الملامح بدون نظارة أو شال، للإناث صورة شخصية رسمية بالحجاب.

2. الاسم الكامل باللغة الانجليزية من واقع البطاقة الشخصية أو الجواز إن وجد.

3. الإيميل الخاص بك.

4. صورة الجواز ان وجد.

5. ذكر تفاصيل التعليم طالب جامعي او خريج جامعي او خريج ثانوية.

6. تاريخ ومكان الميلاد.

7. عنوان السكن الحالي: المدينة - المنطقة - الشارع.

ملاحظات:

1. الحد الأدنى للتعليم: ثانوية عامة، لايقبل أقل.
2. يجب أن تكون البيانات مطابقة للإثباتات الرسمية من بطاقة شخصية أو جواز سفر أو شهادة جامعية أو شهادة ثانوية عامة.
3. آخر موعد للتسجيل في اللوتري هو تاريخ 5 نوفمبر 2024.
4. من المرجح أن تكون هذه آخر سنة يتم فيها استقطاب الوافدين الى أمريكا عبر اليانصيب، خصوصاً إذا فاز ترامب بالانتخابات الأمريكية.
5. سيتم توثيق نجاح الطلب، ورمز الموافقة للاحتفاظ به لحين إعلان النتائج لمعرفة إذا تم الفوز بالفرصة أم لا، بعد دقائق من إرسال البيانات...
5. يتم تحويل تكلفة التسجيل البالغة 2,000 YER عبر حساب الكريمي الذي سيتم تزويدكم به، قبل إرسال الموافقة.

للتسجيل يمكنكم التواصل عبر المستخدم التالي:
@moodyhh


بالتوفيق للجميع...

Rabi' 12, 1446 💚

VLOOKUP vs. XLOOKUP 💡


1️⃣ Definition:

VLOOKUP: Stands for Vertical Lookup. It's a function used to search for a value in the first column of a range and return a value in the same row from another column.

XLOOKUP: A newer function introduced in Excel that stands for Extended Lookup. It's designed to overcome some limitations of VLOOKUP and offers more flexibility and capabilities.

2️⃣ Syntax:

VLOOKUP: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

XLOOKUP: =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

3️⃣ Functionality:

VLOOKUP: Searches for a value in the leftmost column of a table and returns a value in the same row from a column you specify.

XLOOKUP: More versatile and can perform lookups in any direction (horizontal or vertical). It also allows for approximate and exact matches without sorting data.

4️⃣ Lookup Modes:

VLOOKUP: Supports only approximate match (TRUE) or exact match (FALSE).

XLOOKUP: Supports four search modes: exact match, exact match with wildcard characters, approximate match, and the ability to return the last matching item.

5️⃣ Column Indexing:

VLOOKUP: Requires specifying the column index number where the return value is located.

XLOOKUP: Automatically returns values based on their position in the lookup and return arrays, eliminating the need for a separate column index number.

6️⃣ Handling Errors:

VLOOKUP: May return errors if the lookup value is not found or if the table is not sorted (for approximate matches).

XLOOKUP: Allows for customizable error handling with the [if_not_found] parameter, providing more control over error messages.

7️⃣ Compatibility:

VLOOKUP: Available in older versions of Excel and widely used in legacy spreadsheets.

XLOOKUP: Available in Excel 365 and Excel 2021, so compatibility may be limited to newer versions unless using the XLOOKUP function backport.

8️⃣ Performance:

VLOOKUP: Known to be slower, especially with large datasets, due to its limitations and the need for sorted data.

XLOOKUP: Generally faster and more efficient, especially for unsorted data and complex lookup scenarios.

9️⃣ Use Cases:

VLOOKUP: Suitable for simple vertical lookups where data is sorted and the lookup value is in the leftmost column.

XLOOKUP:Ideal for more complex lookup scenarios, unsorted data, and when flexibility and efficiency are paramount.

#مسيرة_محاسب 🌟

10 Excel Functions You Should Know 💡

1️⃣ SUMIFS A versatile function used to calculate the sum of values in a range that meets multiple specified criteria. It allows you to define multiple conditions and sum the corresponding values that satisfy those conditions.

2️⃣ IFERROR A function that helps handle errors in formulas. It allows you to specify a value or action to be taken if a formula returns an error, helping you display custom messages or alternative results instead of error codes.

3️⃣ XIRR Calculates the internal rate of return for a series of cash flows that occur at irregular intervals. It takes into account both the magnitude and timing of cash flows, providing a more accurate measure of investment returns when the cash flows are not evenly spaced.

4️⃣ XNPV Calculates the net present value of a series of cash flows that occur at irregular intervals, considering the specified discount rate. It helps determine the present value of cash flows, accounting for the time value of money and enabling better evaluation of investment projects.

5️⃣ PMT Calculates the periodic payment required to repay a loan or investment with a fixed interest rate over a specific period. It helps determine the constant payment amount needed to cover principal and interest expenses within the given time frame.

6️⃣ SLOPE A statistical function used to calculate the slope of a linear regression line between two sets of data points. It measures the relationship and direction (positive or negative) between the independent variable (x-values) and the dependent variable (y-values).

7️⃣ XLOOKUP A powerful function that allows you to search for a value in a range or array and retrieve a corresponding value from another column or row. It offers flexibility in searching for exact or approximate matches, handling errors, and performing lookups in both vertical and horizontal directions.

8️⃣ INDEX & MATCH: Functions often used together to perform more advanced lookups. INDEX returns a value from a specified range based on the row and column numbers provided. MATCH, on the other hand, finds the position of a specified value within a range. By combining these functions, you can perform lookups based on multiple criteria and retrieve the desired information.

9️⃣ EOMONTH Calculates the last day of the month based on a specified date. It helps with various date-related calculations such as determining project deadlines, tracking payment due dates, or calculating the end of a financial reporting period.

🔟 SEQUENCE Generates an array of sequential numbers based on specified parameters. It allows you to create a sequence of numbers with custom increments, starting points, and row or column orientations, enabling efficient creation of numeric series or dynamic arrays. 

#مسيرة_محاسب 🌟