BASICS OF MS EXCEL

 EXCEL:

Excel is a program consist of spreadsheets developed by Microsoft, in order to create workbooks as a result of any research, operations, calculations, reports, data and analytics.  It is a collaboration of rows (horizontally) and columns (vertically) which is individually stated as cells. Charts, graphs, tables can be easily generated through this groups of cells. It has been developed for windows, androids, macOS, and iOS. Moreover, many businesspeople, officials, institutes undertaking technical projects has been benefited through this Microsoft excel because of the presence of clear vision of understanding and analysing.

New Workbook:

We can create a new workbook by clicking blank workbook in the home page.

No Of Sheets:

Sheets in workbook are nothing but a resemblance of pages in the notebook. The default number of sheets that appear while opening a new workbook is Sheet1. There are no limitations for the number of sheets, and hence it is only depends upon the available memory (RAM) of the computer. We can create a greater number of sheets under many different headings through the following steps,

• Right click (+) for creating a new sheet,
• Left click the (Sheet) bar for more options like rename, delete, tab colour, protection etc.

Cells:

Cells are referred as a rectangular box intersecting the rows and columns of the workbook. It is the place where we must enter our terms either following through the rows or columns which ever needed.

Rows and Columns:

In the workbook, following horizontal cells are known as Rows and following vertical cells are known as Columns. Rows are named with numerical terms and the Columns are stated through alphabetical terms.

For example, Row 1, 2, 3…. and Column A, B, C….  If it is Cell A1, then it is the cell placed in the 1^st row of column A.

Maximum limit for the total number of rows and columns in the workbook are 1,048,576 and 16,384 respectively.

Column 

Row

Entering the Data:

The major purpose of excel documentation is to organize and maintain the reports and analytics for clear understanding and also for future reference. Steps we have to follow to enter our data in the new workbook are as follows,

• Click an empty Cell,
• Enter any data or report in the cell either as text or number,
• And click Enter in order to move the cursor to the next cell to follow the same.

Creating Table:

Tables plays a major role in making the report more effective and helps to sort out details as quick as possible. To create table in workbook,

• Click and drag the data from which to which considering should be in the table,

• Click the Quick Analysis option appearing in the bottom of the selected cells,

• Click the Table button, 

• Click the Down arrow appearing beside the table header,

• Clear Select all to filter the data and select the data you want to show in the table. And save the changes you have made by selecting OK.

Saving the data:

There are two ways to save the data we have entered,

1. Click Save on the Quick Access, left corner of the top of the screen,
2. Next way,

• Click File on the Quick Access,

• Click Save as, 

• Select where to save your workbook,

• Enter a name for your file,
• Click Save.