MS Excel Tutorials

MS EXCEL

MS Excel is such a computer software, which is used in a small to big business. Usually MS Excel is used to organize data in its own way and do data analysis.
MS Excel is a spreadsheet software which is made up of a combination of Rows & Columns.


How to open MS Excel 

Step1- Left click on Windows Button 
Step2 - Left click on All Programs 
Step3 - Left click on Microsoft Office
Step4 - Left click on Microsoft Excel 2016



What is a spreadsheet?

A spreadsheet is the computerized equivalent of a general ledger. It has taken the place of the pencil, paper, and calculator. The electronic spreadsheet is laid out similar to the paper ledger sheet in that it is divided into columns and rows. Any task that can be done on paper can be performed on an electronic spreadsheet faster and
more accurately.

The Ribbon

The Ribbon is designed to help you quickly find the commands that you need to complete a task. The  Commands are organized in logical groups, which are collected together under Tabs. Each Tab relates to a type of activity, such as formatting or laying out a page. To reduce clutter, some Tabs are shown only when needed. For example, the Picture Tools tab is shown only when a picture is selected.

Formula Bar 

A place where you can enter or view formulas or text.

Columns and Cells and Row

The horizontal bar across the top of the worksheet area is filled with letters, beginning with A. Each letter represents a column while the vertical bar on the left side of the worksheet filled with numbers refers to rows Each number represents a row .

Cell 

Cell make with the column and row , Each cell has its own address. This address is used in formulas for referencing different parts of the worksheet. The address of a cell is defined by the letter of the column in which it is located and the number of the row.  For example, the address of a cell in column B, row 5 would be referred to as B5.

How to save workbook in excel 

When you create a workbook it is important to save the workbook so that it can be viewed or reused later. The basic steps to save a workbook are listed below;
1. Click on the File Tab
2. Click on the  Save As or Save (Ctrl + S , F12) xlsx, pdf file
3. it displays 'Save As' Dialogue Box
4. Save the workbook to desired location with a desired name

Excel Arithmetic Operators


1. Addition


2. Subtraction 



3. Multiplication 



Division 



Sum Function / Formula