How to proper work on Excel complete guide

0
27

Create a new file

It is possible to create a new file (worksheet) on Excel by following the following steps:

  • Open an excel program.
  • Choose the option Blank workbook, or you can press Ctrl + N to open a new file in Excel.

 

Data entry on excel

It is possible to open an actual file in Excel 2013 format by following the following steps:

  • Select the cell to enter data on.
  • I am writing data into the cell, whether this data is numbers or text.
  • I was pressing one of the (Enter) or (Tab) keys to move to the next cell.

 

Using templates in Excel

Excel Templates version 2013 (in English: Templates) characterized by saving a lot of time and effort for its users, and these pre-designed tables are used in a custom format by following the following steps:

  • I am clicking File to switch to the Backstage view.
  • Choose the option “New“, so that many Excel templates will appear on the screen.
  • Choose the template to use, to be displayed on the screen.
  • I was clicking the “Create” button to use the template chosen.

 

Open an existing file in Excel.

It is possible to open an actual file in Excel 2013 format by following the following steps:

  • Change the view to (Backstage).
  • Choose the “Open” option.
  • Choose the computer option.
  • Click on the “Browse” option.
  • Determine the location of the excel file opened through the window on the screen.
  • I was clicking the “Open” button.

 

Add a worksheet in Excel.

A new worksheet can be added to Excel in the 2013 or later versions by clicking on the add symbol (+) that appears at the bottom of the Excel window that appears on the screen to create a new worksheet with the default name Sheet with a number next to it. This name can change by clicking with the right mouse button on this sheet, then choosing Rename, then typing the new name for the worksheet, then pressing the Enter key.

LEAVE A REPLY

Please enter your comment!
Please enter your name here