Hai, Welcome to the Excel Start.
Ok Come on.
Let’s start with simple addition operation via Excel Spreadsheet.
Above is the Example:
First of all fill your data like this…
A1 – Monday B1 – 1500 C1 – 1500 in D1 instead of Typing 3000 Type “=B1+C1”
A2 – Tuesday B2 – 2000 C2 – 3000 in D2 instead of Typing 5000 Type “=B2+C2”
You will get the Output sum of the Two cell in the Result Cell..
Easy Right??
Now let’s try same procedure for Subtraction:
Above is the Example:
First of all fill your data like this…
A4 – Wednesday B4 – 2000 C4 – 1000 in D4 instead of Typing 1000 Type “=B4-C4”
and press enter…
In this same way we can able to perform for Division and Multiplication Operation too.
Microsoft Excel is a spreadsheet program that is used to record and analyze numerical data.
What is MS-Excel?
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Source: Wikipedia
Why Should I Learn Microsoft Excel?
We all deal with numbers in one way or the other. We all have daily expenses which we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze and store such numeric data.
- Open Excel Spreadsheet.
- Now the excel looks like row and column Layout right.
- With that it also have the column name and Row Number.
- As a beginner we never know why they kept those things in the Excel sheet, Trust me because of that excel give us faster computation on math.
Row’s will be given as number’s like 1, 2, 3, 4, 5, …… etc. in Vertical Manner.
Column will be given as Alphabet’s like A, B, C, D, …etc. in Horizontal Manner.
Ok Come on.
Let’s start with simple addition operation via Excel Spreadsheet.
Above is the Example:
First of all fill your data like this…
A1 – Monday B1 – 1500 C1 – 1500 in D1 instead of Typing 3000 Type “=B1+C1”
A2 – Tuesday B2 – 2000 C2 – 3000 in D2 instead of Typing 5000 Type “=B2+C2”
You will get the Output sum of the Two cell in the Result Cell..
Easy Right??
Now let’s try same procedure for Subtraction:
Above is the Example:
First of all fill your data like this…
A4 – Wednesday B4 – 2000 C4 – 1000 in D4 instead of Typing 1000 Type “=B4-C4”
and press enter…
Monday 1500 1500 3000
Tuesday 2000 3000 5000
Wednesday 2000 1000 1000
In this same way we can able to perform for Division and Multiplication Operation too.
Thank you...
Come back to learn more from ♥Tech Bird♥
Comments