Ms. Excel Full Information

Friends, in this this today, we are going to tell you about what is Ms. Excel? And what you can do on your computer using it. Friends, in this article you will get complete information about what is Ms. Excel? So let's know what is Ms. Excel? and what can you do using it.

What is Ms. Excel?

Introduction to MS Excel

The full name of MS Excel is Microsoft Excel, it is an important part of MS Office It is a spreadsheet program, it is also called Work Book, it is also known as Excel. MS Excel is used to create any data it is a Spreadsheet Program developed by Microsoft Corporation Extension name of MS Excel is .xlsx

Friends, in MS Excel, many formulas, functions, and functions have been given for you to do large-scale mathematical or logical calculations, by using which you can do large-scale calculations very easily.

Such as:

You can make mark sheets, make calendars, calculate transactions of any company, etc. easily in MS Excel and in a few minutes. And in this, complex to complex calculations can be done using simple mathematical formulas and functions

How to open MS Excel

Friends, let us know how to open MS Excel

First Method

You will see a search box on the taskbar below in your computer or laptop, you have to type excel.exe and then you have to press the enter button from your keyboard, then MS Excel will open in front of you.

Second Method

You have to press window + R button from your keyboard, after that you have to type excel.exe and click on ok then MS Excel will open in front of you.

Third Method

You will have to click on the Start Button of your computer and then you will have to find Microsoft Excel from it you can also open MS Excel in this way

Friends, when you open MS Excel in your computer or laptop, you can see its interface like this below.

MS Excel window interface

Friends, you can see the interface of the MS Excel window. Now we will talk below, which part, what does it say and what does it mean, so let's know

1. Title Bar (Title Bar)

This is the uppermost part in MS Excel in which Microsoft Excel is written. It will be written until you create a file in it and save it.

2. Menu Bar

This section is located just below the title bar and contains different types of buttons that you can use to perform tasks as per their names.

3. Formatting Toolbar (Formatting Toolbar)

Right below the menu bar is the formatting tool bar, you can use it to do different types of formatting in the data typed in MS Excel.

4. Formula Bar (Formula Bar)

In MS Excel, there is a formula bar under all toolbars, whatever formula you type in MS Excel is shown in the formula bar.

5. Vertical Scroll Bar

Vertical scrollbars are on the right side of MS Excel, with the help of which you can see the top and bottom of the page of MS Excel.

6. Horizontal Scroll Bar (Horizontal Scroll Bar)

The horizontal scroll bar is at the bottom (bottom) side of MS Excel, with the help of which you can see what is on the right-left side of the page of MS Excel.

Office Button

File ( Ctrl + N ) Use this option to start a new page in MS Excel
Open ( Ctrl + O ) With the help of this option, you can open a file already created in MS Excel
Save ( Ctrl + S ) With the help of this option, you can save the file created in MS Excel to open it later
Save As ( F12 ) With the help of this option, you can save the previously saved file in MS Excel with another name.
Print ( Ctrl + P ) With the help of this option, you can print the file created in MS Excel
Prepare: In this option you get many options with the help of which you can do different things in MS Excel.
Send: With the help of this option, you can send any file or document you have created in MS Excel to email.
Publish: With the help of this option, you can send the file created in MS Excel to the blog management server etc

All Tab (Menu) of MS Excel

Home Tab

Clipboards

Paste ( Ctrl + V ) With the help of this option, you can paste the text or file or any object that has been copied or cut in MS Excel.
Cut ( Ctrl + X ) With the help of this option, you can move the text or file or picture or any object from one place to another place in MS Excel.
Copy ( Ctrl + C ) With the help of this option, you can copy (duplicate) any text, file, picture or any object from one place to another place in MS Excel.
Format Printer: With the help of this option, you can give the same formatting to the text or any file that you have given in MS Excel and you do not know, then you can give the same formatting to another text or file.

Font

Font: With the help of this option, you can change the font style of the written text
Font Size: With the help of this option, you can reduce or increase the size of the written text
Increase Font Size: With the help of this option, you can increase the size of the written text
Decrease Font Size: With the help of this option, you can reduce the size of the written text
Bold: With the help of this option, you can make the written text bold
Italic: With the help of this option, you can italicize the written text
Underline: With the help of this option you can underline the written text
Bottom Border: With the help of this option, you can set different types of borders in the written data
Fill Color: With the help of this option, you can add color to the background of the text written in MS Excel
Font Color: With the help of this option, you can add color to the written text

Alignment

Top Align: With the help of this option, you can keep the written text on top
Middle Align: With the help of this option, you can place the written text in the middle (Middle).
Bottom Align: With the help of this option, you can keep the written text below (Bottom).
Orientation: With the help of this option you can rotate the written text in any angle
Align Text Left: With the help of this option, you can go to the left side of the written text
Center: With the help of this option you can move to the center of the written text
Align Text Right: With the help of this option, you can go to the right side of the written text
Decrease Indent: With the help of this option, you can move the written text slowly to the left side
Increase Indent: With the help of this option, you can move the written text slowly to the right side
Wrap Text: With the help of this option, you can increase the column size of the written text
Marge & Center: With the help of this option, you can merge columns of written text or you can merge as many areas as you want to select.

Number

General: With the help of this option, you can give different formats in the number written

Styles

Conditional Formatting: With the help of this option, you can find out from the table or any data created in MS Excel, who has the highest number, who has the lowest number, and many options have been given. You can use these options in different ways. |

Format as Table: Different formats can be given in the table created using this option

Cell Style: With the help of this option, you can change the style of any cell you have created in MS Excel

Cells

Insert: With the help of this option you can insert Row, Column, Sheet etc. in MS Excel
Delete: With the help of this option, you can delete any Row, Column, Sheet etc. inserted in MS Excel.
Format: With the help of this option, you can do different formatting in whatever table you have created in MS Excel.

Editing

Auto Sum: With the help of this option, you can do the work you used to do with formulas in MS Excel without formulas.
Fill: With the help of this option, whatever data you have typed in MS Excel, if you want to type any number or text in it, then you can type it with the help of this option.
Clear: With the help of this option, you can remove (Clear) any data that has been formatted by Fill or Auto Sum after creating it in MS Excel.
Sort & Filter: With the help of this option, after creating the data in MS Excel, you can give it ascending (A to Z) and descending (Z to A) etc. formatting.
Find & Select: With the help of this option, you can find any word or text in the data typed in MS Excel and select it simultaneously.

Insert Tab

Table

Pivot Table: With the help of this option, you can see the table created in MS Excel by shortening it
Table: With the help of this option, you can create a table in MS Excel

Illustrations

Picture: With the help of this option you can take pictures or images in MS Excel
Clip Art: With the help of this option, you can write the name of the computer, laptop or someone else's photo in MS Excel.
Shapes: With the help of this option, you can create different types of shapes in MS Excel
Smart Art: With the help of this option, you can write any text in MS Excel in the smart art of this image
Chart: Column / Line / Pie / Bar / Area / Scatter / Other Chart With the help of this option you can create different charts in MS Excel

Text

Text Box: With the help of this option, you can write any text in the text box in MS Excel
Header & Footer: With the help of this option, you can write in header and footer in MS Excel page
Word Art: With the help of this option you can write MS Excel any text in word art text format
Signature Line: With the help of this option, after creating any data in MS Excel, if you want to set the signature in it, then you can use this option.
Object: With the help of this option, you can open any other software while working in MS Excel
Symbol: With the help of this option, you can get icons of different types of symbols in MS Excel

Page Layout Tab

Themes

Theme: With the help of this option, you can give different formatting to the table created in MS Excel
Color: With the help of this option, you can give different colors in the table created in MS Excel
Font: With the help of this option, you can give different font style in the table created in MS Excel
Effects: With the help of this option, you can give different effects to the table created in MS Excel

Page Setup

Margins: With the help of this option you can leave space around the page in MS Excel
Orientation: With the help of this option you can take page width and length in MS Excel
Size: With the help of this option, you can take different types of page sizes in MS Excel
Print Area: With the help of this option, you can select the data you want to print from whatever data you have created in MS Excel and print it.
Breaks: With the help of this option you can break the page in MS Excel
Background: With the help of this option, you can put any background behind the table created in MS Excel
Print Title: With the help of this option, you can print the title on every page while printing the table or any data created in MS Excel.

Scale to Fit

Width: While printing the data created in MS Excel, if the width is a little more than one page, then you can Width select Page – 1 in the S option.
Height: While printing the data created in MS Excel, if the length is a little more than one page, then you can select Page – 1 in the S option.
Scale: With the help of this option, you can do both the things that you would do in MS Excel in Width and Height.

Sheet Option

View: With the help of this option, you can remove and insert grid lines on the page in MS Excel
Print: With the help of this option you can show grid lines while printing data in MS Excel
View: With the help of this option you can show row and column numbers in MS Excel
Print: With the help of this option, you can show row and column numbers while printing data in MS Excel

Arrange

Bring to Font / Send to Back: These options are used to show or hide any of the two objects in MS Excel.
Selection Pane: With the help of this option, you will know how much data or picture you want
Align: With the help of this option, you can select two or more objects and move them here and there (to select, use the right click of the mouse with Shift).
Group: With the help of this option you can create a group of two or more objects
Rotate: With the help of this option you can rotate any object in any angle

Formula Tab

Function Library

Insert Function: With the help of this option, you can apply different formulas in MS Excel
Auto sum: In this option, you are given formulas related to addition, division, multiplication, averaging etc.
Recently Used: In this option, those formulas are given which you use more often
Financial: With this option, you will get different types of formulas whose names can do different things.
Logical: With the help of this option, you can use these formulas while creating mark sheets or attendance sheets etc. in MS Excel.
Text: With the help of this option you can apply formulas related to text in MS Excel
Date & Time: Using this option you can apply date and time related formulas
Lookup & Reference: By using this option you can easily find any name or data from any big list
Math & Trigonometry: With the help of this option, you can apply math related formulas in MS Excel

Defined Name

Define Name: With the help of this option, you can select any particular place in MS Excel and give it a name so that it can be quick to add or subtract from the list or do any calculation later.

Data Tab

Get External Data

From Access: With the help of this option you can import data from MS Access to MS Excel
From Web: With the help of this option, you can import any article on the Internet into MS Excel
From Text: With the help of this option, you can bring the file or data created in Notepad to Excel
From Other Sources: In this option you get many options with the help of which you can take data from different places.
Existing Connections: With the help of this option you can see in MS Excel from where you have taken the data in Excel.

Connections

Refresh All: With the help of this option, whatever you have changed in the notepad file, you can correct it in Excel
Connections: With the help of this option, you can see the data you have taken in MS Excel, where you have taken it from, and you can remove it, and you can also add it.
Properties: With the help of this option, you can see the details of the data taken in Excel, what are the names of the files, what format are they in and many more details.

Sort & Filter

Sort: With the help of this option, you can see whatever data or table you have created by sorting it
Filter: With the help of this option, you can filter any table or data and then sort it.
Clear: With the help of this option, you can clear whatever changes you have made by applying the filter
Advanced: With the help of this option, you can easily find out the name or anything else you want to know on Alphabet from whatever data you have created in Excel.

Data Tools

Text to Columns: Whatever text you have typed in Excel can be separated in a single click
Remove Duplicates: With the help of this option, MS Excel can remove any name that you have typed two or more times while creating a table or data.
Data Validations: With the help of this option in Excel, you can apply different conditions to the typed data
Consolidate: After creating a data or table in Excel, if you want to do its total, minimum, maximum, etc., then you can use this option.

What If Analysis

Goal Seek - With the help of this option, you can reduce or increase the number of subjects in total after creating data or mark sheet in Excel.
Data Table - With the help of this option, you can make a table as big as you want in Excel

Outline

Group: With the help of this option, you can group any data together in Excel
Ungroup: With the help of this option, you can remove any group you have created
Subtotal: With the help of this option you can total under each item in Excel

Review Tab

Proofing

Spelling: To correct misspellings of text typed in Excel
Research & Thesaurus: With the help of this option, you can see different words of any word in Excel
Translate: With the help of this option, you can change any word in any language in Excel

Comments

New comment: To comment on any topic
Delete: Use this option to delete comments
Previous: After giving a new comment, to see how many comments have been given before it
Next: To see how many comments have been given one by one
Show / Hide Comment: With the help of this option, Excel can hide and show whatever comments you have given
Show All Comments: Use this option to view all comments at once

Changes

Protect Sheet: With the help of this option, you can completely lock the sheet in Excel, after which no one can make any changes in it.

If you want to unlock it, then you can enter the password that you had previously entered

Protect Worksheet: With the help of this option, you can lock the sheet in Excel, after that you can't delete that sheet and you can't create a new sheet either.