Practice Creating Tables in Excel for Beginners

Easy guide on how to create tables in Excel. By using a table in Excel, You gain ease in processing numbers, Fill in data automatically with formulas so that your reports are faster and more accurate.

Working with Excel has its own challenges, The level of difficulty of working in Excel depends on the complexity of the data to be processed. If you want to create a simple report table with basic mathematical operation formulas, but don't know how to create a table in Excel, You need to follow this guide.

This guide will show you the basics of Excel as well as how to create tables in Excel. Tables in Excel can be created in several ways, tables in Excel can be designed automatically using table style templates or manually such as create a table in Word.

Introduction to Excel

In the Excel Workbook there are several worksheets called Sheet, innately present Sheet1, Sheet2 And Sheet3. You can add or delete sheet, You can also change the name sheet the.

Each sheet consists of many columns and rows, The meeting between columns and rows is called a cell. On cells This is where you can input and process data.

Each column in Excel is represented by the letter A, B, C and so on, and each line is represented by a number 1, 2,3 and so on.

Cell identity is determined by the column name and row number that intersect each other. Example column A row 2, Ist Baris 4, and so on. On Excel, To simplify it, just write the column names and row numbers. Sample, column A row to 2 written A2, column B row to 3 written B3, and so on.

Basic Excel Tips:

• To refer to a cell, write the column name and row number. Sample: B3.
• To highlight multiple cells across multiple columns and rows, written with a start cell and end cell, and separated by a colon. Sample: B3:C9
• To enter data into cells, click on the cell, then type the data. To change cell data, double click on the cell.
• Apart from entering directly into the cell, data can also be entered via formula bar (formula bar).
• To move between cells, press the button Tab or Enter
• Writing formulas or functions must begin with the sign " = “

Create Column Titles

Tables generally consist of one or more columns, Each column consists of a column title and column contents consisting of one or more cells.

To enter data as column headings, do the following:

• click on the cell A1 then type the column title, sample: NO,
• to move to the next column cell, press the button TAB on the keyboard.
• repeat the two steps above to create other column headings.

Once you have finished creating column headings, You can fill in data for each column such as Name, NIK and so on. To move to the cell below it, press ENTER.

Adjusting Table Column Width and Row Height

You can adjust the column width and row height of the table as needed. To adjust the column width or table row height, do the following:

• Point the pointer at one of the dividers so that the pointer changes shape to a double arrow, Then
• click and drag right or left for column width,
• click and drag up or down for row height.

You can also adjust the column width or table row height automatically by double clicking on the column divider or row divider.

Creating Tables

Unlike table in Word, A table in Excel is not just a combination of several cells with column boundaries, A table in Excel is a number of cells that have been declared as a table or named as a table.

Creating tables in Excel can be done in several ways, including using Insert Table And Format as Table. By using these two tools, Excel's algorithm will know that you have created a table and will activate the tab Table Tools – Design. Besides that, Excel tables will increase effectiveness in applying formulas to cells in tables.

The table design tool provides a variety of table styles that you can use to quickly create tables in Excel. In addition to using the style provided, You can also design the table in your own style.

Use Insert Table

By using the menu Insert Table, The table will be designed according to the selected style. The selected table style affects the color of each cell in the column and row headers of the table.

How to use Insert Table is to highlight all the cells that you want to make into a table, by clicking on the first column title then dragging it to the last row in the last column. Once the cell is highlighted, do the following:

1. Select the tab Insert, then select Table.
2. In the dialog box Create Table, click My table has headers, then click OK
3. After the table is formed a tab will appear Design. On tabs Design part Table Styles, choose the table design you like.

Use Format as Table

Use Format as Table the same as using Insert Table, This tool will design the table according to the selected table style.

How to use Format as Table is to highlight all the cells you want to make into a table by clicking on the first column title then dragging to the last row in the last column. Once the cell is highlighted, do the following:

1. On tabs Home, click Format asTable.
2. In the dialog box Create Table, click My table has headers, then click OK
3. After the table is formed, on tabs Design, in part Table Styles, choose the table design you like.

Designing Tables

With or without using the menu Insert Table or Format as Table, You can still design the table according to your needs. By designing custom tables, You can make adjustments to your specific wants or needs for the table you create. You can add or remove border lines and change the color of each cell.

Creating Border Lines on Tables

To create a dividing line for each column in Excel, Highlight all the cells you want to add border lines to then do the following:

1. On tabs Home, in part Font, choose More Border.
2. In the dialog box Format Cells, in the Line Select the desired border style and color.
3. In the Border, Click on each side of the cells you want to add a border to
4. Click OK to apply.

Insert Columns or Rows in Excel

Inserting a column or row in Excel is as easy as inserting a column or row in a table in Word. The method, Right click on the column or row you want to insert, then click Insert.

Cover

The lesson about creating tables in Excel ends here first, will be updated at the next opportunity. Hopefully this quick guide can help you create reports with Excel.

Don't forget to save Workbook You, Fastest way to save (save) Workbook is with shortcut keys Ctrl + S. Press the button Ctrl and buttons s simultaneously.

After you create a table in Excel, fill in the necessary data and use basic addition formula, subtraction and multiplication, you can use this table for create a Mail Merge in Word with Excel data.

After learning these Excel basics, You can improve your skills by mastering 41 Important Excel Formula Functions in Work.

Hope it is useful