Lesson 2: Data Entry and Editing with Excel.

Lesson 2: Data Entry and Editing with Excel.

Data entry, editing and formatting with Microsoft Excel.

This video is a part of free Excel Training Singapore, where I show you how to use Data entry, editing and formatting with Microsoft Excel from the basics and also cover a lot of advanced Features.

excel courses singapore

Microsoft Excel can hold three types of data broadly classified as text, numeric and a formula. Based on these three, there are various functions that can be performed. Various complex performances can be performed on these values namely data entry, modification of data in cell, replacing data in the cell and editing and deleting data. While these functions are to be performed manually, there are certain features of excel that come handy such as auto fill and number formatting that makes data storing and performing calculations on it very easy and reduces the chances of errors.

Benefits of Microsoft Excel.

  • Microsoft excel contains various smart features such as numeric conversion where excel automatically converts numeric data into the format of currency or date or fraction or percentage or any other category one feel like.
  • Microsoft excel allows to delete contents of a cell or the entire cell or only the border of a cell depending upon the choice of user that makes working on excel easier and more customizable.
  • Microsoft excel has the feature that allows to use formulas on numeric values that give accurate result on complex numeric values thereby reducing the human efforts.
  • Microsoft Excel recognizes the pattern of data being filled in the cell and has the option of auto fill in that cell that fills all the other selected cells in the same pattern.
  • Microsoft excel helps to align data in a cell. One can either center align the text or corner align the text to make the data look more presentable and professional.

How to enter a formula? 

Using formulas in excel reduces excess efforts of performing manual calculations and also reduces the chances of errors. To enter formulas, follow the following mentioned steps-

  • Fill in the necessary data in the cells. For example, write sales figures as the heading and fill in the present sales figures in the cell under it.
  • In the next cell, write next year sales target. Let’s say the target is to be increased by 10%.
  • Remember to always start the formula with an equal to sign. In the corresponding cell, insert the equal to symbol.
  • Select the previous value. Note in the address bar, the cell address changes and also inserts the cell reference of the previous value in the current cell.
  • Multiply it by 1.1 using the asterisk symbol and press enter. The cell will show increased sales target.

How to replace data in cell?

Replacing data in a cell simply means removing the old data and replacing it with the new data. Replacing of data can be done in many ways some of which are simple and some complex. To learn how to replace data in a cell follow the steps mentioned below –

  • Simply right click on the cell whose value has to be replaced. The old or previously stored value are shown in the formula box. Type the new value in the formula bar and press enter. The old value will be replaced by the new value.
  • The second method to replace the contents of a cell are by simply double clicking on the cell. After double clicking the cell enters into edit mode. Simply type your new value in the same cell and press enter. The old value will be replaced by new value.
  • The third way to replace the contents of a cell are to select a cell first. After selecting the cell press F2 from the keyboard. F2 takes you to the edit mode. Type the new value in the cell and press enter.

How to auto fill data? 

Microsoft excel is smart enough to detect if there’s any type of pattern going on in the data. Microsoft excel recognizes the pattern and auto fill the data.  To know how this works, read the steps mentioned below –

  • In any cell write the heading of the content that you are going to fill.

Let’s say months. You just need to write the first two months in the cells one below other.

  • Then select the second month cell and drag it down till the count of 12th cell and release it. All the months of the year will be get filled.
  • In the same manner you can fill sales target as well by entering data in a particular pattern in first two cells only.

Learn Microsoft Excel course in Singapore.

  • Once you know you are familiar with the basics of excel, the next stage is to learn how to enter and edit data in Excel. You can enter 3 types of data in Excel – text, numeric, and formulas.
  • This video will show you how to enter data in Excel and edit already added data (such as deleting data, modifying existing data and replacing data).
  • Apart from this, it also covers the auto-fill in Excel as well as number formatting.

Undoubtedly, Microsoft excel is of great importance. To get professional knowledge of it join a Skillsfuture Excel Courses in Singapore now!

This video is a part of Excel Training Singapore where I show you how to editing and formatting Data in Excel from the basics and also cover a lot of advanced topics.

phone icon+65 8421 2824
email iconinfo@exceltraining.com.sg
Send Enquiry
chat iconChat With Us
phone email enquiry whatsapp whatsapp