Learn MS Excel with Riham

Call Directions Website

Learn MS Excel with Riham Here we learn data analysis using Excel from scratch. Follow For more tips & tricks in Excel ...

06/03/2026

ูƒู„ู†ุง ุนุงุฑููŠู† ุฅู† ุงู„ู€ VLOOKUP ุจุชุจุต ูŠู…ูŠู† ุจุณ.. ูˆุฏู‡ ุจูŠุนู…ู„ู†ุง ู…ุดุงูƒู„ ูƒุชูŠุฑ. ๐Ÿ˜ค

In this Short, we break that rule! ู‡ู†ุณุชุฎุฏู… ุฎุฏุนุฉ ุฐูƒูŠุฉ ุฌุฏุงู‹ ูˆู‡ูŠ ุฏู…ุฌ ุงู„ู€ VLOOKUP ู…ุน CHOOSE ุนุดุงู† ู†ุนู…ู„ "Left Search."

#ุงูƒุณู„

01/03/2026

ููŠ ุฃุฎุฑ ููŠุฏูŠูˆ ููŠ ุณู„ุณู„ุชู†ุงุŒ ู‡ู†ุชูƒู„ู… ุนู† ุงู„ู€ "ุงู„ุซู†ุงุฆูŠ" ุงู„ู„ูŠ ู…ุญุฏุด ุจูŠู‚ุฏุฑ ุนู„ูŠู‡! ๐Ÿ’ช INDEX + MATCH ู‡ู…ุง ุงู„ุญู„ ุงู„ูˆุญูŠุฏ ูˆุงู„ู…ุซุงู„ูŠ ู„ูˆ ุดุบุงู„ ุนู„ู‰ ู†ุณุฎุฉ ุฅูƒุณูŠู„ ู‚ุฏูŠู…ุฉ ูˆู…ุญุชุงุฌ ุงู„ู€ Flexibility ูˆุงู„ู‚ูˆุฉ ุจุชุงุนุช ุงู„ู€ XLOOKUP.

In this tutorial, we visualize how this dynamic duo works together like a Precision Robotic Arm. ู‡ู†ุชุนู„ู… ุฅุฒุงูŠ ู†ุฎู„ูŠ MATCH ุชุฏูˆุฑ ุนู„ู‰ ู…ูƒุงู† ุงู„ุตู (Position) ูˆ INDEX ุชุฌูŠุจ ุงู„ู‚ูŠู…ุฉ (Value) ู…ู† ุงู„ุนู…ูˆุฏ ุงู„ู„ูŠ ุฅุญู†ุง ุนุงูŠุฒูŠู†ู‡.. ุจุชุจุต ูŠู…ูŠู†ุŒ ูˆุจุชุจุต ุดู…ุงู„ุŒ ูˆู…ุด ุจุชูˆู‚ู‘ูู‡ุง ุฃูŠ ุญุงุฌุฉ! ๐Ÿง โœจ

#ุฅูƒุณูŠู„

28/02/2026

ุงู†ุณู‰ ู…ุดุงูƒู„ ุงู„ู€ VLOOKUP ุงู„ู‚ุฏูŠู…ุฉ! ๐Ÿ›‘ ุงู„ู€ XLOOKUP ูˆุตู„ุช ุนุดุงู† ุชุฎู„ูŠ ุญูŠุงุชูƒ ุฃุณู‡ู„ ุจูƒุชูŠุฑ.

No more column counting! ู…ุด ู…ุญุชุงุฌ ุชุนุฏ ุฃุนู…ุฏุฉ ูˆู„ุง ุชุดุบู„ ุจุงู„ูƒ ู„ูˆ ุงู„ู€ Data ุนู„ู‰ ุงู„ุดู…ุงู„. ุงู„ู€ XLOOKUP ุจุชุนู…ู„ ูƒู„ ุญุงุฌุฉ ููŠ ุฎุทูˆุฉ ูˆุงุญุฏุฉ ูˆุจู…ู†ุชู‡ู‰ ุงู„ุฐูƒุงุก. ๐Ÿง โœจ

Why it's better?
โœ… No Left/Right limits = ุจุชุจุต ููŠ ูƒู„ ุงู„ุงุชุฌุงู‡ุงุช.
โœ… Exact Match by default = ู…ุด ู„ุงุฒู… ุชูƒุชุจ 0 ููŠ ุงู„ุขุฎุฑ.

Upgrade your Excel skills and start using it now! ๐Ÿš€๐Ÿ”ฅ

#ุฅูƒุณูŠู„

27/02/2026

ุงู„ู€ VLOOKUP ู‡ูŠ ุฃูˆู„ ุฎุทูˆุฉ ุนุดุงู† ุชูƒูˆู† "ู…ู…ูŠุฒ" ููŠ ุงู„ู€ Data Entry ูˆุงู„ุชุญู„ูŠู„! ๐Ÿ˜Ž

In this short, we explain the most famous lookup formula. ู‡ู†ุชุนู„ู… ุฅุฒุงูŠ ู†ุณุชุฎุฏู… ุงู„ู€ VLOOKUP ุนุดุงู† ู†ุฏูˆุฑ ุนู„ู‰ ุฃูŠ ู…ุนู„ูˆู…ุฉ ููŠ ุงู„ุฌุฏูˆู„ ุจุชุงุนู†ุง ุจุณุฑุนุฉ ุงู„ุตุงุฑูˆุฎ. ๐Ÿš€

Remember:
๐Ÿ” Lookup Value = ุจุชุฏูˆุฑ ุนู„ู‰ ุฅูŠู‡ุŸ
๐Ÿ“‚ Table Array = ุจุชุฏูˆุฑ ููŠู†ุŸ
๐Ÿ”ข Col Index = ุงู„ู†ุชูŠุฌุฉ ููŠ ุฃู†ู‡ูŠ ุนู…ูˆุฏุŸ

Keep it simple and start your Excel journey today! ๐Ÿ‘จโ€๐Ÿ’ปโœจ

#ุฅูƒุณูŠู„

07/02/2026

Use =COUNTA(UNIQUE(range)) to get the exact number of individual customers instantly. It even updates when you add new data!

06/02/2026

Stop hunting for duplicates manually! ๐Ÿ•ต๏ธโ€โ™‚๏ธ Use Conditional Formatting to instantly highlight repeating values in red.

04/02/2026

Stop typing manual lists! ๐Ÿ›‘ Use the UNIQUE function to instantly pull every distinct item from a column, then use SUMIF to get totals for that list automatically.

02/02/2026

Stop counting days on your fingers! ๐Ÿ›‘ Just subtract the MIN date from the MAX date to get the exact timespan of your data range.

31/01/2026

Stop guessing and start knowing! ๐ŸŽฏ Use AVERAGE to find your performance baseline and COUNTIF to instantly calculate the frequency of specific items in your list.

#

28/01/2026

Raw data is useless without insights. ๐Ÿ“‰
Here is the quickest way to find your totals, volume, and outliers using Excel.

26/01/2026

Found a negative number? Don't just "fix" it. A pro analyst investigates it first. Always verify before you change the data. ๐Ÿ”

24/01/2026

Still scrolling through thousands of rows to find duplicates? Stop! โœ‹ In just two clicks, Excel can clean your entire dataset. Here is how the "Remove Duplicates" tool works on our sales data.

Address

6 October City
6 October City

Opening Hours

Monday 5pm - 11pm
Tuesday 9am - 5pm
Wednesday 9am - 5pm
Thursday 9am - 5pm
Friday 9am - 5pm
Saturday 9am - 5pm
Sunday 9am - 5pm

Telephone

+201061577557

Website

Alerts

Be the first to know and let us send you an email when Learn MS Excel with Riham posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category