MS Excel 20 Formula For New Job Holders ✔ Microsoft Excel Tutorial in Bangla 2023

MS Excel 20 Formula For New Job Holders ✔ Microsoft Excel Tutorial in Bangla 2023

Working File: Click Here

Certainly, Excel is a powerful tool that can be incredibly useful for new job holders across various industries. Here are some essential Excel formulas that can be beneficial for someone starting a new job:

• SUM Formula: Used to add up a range of numbers.

=SUM(range)

• AVERAGE Formula: Calculates the average of a range of numbers.

=AVERAGE(range)

• IF Formula: Helps in making decisions based on a condition.

=IF(condition, value_if_true, value_if_false)

• VLOOKUP Formula: Searches for a value in a range and returns a corresponding value from another range.

=VLOOKUP(lookup_value, table_range, column_index, [range_lookup])

• HLOOKUP Formula: Similar to VLOOKUP but searches in a horizontal table.

=HLOOKUP(lookup_value, table_range, row_index, [range_lookup])

• INDEX-MATCH Formula: An alternative to VLOOKUP, often more versatile.

=INDEX(column_range, MATCH(lookup_value, lookup_range, [match_type]))

• COUNT Formula: Counts the number of cells in a range that contain numbers.

=COUNT(range)

• COUNTA Formula: Counts the number of non-empty cells in a range.

=COUNTA(range)

• CONCATENATE Formula: Combines text from multiple cells into one cell.

=CONCATENATE(text1, text2, ...)

• TEXT Formula: Converts a value to text in a specific format.

=TEXT(value, format_text)

• DATE Formula: Creates a date using year, month, and day values.

=DATE(year, month, day)

• NOW Formula: Displays the current date and time.

=NOW()

• LEN Formula: Calculates the length (number of characters) of a text string.

=LEN(text)

• LEFT and RIGHT Formulas: Extract a specified number of characters from the left or right side of a text string.

=LEFT(text, num_characters)

=RIGHT(text, num_characters)

• TRIM Formula: Removes extra spaces from a text string.

=TRIM(text)

• MIN and MAX Formulas: Find the minimum or maximum value in a range.

=MIN(range)

=MAX(range)

• NETWORKDAYS Formula: Calculates the number of working days between two dates, excluding weekends and specified holidays.

=NETWORKDAYS(start_date, end_date, [holidays])

• PMT Formula: Calculates the payment amount for a loan based on interest rate, principal, and number of payments.

=PMT(rate, nper, pv)

• RAND Formula: Generates a random number between 0 and 1.

=RAND()

• HYPERLINK Formula: Creates a clickable hyperlink to a specified URL or location.

=HYPERLINK(link_location, [friendly_name])

These formulas cover a wide range of functions that can be useful in various job roles and tasks. Learning and mastering these formulas will provide you with a strong foundation for using Excel effectively in your new job.