Introduction to Microsoft Excel (Part1)

Image Collected

As we have already learnt the terminologies of Excel in the previous note, we will straight get to the actual task today!

After entering all the data, if you want to print them, go to the top and click on the file option, there will be a print option where you can view the print copy’s preview . If you want to add more clear lines between the data, you can click and drag the whole table and add borders to make it more specific to display. If you want to color a certain cell , click and drag the whole cell and click on the color option there on top , something that looks like “A” and select the color and the cell will be colored. We can also make it bold, larger or smaller just like normal text. Also you can select and drag the whole table and make it centered to look better just like normal line assigning too. This will make it look clear and professional and easier to analyze data.

Now for formulas,

Always we use equal sign to use formulas . For example , we enter “+10” in a cell. Then if we notice up there, there will be something like a function sign and then an equation.

f (x)= 2*5.

Even though on the particular cell we will only see the 5, not the plus sign before that but will be able to see the function over there on the top.

Now, If we enter 5 into a cell , on the tip , there will be no equation but a 5 only.

Now suppose we want a function that will tell us the average marking of each student here.

We can double click on the column and insert a new column there. In this column we will display the average mark of the student. We name the column “Average”

For that assuming we have already entered the number of courses and the total marks for each student into two different columns here.

Now in the third column we will just write “=” and then click on the total mark of the student from the cell and on the “Average” named column we will see “=B3” and then we hit “/” and click on the total number of courses, on the “Average” named column we will see “=B3/A3” or something like that depends on the column sequence . Right after that if we press enter we will find the average on the cell .We can change the number from decimal to point by entering the small button there right beside the number button and here we can place two or three decimal places to find specific numbers. Now if we select the resulted number and drag and copy the whole column down, that’s the magic!

We will find the average number for all the students automatically !

You can try it at home and can explore yourself easily. Keep practicing.




A Computer Science and Engineering student. Interested in Computer Science, business analytics ,research and editing.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Kubernetes Control Plane Design - Single DC/Zone Deployments

How I passed my eJPT exam

Decode CustomScrollView

Common usage of Docker

Installing and Configuring the AWS CLI

Stay foolish hardworking and consistent hangry

New high! The vEOS volume exceeds 8 million! Weekly Report 20

Python & SurveyCTO: We bring you pysurveycto

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Roy Aishwarjyo

Roy Aishwarjyo

A Computer Science and Engineering student. Interested in Computer Science, business analytics ,research and editing.

More from Medium

8 Free Data Analysis Tools you should know about it

Associate Cloud Engineer Journey — Section 1


Coding Data pipelines? Ditch Vscode/Pycharm — Do it locally with GCP Cloud Shell Editor!

Project Driven Learning with Jeevat