Microsoft Excel

What is Microsoft Excel?

माइक्रोसॉफ्ट एक्सेल क्या है? माइक्रोसॉफ्ट एक्सेल किसे कहते हैं?

Microsoft Excel software developed by Microsoft that makes use of spreadsheets to arrange data and numbers using formulas and functions.

Microsoft Excel is a program or spreadsheet that offers strong tools and features to analyse, share and manage your data with the least amount of work.  A huge sheet of information organized in a matrix of columns and rows is referred to as a spreadsheet.

 

एमएस एक्सेल माइक्रोसॉफ्ट द्वारा विकसित एक सॉफ्टवेयर है जो सूत्रों और फ़ंक्शंस का उपयोग करके डेटा और संख्याओं को व्यवस्थित करने के लिए स्प्रेडशीट का उपयोग करता है।

एमएस एक्सेल एक प्रोग्राम या स्प्रेडशीट है जो कम से कम काम के साथ आपके डेटा का विश्लेषण, साझा और प्रबंधित करने के लिए मजबूत टूल और सुविधाएं प्रदान करता है। स्तंभों और पंक्तियों के मैट्रिक्स में व्यवस्थित जानकारी की एक विशाल शीट को स्प्रेडशीट कहा जाता है।

Software for entering, computing, analysing, and manipulating sets of numbers is known as spreadsheet software.

Each time you alter a value or number in a computer spreadsheet, all the calculations are automatically recalculated.

संख्याओं के सेट को दर्ज करने, कंप्यूटिंग करने, विश्लेषण करने और हेरफेर करने के लिए सॉफ़्टवेयर को स्प्रेडशीट सॉफ़्टवेयर के रूप में जाना जाता है।

हर बार जब आप कंप्यूटर स्प्रेडशीट में कोई मान या संख्या बदलते हैं, तो सभी गणनाएँ स्वचालित रूप से पुनर्गणना हो जाती हैं।

 

 

Areas of uses MS Excel:    एमएस एक्सेल के उपयोग के क्षेत्र:

Students can learn a range of important skills, such as data visualization, data organizing, and information restructuring, using Excel. Students can learn how to filter data, make rapid computations, evaluate data, and tabulate data using this method.

Additionally, it is used in financial and accounting applications as well as budgeting displays, check book registers, enrolment records, inventories, coded surveys, field and laboratory research data, and inventories.

एक्सेल का उपयोग करके छात्र कई महत्वपूर्ण कौशल सीख सकते हैं, जैसे डेटा विज़ुअलाइज़ेशन, डेटा आयोजन और सूचना पुनर्गठन। छात्र इस पद्धति का उपयोग करके डेटा को फ़िल्टर करना, तीव्र गणना करना, डेटा का मूल्यांकन करना और डेटा को सारणीबद्ध करना सीख सकते हैं।

इसके अतिरिक्त, इसका उपयोग वित्तीय और लेखांकन अनुप्रयोगों के साथ-साथ बजट प्रदर्शन, चेकबुक रजिस्टर, नामांकन रिकॉर्ड, सूची, कोडित सर्वेक्षण, क्षेत्र और प्रयोगशाला अनुसंधान डेटा और सूची में भी किया जाता है।

 

Working with MS Excel

THE EXTENSION OF ANY MS EXCEL FILE IS “.xls or .xlsx.”

How to open MS Excel program :

Start >> All Programs >> Microsoft Office >> Microsoft Excel

 

Introduction to MS Excel’s some useful terms :

Sheet or sheet tab :

A sheet consists of cells in which you can enter and calculate data. The Sheet tab, which is used to show the worksheet that the user is presently editing. Sheet tabs holds list of worksheets by default it provides three worksheets named Sheet1, Sheet2, Sheet3 respectively. For insert a new worksheet in a MS Excel file or workbook, click on insert worksheet tab.

Row:

A row is a series of data laid out horizontally in a table or spreadsheet. Rows go across from left to right.

Column:

A column is a vertical sequence of cells in a chart, table, or spreadsheet. Columns, on the other hand, are oriented from top to bottom.

Cell:

A row and a column come together to form a cell. In other terms, it is the intersection of a row and a column. A, B, and C are used to denote columns, while 1, 2, and 3 are used to denote rows.

Formula Bar:

The spreadsheet's toolbar that allows you to enter or examine data in a cell is called the formula bar. It allows you to build and view formulas and displays the contents of the currently selected cell.

Cell Address or cell reference:

A worksheet cell is identified by a combination of a column letter and a row number known as a cell reference or cell address. As an illustration, the references A1, B2, and so on all refer to the cells that are located at the intersection of column A and row 1.

The majority of formulas you write make use of specific cells or ranges. Instead of being limited to fixed values, these references let your calculations interact dynamically with the data present in specific cells or ranges.

When you use a cell (or range) references in a formula, you can use three types of references:

i) Relative cell references: It refers to the cell based on its distance from the cell containing the formula. Because the references are actually offsets from the current row and column, they can change when you duplicate or copy the formula to another cell.

ii) Absolute cell references: It refers to the cell based on its distance from the cell containing the formula. Because the reference belongs to a specific cell address, the row and column references do not change when the formula is copied.

iii) Mixed cell references: Any of the row or column references is relative, and the other is absolute.

Ranges:

A group of cells is called a range cells. The cells in a range may all be in one column, or one row, or any combination of columns and rows, as long as the range forms a rectangle.

Uses of different types of MS Excel Tabs or functions

Some Tabs or function are same in MS Word and MS Excel.

Some same feature Tabs are: FIle Tab, Home Tab, Insert Tab, Page Layout Tab, in these tabs some features are smiliar.

Working in MS Excel :

Simple data entry in MS Excel worksheet:

Formatting in MS Excel:

Some MS Excel useful feature:

AutoSum:

When utilizing the Auto sum feature, Excel automatically enters a formula to sum the values. The AutoSum button is available in the 'Home' tab on the excel ribbon.

Sort and Filter

Sort:

You can use the sorting tool to sort the data by date, number, alphabetical order, and other criteria.

Filter:

A filter outputs an array of data that matches the applied filter after taking data from a set of cells.

Chart:

Charts are used in Microsoft Excel to provide a graphical representation of any set of data. A chart is a picture of data that uses symbols to represent the data, such as bars in a bar chart or lines in a line chart.

Some examples of chart feature:

Note: Formulas always start with the equal symbol (=) so that Excel can tell them apart from text.

Using operators in formulas:

You can utilize a wide range of operators in Excel formulas. The type of mathematical operation you want the formula to carry out is represented by an operator, which is a symbol.

Insert Function:

Use the Insert Function dialog box to help you insert the correct formula and arguments for your needs.