Kick Start With Microsoft Excel

Hai, Welcome to the Excel Start.

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

BIG DATA ANALYTICS

BIG DATA ANALYTICS Have you ever hit upon how Amazon and Flip kart could possible verdict what we want; how the Google auto completes our search; how the YouTube looks into videos we want to watch? When we open YouTube, we will be at sixes and sevens, when we find ads related to what we have searched earlier in the past days. This is where we find ourselves in the era of big data analytics. More than 3 trillion bytes of information are being generated everyday through our smart phones, tablets, GPS devices, etc. Have we thought about what can be done with all these information? This is where the data analytics comes into play. Big data analytics is just the study of future build up to store data in order to extract the behaviour patterns. The entire social networking website gathers our data which are related to our interest which is usually done by using our past search or any other social information. Data analytics will lead to a walkover in near future....

CLOUD COMPUTING SERVICES

Services provided by Cloud Computing 1. Software as a service : It is process by which the software will be provided by the cloud server's. Instead of using the software in our local machine we can directly use the cloud services directly to get our work done. Example : Google Slides, Google Docs, Google Sheets, Zoho Writer,....etc. 2. Platform as a service : It is process by which you can directly use platform like windows , linux , Mac, ....Which ever you need to done your work. Example : There are certain software which might be run only certain platform. Assume I have windows operating system but i am doing research in BIG DATA. There Linux Operation system might be handy for my research work. Where it is hard for me to put Operating System again and again to my local machine and taking backup data. So Cloud Computing Services Makes our work easier whatever platform we need it will provide u...

Python #23-Regex findall() and sub() in Python

Previous Post : Python #22-Regex match() and search() in Python Next Post : Coming soon........ re.findall(): It find all sub strings where the RE matches, and return them as a list. This function is used to catch all the matching patterns in the strings. Note Worthy: re.match() + re.search() = re.findall() Syntax: re.findall(pattern, string) Source Code: import re variable = re.findall(r"Google", "Google Bird learn around Google and gives the best contents to the viewrs") print variable Output: ['Google', 'Google'] re.sub(): This is used to search a pattern in the string an replace with the new sub string. Syntax: re.sub(pattern, replac...

Tech Bird

Search This Blog