Introduction To Microsoft Excel

Introduction To Excel

Microsoft Excel is a spreadsheet program used to file and analyse numerical and statistical information. Microsoft Excel offers a number of options to carry out varied operations like calculations, pivot tables, graph instruments, macro programming, and so forth.

In this Microsoft Excel tutorial, we are going to see the introduction to Microsoft Excel, and study the Microsoft Excel fundamentals. These Microsoft Excel notes will enable you to study each MS Excel idea. Let’s begin with the Microsoft Excel introduction.

There are a number of programs available in the world similar to MS Excel; however, out of all of them, Excel is most widely used. People have been utilising it for more than 30 years and all through these years, it has been upgraded by Microsoft with an increasing variety of new features. The better part about Excel is, it may well be used for banking, finance, share market, statistics, billing etc. You can use MS Excel to filter or sort data.

Below are some of the important tasks which Microsoft Excel do for you

i) Store your data in custom defined format 

ii) Prepare various charts and drafts based on your data

iii) Automation of the various tasks thru formulas

How to Open Microsoft Excel?

Running Excel is just not totally different from operating another Windows program. If you’re operating Windows with a GUI like (Windows XP, Vista, and seven) comply with the next steps.

  • Click on begin menu
  • Point to all applications
  • Point to Microsoft Excel
  • Click on Microsoft Excel

Alternatively, it’s also possible to open it from the beginning menu if it has been added there. You can even open it from the desktop shortcut when you’ve created one.

Important Components of MS Excel

a) Cell

Cell is the smallest, however strongest part of an Excel worksheet. You can enter your knowledge (data) right into a cell both by typing or copy paste. Data may be in a character format, numeric format, or may be alphanumeric mixed .

Blank Excel Cells

b) Worksheet

Worksheet is made up of particular person cells which might comprise a worth, a component, or textual content. It additionally has an invisible draw layer, which holds charts, photographs, and diagrams. Each worksheet in a workbook is accessible by clicking the tab on the backside of the workbook window.

MS Excel Worksheet

c) Workbook

A workbook is a separate file similar to each different utility. Each workbook contains a number of worksheets. You can additionally say {that a} workbook is a group of a number of worksheets or is usually a single worksheet. You can add or delete worksheets.

MS Excel Workbook
Excel Basic Functions

Now we will see some of the basic functions of the Excel which are commonly used worldwide.

i) Sum

This function returns the total of the given ranged value for e.g. =sum(b2:b6)

Excel sum function

ii) count 

This function returns the count of specified range cells value for e.g. =count(a1:b10) 

count function

iii) Average

This function will return the average value of specific cells for e.g. =average(a1:b10)

Average Function

So this is a brief introduction of Microsoft Excel and its basic functions.

Important Microsoft Excel shortcuts

Ctrl + P

used to open the print dialogue window

Ctrl + N

creates a brand new workbook

Ctrl + S

saves the present workbook

Ctrl + C

copy contents of present choose

Ctrl + V

paste data from the clipboard

SHIFT + F3

shows the operate insert dialog window

SHIFT + F11

Creates a brand new worksheet

F2

Check method and cell vary coated

Hope you would like this first article of myGeekshb.com. Please share your comments and thoughts in the box below.

Abhijit

Abhijit currently working with India's No. 1 Ecommerce Company Flipkart. He having 6 years experience in Excel and he is also expertise in various Advance Excel formulas. He awarded by his organization for his outstanding contribution in Analytical Project.

Leave a Reply