Excel Formulas for Beginners

Safalta expert Published by: Saksham Chauhan Updated Thu, 01 Sep 2022 10:12 AM IST

Highlights

Check Excel Formulas for Beginners here at safalta.com.

Data can be recorded, analysed, and visualised using Microsoft Excel, a software programme produced by Microsoft. Microsoft created the spreadsheet programme Excel in 1985. Excel displays data in rows and columns. When recording and analysing data, performing mathematical operations, and visualising structured data in charts and graphs, Excel is frequently utilised. The ability to automate processes using Excel macros is the last and most significant use of Excel.To become an expert in financial analysis, beginners must first master the fundamental Excel formulas. The most widely used piece of data analysis software is Microsoft Excel. In addition, investment bankers and financial analysts frequently use Microsoft's spreadsheet programme for data processing, financial modelling, and presentation.

Source: Safalta.com


 Download these FREE Ebooks:
1. Introduction to Digital Marketing
2. Website Planning and Creation

7 Simple Excel Formulas

Let's check some basic Excel functions to get you started now that you can accurately insert your favourite formulas.

Free Demo Classes

Register here for Free Demo Classes



1. SUM

The first Excel calculation you need to master is the SUM function. It typically averages numbers from a few of the columns or rows in the range you've chosen.

=SUM(number1, [number2], …)

Example:

=SUM(B2:G2) – A simple selection that sums the values of a row.

=SUM(A2:A8) – A simple selection that sums the values of a column.

=SUM(A2:A7, A9, A12:A15) – A sophisticated collection that sums values from range A2 to A7, skips A8, adds A9, jumps A10 and A11, then finally adds from A12 to A15.

=SUM(A2:A8)/20 – Shows you can also turn your function into a formula.


2. AVERAGE

The AVERAGE function should bring to mind straightforward averages of data, such the typical proportion of shareholders in a particular shareholding pool.

=AVERAGE(number1, [number2], …)

Example:

=AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2:B11)/10)
 

3. COUNTA

The COUNTA function, like the COUNT function, counts every cell in a given rage. However, regardless of cell type, it counts every cell. In other words, it counts dates, times, strings, logical values, errors, empty strings, and text in addition to numbers, unlike COUNT, which only counts numbers.

=COUNTA(value1, [value2], …)

Example:

COUNTA(C2:C13) – Counts rows 2 to 13 in column C regardless of type. However, like COUNT, you can’t use the same formula to count rows. You must make an adjustment to the selection inside the brackets – for example, COUNTA(C2:H2) will count columns C to H


4. COUNT

The COUNT function totals the number of cells in a given range that are empty of any other data.

=COUNT(value1, [value2], …)

Example:

COUNT(A:A) – Counts all values that are numerical in A column. However, you must adjust the range inside the formula to count rows.

COUNT(A1:C1) – Now it can count rows.

5 . MAX & MIN

The MAX and MIN functions assist in determining the highest and lowest value within a range of numbers.

=MIN(number1, [number2], …)

Example:

=MIN(B2:C11) – Finds the minimum number between column B from B2 and column C from C2 to row 11 in both columns B and C.

=MAX(number1, [number2], …)

Example:

=MAX(B2:C11) – Similarly, it finds the maximum number between column B from B2 and column C from C2 to row 11 in both columns B and C.

6. TRIM

The TRIM function ensures that additional spaces in your data won't cause your functions to return errors. It guarantees that there are no open spots. TRIM only works on a single cell, unlike other functions that can work on a variety of cells. As a result, it has the drawback of populating your spreadsheet with duplicate data.

=TRIM(text)

Example:

TRIM(A2) – Removes empty spaces in the value in cell A2.

7. IF

When you wish to sort your data based on a certain logic, the IF function is frequently employed. The ability to embed formulas and functions makes the IF formula the best.

=IF(logical_test, [value_if_true], [value_if_false])

Example:

=IF(C2 – Checks if the value at C3 is less than the value at D3. If the logic is true, let the cell value be TRUE, otherwise, FALSE

=IF(SUM(C1:C10) > SUM(D1:D10), SUM(C1:C10), SUM(D1:D10)) – An example of a complex IF statement. First, it sums C1 to C10 and D1 to D10, then it compares the sum. If the sum of C1 to C10 is greater than the sum of D1 to D10, then it makes the value of a cell equal to the sum of C1 to C1

 

 

Related Article

UP Police Result: यूपी पुलिस भर्ती के अभ्यर्थी कर रहे अंक जारी करने की मांग, बोर्ड ने दी प्रतिक्रिया

Read More

RRB ALP Admit Card: 25 नवंबर की एएलपी भर्ती परीक्षा के लिए जारी हुआ प्रवेश पत्र, जानें डाउनलोड करने का तरीका

Read More

CHSE Odisha Class 12 date sheet 2025 out now; Check the exam schedule here

Read More

CBSE Date Sheet 2025: सीबीएसई बोर्ड कक्षा 10वीं 12वीं की डेटशीट हुई जारी, यहां देखें पूरा शेड्यूल

Read More

CBSE Date Sheet 2025: Class 10, 12 timetable at cbse.gov.in awaited, Check the latest update here

Read More

CBSE Board Exam 2025: सीबीएसई बोर्ड 10वीं- 12वीं के लिए जल्द जारी होगी डेटशीट, पिछले साल इस दिन हुई घोषित

Read More

UP Board Exam 2025: यूपी बोर्ड कक्षा 10वीं-12वीं के लिए घोषित हुईं परीक्षा तिथियां, यहां देखें पूरा शेड्यूल

Read More

UP Board Datesheet 2025: Class 10, 12 Exams from 24 February, Check the full schedule here

Read More

UP Board Eams 2025: यूपी बोर्ड परीक्षा की संभावित तिथि जारी, महाकुंभ की वजह से देरी से शुरू होंगे एग्जाम्स

Read More