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
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 .
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.
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.
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)
ii) count
This function returns the count of specified range cells value for e.g. =count(a1:b10)
iii) Average
This function will return the average value of specific cells for e.g. =average(a1:b10)
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.
