Excel basics guide for beginners: Learn Excel Online

Yodalearning>Tutorials>Excel basics guide for beginners: Learn Excel Online

In this blog, we will learn Excel basics guide for beginners, Learning Excel basics are just a start to what’s in store to solve a lot of our daily problem and save time. Microsoft Excel is very useful for a wide range of applications. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. But using it for the first time is a tedious and time-consuming task. A first time user will face a lot of difficulties understanding the various features present and how to start.

Fumbling with spreadsheet makes you feel uneasy in your workplace. If you are a first time excel user then below tips are going to help you a lot.

Now – let’s begin learning Microsoft Excel Online!

Below are the basic steps to know about excel like what is rows, columns, excel spreadsheet, excel workbook and how to use them are given below.

Excel Basics No 1. An excel Spreadsheet is a two-dimensional grid; Rows and Columns:

Spredsheet-Rows-columns-Excel-Basics-beginnerExcel Basics No 2. Moving from Cell to Cell:

The arrow keys can be used to move left, right, up, and down from the current cell. Press the Enter key to move to the cell immediately below the current cell, and press the Tab key to move one cell to the right.

Moving-from-cell-to-cell-Excel-Basics

Excel Basics No 3. There are a variety of ways to select cells in an Excel spreadsheet:

  1. To select one cell, click in the cell.
  2. To select one or more rows of cells, click on the row number(s).
  3. To select one or more columns of cells, click on the column letter(s).
  4. To select a group of contiguous cells, click in a corner cell and, with the left mouse button depressed, drag the cursor horizontally and/or vertically until all of the cells you want to be selected are outlined in black.
  5. To select multiple cells that are not contiguous, press and hold the Ctrl key while clicking in the desired cells.
  6. To select every cell in the worksheet, click in the upper right corner of the worksheet to the left of “A.”

Ways-to-Select-Cells-in-Excel-Basics

Excel Basics no 4. To enter data into a cell, just click in the cell and begin typing:

What you type also displays in the Formula Bar. When entering dates, Excel defaults to the current year if the year portion of the date is not entered.

You may edit cell contents from the Formula bar, or from directly inside the cell. To edit from the Formula Bar, select the cell and click on the Formula Bar. When done typing, either press the Enter key or click inside another cell. To edit directly inside a cell, either double click inside the cell or select the cell and press the F2 key.

Enter-Data-into-cell-Excel-Basics

Excel Basics no 5. There are multiple ways to fill data from one cell to adjacent cells:

Now you may copy cell to adjacent cell as mentioned below:

  1. Home ➪Editing➪Fill➪Down or press Ctrl+D copies cell to the extended cell bellows.
  2. Home ➪Editing➪Fill➪Up copies cell to the extended cell above.
  3. Home ➪Editing➪Fill➪Right or press Ctrl+R copies cell to the extended cell right.
  4. Home ➪Editing➪Fill➪Left or copies cell to the extended cell left.

Fill-data-from-one-cell-to-adjacent-cells

Learn Advanced Excel from corporate trainer of Excel training <- Click here

Excel Basics no 6. Move Data using Cut & Paste:

When you move data to another location, the data is removed from its original location and placed at the location you specify. To move the entire content of a cell using the Edit menu:

  1. Open the worksheet you want to modify.
  2. Select the cell you want to move.
  3. From the Edit menu choose Cut.
  4. Select the cell you want to move the data to. This cell is called the destination cell.
  5. From the Edit menu choose Paste.

Move-Data-using-cut-paste-excel-basicsExcel Basics no 7. Copy Data using Copy & Paste:

You may want to have the same information in several places within the worksheet. It is best to Copy and Paste the information instead of retyping it.

To copy the entire content of a cell using the Edit menu:

  1. Open the worksheet you want to modify.
  2. Select the cell you want to move.
  3. From the Edit menu choose Copy.
  4. Select the cell you want to copy the data to. This cell is called the destination cell.
  5. From the Edit menu choose Paste.
  6. Information gets copied original cell and is placed in the destination cell.

Copy-Data-using-Copy-Paste-Excel-Basics

Excel Basics no 8. Move Data using the Drag & Drop method:

Drag and Drop is another way to move data around in your worksheet. It is faster but requires a little practice.

  1. Select the cell that contains the data you want to move
  2. Point to the edge of the cell. The pointer will take the shape of a 4-headed arrow (Windows) or an arrow (Mac).
  3. Drag the cell where you want to move the data. As you drag, a cell outline will show where the data will go when you release the button.
  4. Release the mouse button when the pointer reaches the destination cell.
  5. The data is removed from its original location and placed in the destination cell.

Move-Data-using-Drag-Drop-in-excel-1

Excel Basics no 9. Use the Fill Handle to copy information:

When you need to copy data or formulas down a column or across a row, you can easily use a ‘Fill handle‘ to complete your task. A fill Down handle is located at the bottom right corner of a selected cell. It appears as a small box. When you select the fill down handle, your cursor changes to a plus sign.

  1. Select the cell that contains the data or formula you want to copy.
  2. Point to the bottom right edge of the cell. The pointer will change to a plus sign.
  3. Drag the fill down handle to the adjacent cells where you want the data or formulas to be copied.
  4. Release the mouse button.
  5. Data is filled in appropriate cells. If you had copied a formula, the results should be correct.

Use-fill-handle-to-copy-information

Excel Basics no 10. Adding and Deleting Rows and Columns:

  • To insert a new row in a spreadsheet, right-click on a row number, and click Insert. Excel always inserts the row ABOVE the row that was clicked on. To delete a row, right-click on the row number, and click Delete.
  • To insert a new column, right-click on a column letter and click Insert. Excel always inserts the column to the LEFT of the column that was clicked on. To delete a column, right-click on the column letter, and click Delete.

Watch and Learn about: Inserting Blank Rows In Between Data Rows In Excel

Adding-Deleting-Rows-Excel-Basics

Adding-Deleting-Columns-Excel-Basics

Free Course: Learn Excel Basics shortcuts and Formula with video based Online Excel Course

I hope, you must have learn excel basic guides and now you had became more than beginner. Congratulations !!

Leave a Reply