முதன்மை உள்ளடக்கத்திற்குச் செல்

Essential Excel Formulas and Functions

 Microsoft Excel is one of the most versatile tools for managing, analyzing, and visualizing data. Whether you’re working in business, engineering, accounting, or academics, Excel formulas and functions can save hours of manual work. Learning the most essential ones will boost your productivity and make your spreadsheets smarter and more efficient.

In this blog, we’ll explore the most commonly used Excel formulas and functions, with examples to help you understand how they work.

🔹 What Are Excel Formulas and Functions?

A formula is an expression that performs calculations on values in your worksheet. It usually begins with an equal sign (=) and can include operators like +, -, *, /, and references to cells.

Example:

= A1 + B1

adds the values of cells A1 and B1.

A function, on the other hand, is a predefined formula that performs specific calculations using built-in Excel syntax.

Example:

=SUM(A1:A5)

adds all numbers from cell A1 to A5 automatically.

🔹 Basic Arithmetic Formulas

Before moving to complex functions, it’s important to know the basic arithmetic formulas:

  • Addition: =A1 + B1

  • Subtraction: =A1 - B1

  • Multiplication: =A1 * B1

  • Division: =A1 / B1

  • Power: =A1 ^ 2 (square of A1)

These simple formulas are the building blocks for more advanced Excel operations.

🔹 Commonly Used Excel Functions

Below are some essential functions every Excel user should master.

1. SUM() – Add Numbers Quickly

The SUM function adds values in a range.
Example:

=SUM(A1:A10)

adds all numbers from A1 through A10.

Tip: You can also combine non-adjacent ranges — =SUM(A1:A5, C1:C5)

2. AVERAGE() – Find the Mean

This function calculates the average value of a range.
Example:

=AVERAGE(B1:B5)

is perfect for finding test scores or sales averages.

3. MIN() and MAX() – Find Extremes

These functions help you identify the smallest and largest values in a dataset.
Example:

=MIN(A1:A20)
=MAX(A1:A20)

4. COUNT() and COUNTA() – Count Data Points

  • =COUNT(A1:A10) counts cells with numbers only.

  • =COUNTA(A1:A10) counts all non-empty cells, including text.

Useful when you need to count entries or data rows.

5. IF() – Apply Logical Conditions

The IF function lets you apply conditions to your data.
Syntax:

=IF(condition, value_if_true, value_if_false)

Example:

=IF(A1>=50, "Pass", "Fail")

checks whether a value is above 50 and returns either Pass or Fail.

6. CONCATENATE() / CONCAT() – Join Text

Used to combine text from multiple cells.
Example:

=CONCAT(A1, " ", B1)

joins first and last names in two cells.

Note: In newer Excel versions, use TEXTJOIN() or CONCAT() instead of CONCATENATE().

7. TODAY() and NOW() – Insert Dates and Time

  • =TODAY() displays the current date.

  • =NOW() displays the current date and time.

These update automatically every time you open the workbook.

8. VLOOKUP() – Search for Data Vertically

The VLOOKUP function is used to look up data in a table by matching a value in the first column.
Syntax:

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

Example:

=VLOOKUP(A2, B2:D10, 3, FALSE)

searches for a value in column B and returns data from the third column.

9. HLOOKUP() – Search Horizontally

Similar to VLOOKUP but searches across rows instead of columns.

=HLOOKUP(A1, A2:F5, 3, FALSE)

10. SUMIF() and COUNTIF() – Conditional Calculations

These functions combine arithmetic with conditions.
Examples:

=SUMIF(A1:A10, ">100")
=COUNTIF(B1:B10, "Pass")

They’re perfect for filtering totals or counts based on criteria.

🔹 Bonus: Text and Date Functions

  • LEFT(A1,3) – Extracts first 3 characters.

  • RIGHT(A1,4) – Extracts last 4 characters.

  • LEN(A1) – Counts total characters.

  • TEXT(A1, "dd-mm-yyyy") – Formats dates.

These functions help clean and prepare data efficiently.

🔹 Conclusion

Excel formulas and functions are the heart of every spreadsheet. By mastering the essential ones — from SUM and IF to VLOOKUP and COUNTIF — you’ll transform your Excel skills and save hours of manual work.

Start with basic arithmetic, then practice applying these formulas in real-world data sets. The more you use them, the more confident you’ll become in handling data like a professional analyst.

லேபிள்கள்:

கருத்துகள்

கருத்துரையிடுக

இந்த வலைப்பதிவில் உள்ள பிரபலமான இடுகைகள்

How to improve the speed of your computer

 Is your PC is getting slow? Is it hang frequently? Is there any simple solutions to speed up your PC? Yes.. there are some small tips available , which will increase the speed of you Desktop or laptop   1) Temporary files cleaning Press Win+R button -> now Run command will come Type %temp% and hit enter   Now all the temporary files will get opened. Select all the files by pressing Ctrl + A , and press Shift + Delete button. All the files will get deleted .   2) Clean the Recycle Bin Right Click on Recycle Bin and select Empty Recycle bin. Now all the recycle bin items will get deleted permanently Note : Before deleting the Recycle bin. Go inside the Recycle bin, and check any item is required. Just Right click and select restore. Not the file will go to respective folder, from where it got deleted.   3) Terminate the less important tasks   Open the task manager by pressing Ctrl+Alt+Del Click on the processes ...
கருத்துரையிடுக
மேலும் படிக்கவும்

Basics of Computer in English

Introduction to Computers :   In today's modern world, computers have become an essential part of our lives. Whether it's for work, education, or entertainment, we rely heavily on these electronic machines to carry out various tasks. But, have you ever stopped to think about what exactly a computer is and how it works? In this article, we will discuss the basics of computers, including their components and functions. What is a computer? A computer is an electronic device that accepts input, processes data, and produces output. It is capable of performing various tasks, including calculations, data storage and retrieval, communication, and multimedia processing. At its most basic level, a computer consists of two main components: hardware and software. Hardware Components of a Computer Hardware refers to the physical components that make up a computer. The most important hardware components of a computer include: 1. Central Processing Unit (CPU) The CPU is the brain of the co...
கருத்துரையிடுக
மேலும் படிக்கவும்

MS Excel in Tamil (Introduction)

  விரிதாள் ( Microsoft Excel)              மக்களது அன்றாட தேவைகளுக்கு மட்டுமன்றி தொழில் ரீதியான தேவைகளுக்கும் பல்வேறு   கணக்குகளை செய்வது அவசியமாகும். இந்த கணக்குகளை செய்வதற்கு மக்கள் பல்வேறு உபாயங்களை பயன்படுத்துகின்றனர்.பிரச்சனைகளின் தன்மைகளை பொறுத்து பல்வேறு முறைகள் கையாளப்படுகின்றன. கணிப்பதற்கு என மனதையும் விரல்களையும் உபயோகிக்கின்றனர். சிக்கலான விஷயங்களை தீர்ப்பதற்கு எழுதித் தீர்த்தல் அல்லது கணிப் பொறிகள் பயன்படுத்தப்படுகின்றன. எனினும் இந்தக் கணித்தல் பணிகளை செம்மையாகவும் இலகுவாகவும் செய்வதற்கென Spread Sheet (EXCEL) எவ்வாறு பயன்படுத்தலாம் என்பது பற்றி அறிந்து கொள்வோம்.            முறையாகவும் எழுத்து மூலமும் கணக்குகளை செய்வதற்காக கணித தாள்களை பயன்படுத்துவது எமது வழக்கமாகும் . இத்தாள்கள் நிலைகுத்து(Columns) நிரல்களையும் கிடையான(Rows) நிரைகளையும் கொண்டுள்ளன. இதன் அடிப்படையிலேயே பெருமளவு நிரல்களையும் நிரைகளையும் கொண்ட விரித்தாள்கள் (Spread sheets) அமைக்கப்பட்டுள்ளன.        விரிந...
கருத்துரையிடுக
மேலும் படிக்கவும்