12 Excel Formulas Every Excel User Must Know" in Bangla

Titled "12 Excel Formulas Every Excel User Must Know" in Bangla
Welcome to our Bangla tutorial on Excel! In this video, we will guide you through 12 essential Excel formulas that every Excel user should know. Whether you're a beginner or an experienced user, mastering these formulas will enhance your productivity and data analysis skills.

In this comprehensive tutorial, we will cover a range of formulas including SUM, AVERAGE, VLOOKUP, IF, COUNT, and more. We'll explain the purpose of each formula and demonstrate how to use them effectively in real-world scenarios. By the end of this tutorial, you'll have a solid foundation in these essential Excel formulas.

Timestamps:
0:00 - Introduction
0:50 - Formula 1: SUM
2:15 - Formula 2: AVERAGE
3:40 - Formula 3: VLOOKUP
5:05 - Formula 4: IF
6:30 - Formula 5: COUNT
8:00 - Formula 6: CONCATENATE
9:25 - Formula 7: MAX and MIN
10:50 - Formula 8: ROUND
12:15 - Formula 9: SUMIF
13:40 - Formula 10: INDEX and MATCH
15:05 - Formula 11: LEFT and RIGHT
16:30 - Formula 12: LEN
17:55 - Conclusion

Don't miss this opportunity to enhance your Excel skills and boost your productivity. Watch this tutorial now and become proficient in these 12 essential Excel formulas!

Remember to like, comment, and subscribe to our channel for more helpful tutorials on Excel and other useful topics. Stay tuned for upcoming videos and stay ahead in your Excel journey!

#BanglaExcelTutorial #ExcelFormulasBangla #ExcelSkills #DataAnalysis #MicrosoftExcel

Please Subscribe Us: https://bit.ly/2QZDxVg

Table of Contents:
Sum
Maximum
Minimum
Average
IF
Drop Down
Sumif
Subtotal
Vlookup
Counta
Countif
Currency Symbol.

Sum:
The first Excel function you should be familiar with is the one that performs the basic arithmetic operation of addition
Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula.

Maximum & Minimum
=MAX(A2:A7) Largest number in the range (27)
=MIN(A2:A7) Smallest number in the range (0)

Average:
For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

If:
Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. For example: =IF(A2 Greater Than B2,"Over Budget","OK") =IF(A2=B2,B4-A4,"")

Drop down list
to an Excel sheet, do the following:
Create the list in cells A1:A4. ...
Select cell E3. ...
Choose Validation from the Data menu.
Choose List from the Allow option's drop down list. ...
Click the Source control and drag to highlight the cells A1:A4. ...
Make sure the In-Cell Dropdown option is checked.

Sumif
For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John."

=SUBTOTAL (function_num, ref1, [ref2], ...)
function_num - A number that specifies which function to use in calculating subtotals within a list.

In the Formula Bar, type =VLOOKUP().
In the parentheses, enter your lookup value, followed by a comma. ...
Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,
Enter column index number. ...
Enter the range lookup value, either TRUE or FALSE.

For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.

Excel COUNTIF Function
Summary. COUNTIF is a function to count cells that meet a single criterion. ...
Count cells that match criteria.
A number representing cells counted.
=COUNTIF (range, criteria)
range - The range of cells to count. criteria - The criteria that controls which cells should be counted.

To do this, select the cells you want to format. Then, select “Currency” from the “Number Format” drop-down list in the “Number” section of the “Home” tab. The numbers in the selected cells are all formatted as currency with Windows' default currency symbol applied

Tags: #ExcelFormulas
#ExcelTips
#SpreadsheetTips
#DataAnalysis
#MicrosoftExcel
#ExcelFunctions
#ExcelTricks
#ExcelTutorials
#ExcelTraining
#ExcelSkills
#ProductivityHacks
#datamanipulation
#BanglaExcelTutorial
#এক্সেলফর্মুলা
#স্প্রেডশীটটিপস
#ডেটা_এনালাইসিস
#MicrosoftExcelBangla
#এক্সেলফাংশনস
#এক্সেলট্রিকস
#এক্সেলটিউটোরিয়াল
#এক্সেলপ্রশিক্ষণ
#এক্সেলদক্ষতা
#প্রয়োজনীয়তা_হ্যাকস
#ডেটা_ম্যানিপুলেশন

Please Subscribe Us: https://bit.ly/2QZDxVg

Like us on Facebook: https://bit.ly/39vZl0U

Follow us on Twitter : https://bit.ly/2WSf8og

Visit Our Web Site : https://bit.ly/2RyM8yo