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.

Free Demo Classes

Register here for Free Demo Classes

Please fill the name
Please enter only 10 digit mobile number
Please select course
Please fill the email
Something went wrong!
Download App & Start Learning
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.

Source: Safalta.com

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.
 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.

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

 

 

Free Demo Classes

Register here for Free Demo Classes

Trending Courses

Master Certification in Digital Marketing  Programme (Batch-14)
Master Certification in Digital Marketing Programme (Batch-14)

Now at just ₹ 64999 ₹ 12500048% off

Professional Certification Programme in Digital Marketing (Batch-8)
Professional Certification Programme in Digital Marketing (Batch-8)

Now at just ₹ 49999 ₹ 9999950% off

Advanced Certification in Digital Marketing Online Programme (Batch-25)
Advanced Certification in Digital Marketing Online Programme (Batch-25)

Now at just ₹ 21999 ₹ 3599939% off

Advance Graphic Designing Course (Batch-10) : 100 Hours of Learning
Advance Graphic Designing Course (Batch-10) : 100 Hours of Learning

Now at just ₹ 16999 ₹ 3599953% off

Flipkart Hot Selling Course in 2024
Flipkart Hot Selling Course in 2024

Now at just ₹ 10000 ₹ 3000067% off

Advanced Certification in Digital Marketing Classroom Programme (Batch-3)
Advanced Certification in Digital Marketing Classroom Programme (Batch-3)

Now at just ₹ 29999 ₹ 9999970% off

Basic Digital Marketing Course (Batch-24): 50 Hours Live+ Recorded Classes!
Basic Digital Marketing Course (Batch-24): 50 Hours Live+ Recorded Classes!

Now at just ₹ 1499 ₹ 999985% off

WhatsApp Business Marketing Course
WhatsApp Business Marketing Course

Now at just ₹ 599 ₹ 159963% off

Advance Excel Course
Advance Excel Course

Now at just ₹ 2499 ₹ 800069% off