Microsoft Excel, Learn Basic of MS Excel online in a simple way

  1. Microsoft Excel 

Microsoft Excel is an official program offered under MS Office. Under this, the work of creating a worksheet is done and data entry can be done on the created worksheet.

Microsoft Excel, Learn Basic of MS Excel online in a simple way
Microsoft Excel, Learn Basic of MS Excel online in a simple way

Microsoft Excel is a mathematical program. Under which the work is done in the office can be done easily. Initially, this program was run under Tools. In which limited facilities were given. But now runs in a Windows environment. Its worksheet is also called electronic split.

The extension name of the file to be created in MS Excel is .xls

Features of MS Excel:

  • MS Excel is a data entry program that can perform mathematical operations.
  • Its worksheet is also called an electronic split sheet.
  • Microsoft Excel worksheet has 1,048,576  rows and 16,384 columns.
  • Sheets in a workbook by default is 1 but can add more limited by available memory
  • Microsoft Excel have 16 million colors Colors in a workbook – 
  • Named views in a workbook – Limited by available memory
  • Microsoft Excel inbuilt 1,024 global Unique fonts available for use
  • In Microsoft Excel We can Zoom from a range- 10 percent to 400 percent
  • The file created in it is allowed to save the data of the Internet.
  • Through the option merge center given in it, In Microsoft Excel we can combine several cells to form a cell.
  • In Excel, you can lock the file of the worksheet created by giving a password.
  • By the formula bar given in it, we can apply the formula to the opened file.
Microsoft Excel, Learn Basic of MS Excel online in a simple way
Features of MS Excel

Microsoft Excel’s Components of the electronic spreadsheet window:

  • Office Button: The button in the left corner on the sheet of MS Excel is called Office Button. Where you get Important buttons like- New, Open, Save, Save as, Print, etc. options.
  • Quick Access Toolbar: This toolbar is to the right of the office button. It is shaped like a triangle, by clicking on it, 
  • Title bar: The bar on the right side of the Quick Access Toolbar is called the title bar. The title bar marks the name of the file being worked on. There are three buttons (Minimize, Restore, and Close) on its right corner.
  • Ribbon: The panel above the formula bar and below the title bar is called a ribbon. There are seven then (Home, Insert, Page Layout, Formals, Data, Review, and view,). 

Additional options can also be added to this toolbar. For this toolbar to be installed under the ribbon, click on the small triangle and select the option shown below the ribbon.

On clicking on these tabs, different groups appear, in which different buttons/options are given for different functions.

Some Options available under the ribbon:

  • Autosome: In Microsoft Excel by using this option we can get the sum of numbers written in many cells.
  • Short exceeding: This option is used to sort numbers and text written in several cells in the order of A to Z.
  • Short descending: This option is used to order numbers written in multiple cells and text in order from Z to A.
  • Chart Wizard: In Microsoft Excel, This option is used to display charts based on numbers written in multiple cells.
  • Merge Center: This option is used to combine several cells into one cell.
  • Currency: This option is used to place the currency symbol ($) before the written number.
  • Percentage Style: This option is used to display the number written in a cell as a percentage.
  • Comma Style: Used to display the middle (,) of a number written in any cell.
  • Increase Decimal: In Microsoft Excel, This option is used to increase the number of decimal points written in a cell to its right.
  • Decree decimal: This option is used to remove any number of decimal points.
  • Border: Through this option, many cells can be selected and given different types of borders.
  • Feel Color: This option is used to change the color of any cell.
  • Increase font size: This option is used to progressively increase the size of the selected text.
  • Decrease font size: This option is used to progressively reduce the size of the selected text.
  • Wrap text: In Microsoft Excel, This option is used to write text in two or more lines in the same cell.
  • Duplicates: This option is used to write text or numbers written in a single cell. Whether this text or number is written in any other cell or not. If the same number or text is written in a cell. Then indicates in the same automatic color.
  • Auto filter: This option is used to separate certain data from the created data.
  • Equation: This option is used to write a mathematical formula on a page or a mathematical question on a page.
  • Formula Bar: In Microsoft Excel, The formula bar is located below the ribbon and above the column box. In this, the applied formula is seen in the cell being worked. When we leave a cell that is being worked on and move to another cell. So the formula applied in that cell starts appearing.
  • Sheet tab: The horizontal scroll is the sheet to the left of the bar on which the total sheets of a workbook are marked. There are four boxes to the left of this, these worksheets are called scroll bar buttons. Using these, the worksheet can be moved back and forth.
  • Status bar: The position at the bottom of the worksheet is then called the status bar. Different types of options are displayed on the status bar. To add or remove new options, you can select the desired option by moving the mouse on the status bar and clicking the right button.

This option is highlighted when we are using incremental decimal in a cell.

Microsoft Excel, Learn Basic of MS Excel online in a simple way
MS Excel – File Menu

File Menu

  • New Excel Worksheet – In Microsoft Excel, By using this option, we open a new page on Excel.
  • New from other templates – When using this option, it opens a dial box. There are several types of templates (Mix) divided before the first. In this, we can select any template and install it on the page of M Excel.
  • Open – This option is used to open a file created in M Excel.
  • Close – This option is currently used to close the working sheet being worked on.
  • Close all – This option is used to close all the working sheets of the open one way.
  • Save – This option is used to save (cancel) the file is created in M Excel.
  • Save as – This option is used to create a file in M Excel or to send a file name of the file separately, to save in different format, etc.
  • Page setup – When using this option, it inserts a box. With the option given, we can search for the page of M Excel.
  • Print area – In Microsoft Excel, This option is used to classify the number of Dells in many of the castes in the area of the territory in the area. This option is used to remove (print) the print area. When we print to say it is done or the print is done.  When using this option, the menu appears. 

The following options are available,

  1. Print preview – This option is used to view the print preview before printing the file being created in M and Excel, on the page called Matter and how it will be printed.
  2. Print – This option is used to print files being created in M Excel.

  • Export to PDF – In Microsoft Excel, This option is used to change the excel file of the file to the format of the PDF. Once done, we do not make any kind of change in this file.
  • Sent Email – This option is used to send the file being created in M Excel to a different person’s email address.
  • Properties – In Microsoft Excel, This option is used to view the properties of the data given. You can get information about the size of the file, location, Creation date, modified date, etc.
  • Encryption – This option is used to lock the Excel E file through a window.
  • Exit – This option is used to come out of M-Excel software. Typically, M-Excel software is used to close.

Edit Menu 

  • Undo – This option is used to go back a step when a fault occurs while performing a task and to correct the error in the work.
  • Redo – This option is used to come to a step when a mistake occurs while performing the task and to correct the error in the work.
  • Copy – This option is used to copy selected text or objects.
  • Cut – This option is used to remove selected text or objects.
  • Paste – This option is used or copied to bring the matter back on screen.
  • Paste as a picture – In Microsoft Excel, This option is also used to retrieve the copied text.
  • Paste unformulated text (Y) – The application of this option is used to press the returned class.
  • Paste special – In Microsoft Excel, This option is used for copying or copying your format while pasting the Matter.
  • Feel ➤ When using this option, it opens a menu that contains the following options.
  1. Down – This option is used to map the content of the below cell into the selected Cell.
  2. Right – This option is used to bring the matter of that cell to the right side of the lane.
  3. Up – This option is used to bring the matter in the above the data cell.
  4. Left – This option is used to bring the matter of that cell to the left side of the lane.
  5. Across sheets- This option is highlighted when the dash button is pressed and displays more sheets, then the object appears on all the sheets.
  6. Series- When using this option, it opens a dial box. With the option given, we can also make a table in row and column, week, day, etc.
  • Erase ➤ When using this option, it opens a menu. By entering the option given, the name, content, etc. can be entered.
  1. All – Using this option, you can delete All selected object or text entered 
  2. Formats – This option is used to delete any of the new formats in the selected text. But the text will not delete.
  3. Contents – This option is used to suppress written text or its contents.
  4. Comments – This option is used to comment or comment on the selected object.

  • Delete – When using this option, it displays a box. In which the selected Cell, Rows, Column can be delete
  • Delete my sheets – This option is used to delete the entire sheet.
  • Find – This option is used to find some words or text on the sheet.
  • Replace – This option is used to replace the existing words with new words on an Excel sheet

View Menu

  • Normal – If this option is used to revert the Normal View if Page was in a page break preview, 
  • Page break preview – In Microsoft Excel, This option is used to break a page based on the text written on the class sheet and to see how much of the preview is printed on a page and how much of the matter is printed on the entire page.
  • Print layout – This option is used to insert a sheet of excel in the print layout view. In this way, we can see how much matter will be printed on this page. In this view, the row and column cant be inserted.
  • Reading layout –  When using this option, our pointer indicates row and column.
  • Task window – In Microsoft Excel, This option is used to show and hide task windows. This is a shortcut key (CTRL + F1).
  • Home page – This option is used to open any page on the current homepage.
  • Toolbars➤ This option is used to show and hide all the options under it. There are the Following Toolbars 
  1. Standard
  2. Formatting
  3. Drawing
  4. Symbol Toolbar
  5. 3-D Setting
  6. Task window
  7. Protection
  8. Control toolbar
  9. Form
  10. Impose Date
  11. Borders
  12. Formula bar
  13. Header and Footer
  14. Full Screen
  15. Zoom
Microsoft Excel, Learn Basic of MS Excel online in a simple way
View Menu

Insert Menu

  • Cell – By this option, we can Insert a New Cell at the desired place. 
  • Row – By using this option We can Insert New Rows in place of Selected Rows
  • Column – By using this option We can Insert New Column in place of Selected Column
  • Sheet – By using this option We can Insert New Sheet in place of an open working sheet
  • Chart – By using this option We can Create a Chart by selecting the desired Data in Excel.
  • Symbol – In Microsoft Excel, When using this option, it opens a menu. There are different types of Symbols. we can select and use any number of symbols on the sheet.
  • Page-Break – This option is used to break the page being worked on and to work on the next page.
  • Function – When using this option, it opens a menu. We can use multi-functions ( like sum, maximum, minimum. average, square, etc.) for the available options of function.
  • Name – This option is used to designate a name in Open Excel in M & Excel.
  • Comment – In Microsoft Excel, By using this option we can Insert the comment on the desired Content on the cell, Short cut Key for Comment is “Shift+F2”
  • Picture – When using this option, it opens a menu. We can insert a design or picture that is saved in the drive.
  • Equation – In Microsoft Excel, When using this option, a box open. where we can use Mathematical equations on the page.
  • Object – When using this option, a box open, One can go to the software and create any design and insert it to M Excel.
  • File Object – Through this option, any saved file can be inserted into the excel file in M- Excel.
  • Hyperlink – When this option is used, a box opens in which the given option is used to create a link to another file
Microsoft Excel, Learn Basic of MS Excel online in a simple way
Insert Menu

Format menu

  • Cell-  When using this option, a box open. Where we can do setting for Alignment, Font, Border, etc. 
  • Row➤ When using this option, it opens a menu that contains the following options.
  1. Row height– When using this option, it opens a box, where we can increase or reduce the size of the row’s height.
  2. Autofit row height – This is used to set the height of the rows to AutoFit or the previous state.
  3. Hide – This option is used to hide the selected cell or rows
  4. Un-hide – This option is used to shows the already hided Cells or rows
  • Column
  1. Column width– When using this option, it opens a box, where we can increase or reduce the size of the column width.
  2. Autofit column width – This is used to set the width of the column to AutoFit or the previous state.
  3. Hide – This option is used to hide the selected cell or column
  4. Un-hide – This option is used to shows the already hided Cells or column
  5. Standard width – This option is used to increase the width of all columns together.
  • Sheet➤ When using this option, it opens a menu that is like this.
  1. Rename – This option is used to change the name of the sheet.
  2. Hide – This option is used to hide the sheet
  3. Un-hide – This option is used to shows the already sheet.
  4. Tab color – This option is used to change the Tab Color of the sheet.

  • Condition of formatting- In Microsoft Excel, When using this option, it opens a box, where we can set the desired format of the content and cells by different format.
  • Style-  When using this option, it opens a box, where we can see which style or formula is used in the cell. Example – Style name, Fonts, Fonts Size, Alignment, etc.
  • Table Style – This option is used to change the style of the selected table. Using this, a box of the table appears on the right side of the working sheet. Wherever you select the table, you can use it by already selected area of the content.

Tools Menu (ALT+T)

  • Check spelling  (F7) –  This option is used to check the spelling of the words written on the sheet.
  • Calculate sheet (Shift+F9)- This option is used to calculate all the sheets opened in Excel.
  • Recalculate worksheet (F9) – This option is used to recalculate the working book.
  • Convert Text to Number – This option is used to convert the number as text.
  • 5Convert Text to hyperlink – This option is used to convert the selected text to a hyperlink 
  • Share workbook – In Microsoft Excel, This option is used to share data of one Computer to another Computer. If we share by using this – our file is converted into a shared File, In this situation, we can’t Lock the workbook.
  • Track change – If we change the data by using this option then It is highlighted in blue color. Its shows that we have changed which cell into the data entered, The track change option is highlighted only when we save our working sheet file as a shared workbook
  • Protect➤ In Microsoft Excel, When using this option, It opens a menu. Where we can do the setting for the sheets by the given options.
  1. Protect Sheet– On using this option, It opens a box where we can lock our sheet by Password. When done, you are not able to make any type of change in the sheet.
  2. Protect workbook- This option is used to lock your working file.
  3. Protect and share workbook – By using this option, We can protect or Share the workbook by ON or Off of the setting available. 

  • Goal seeks- This option is used to find the value of the input value respectively in the sheet being used. After receiving the sum, you can change any cell value that results change the Total value.
  • Formula Auditing- In Microsoft Excel, This option is used to do settings related to Formula, and Also we can find the steps for Formula.
  • Solver- When We are using the internet, By using this option we can insert another related formula, structure, or Syntax that being used before. 
  • Macro- This option is used to record the work being done in the working sheet. If we want to see the work done in the record, then we use the run macro given in the record.
  • Add-ins – This option is used to Insert a previous file saved in a disk or drive on an open working sheet at present time.
  • Backup management – This option is used to make a backup file being created.
  • Option – When using this option, it opens a menu where we can do the related setting of Excel.

For example: to turn on / off the Gridline, change the color of the Gridline, lock the scroll bar, change the direction of the Inter Key, etc.

Data Menu (ALT+D)

  • Sort- This option is used to arrange the selected data as A to Z or Z to A.
  • Filter➤ When using this option, it opens a menu. With the option given, we can Filter any data in the area of the selected cell. Also, the above data can be extracted.

  1. Auto filter- 
  2. Reply
  3. Show all
  4. Advanced filter

  • Form – When using this option, a box opens, where made the Records as per selected data and field.
  • Subtotal – This option is used to add the value of the entered data.
  • Validation – This option is used to define so that the entry can be from a specified value to a specified value. 
  • Text to column – This option is used to put text or numbers written in a single column into different new columns.
  • Consolidate – This option is used to retrieve data of a specified range in the data entered.

On request, this data gets saved in our browser. When needed, we can install this data on the page.

  • Group and outline➤ When using this option, it opens a menu. The selected data can be grouped by a given option in a specified row and column. By expanding it, the groups show and hide the data given and also revise the outline.

  1. Hide details
  2. Show details
  3. Group
  4. Ungroup
  5. Clear outline
  6. Setting                               

  • Pivot table – This option is used to open the entered data in a separate format. And by converting the entered data into the working short data. ( Report Summary)
  • Import external data➤ This option is used to insert any previous data kept into the Open Excel sheet at present time.

  1. Import data

  • Duplicates➤ This option is used to highlight the words written several times in the given range.

  1. Highlight duplicates
  2. Reject duplicates entry
  3. Remove duplicates
Microsoft Excel, Learn Basic of MS Excel online in a simple way
Data Menu

Window Menu (ALT+W)

  • New window – This option is used to build new windows. It used to build a New Windows as the current Open window.
  • Close window – This option is used to Close the Current Open Window
  • Close Other windows – This option is used to close all other windows except the currently active working window
  • Horizontal- This option is used to arrange an open window as Horizontal.
  • Vertical – This option is used to arrange an open window as Vertical.
  • Cascade – This option is used to open and view all the windows in a staircase view
  • Sprite– This option is used to divide the working sheet into four parts
  • Freeze – This option is also used to stick the given row and column. By using this option, we can Freeze or Stick the Left or Up area of the specified selected cell.

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

%d bloggers like this: