When data is in a table format, it is easier to manage and analyze. In this video, learn how to create Excel tables from cell ranges, apply table styles, and convert tables to a normal range of cells.
- [Instructor] Converting the data in a worksheet into a table makes it much easier to manage the data. After watching this video, you will know how to create an Excel table from a cell range. You'll also learn how to apply table styles, and how to convert tables to a cell range. Let's jump right in to our Create Tables workbook and look at the information on our Orders worksheet. and is very hard to manage without having a good structure for the data. Now by converting this into a table, we will have extra functions available to us such as sorting and filtering the information and easily applying a style to the information to make it easier to read. To create a table from a range of data, we first select a range. I'll select the column headings and use control+shift+down-arrow to select all of the records in this worksheet. We'll then go to Insert table. Now there's also a very good keyboard shortcut control+T which will quickly take you into this window where you can confirm that the cell range is correct and just watch the marquee around the selection and make sure that you've included your column headings. And we also want to make certain that my table has headers is checked. All of that looks good, let's click OK. And here's our new table. Very bright, kind of matches our logo which is good. But it might be easier to read if we were to tone it down just a little bit. On our Table Tools Design tab, we have some great table styles that we can apply and as long as you're clicked anywhere within the table, you'll have your Design tab available to you. Let's use the down arrow and go in and look at our other styles we can apply. As we mouse over these, you'll see the instant preview of what it would look like if you were to apply that specific formatting. I like this one because it has banded rows where the rows go from green to white to green and it makes it a little easier to read the data. I'll select that. So we've created our table and we've applied a table style, what if you want to convert this table back into a regular range of cells? We can do that on our Table Tools Design tab, Convert to Range, this will convert it back to a normal range of cells and will also remove the filter buttons on each column but will maintain the formatting that you currently see. Let's go ahead and click Convert to Range. You'll always receive a question confirming that you really do want to convert the table. We'll say yes. And that quickly, what was our table has now become just a normal range of cells within our workbook.
- Importing data
- Formatting worksheets and workbooks
- Exporting workbooks
- Pasting data
- Modifying columns, rows, and cells
- Formatting cells
- Conditional formatting
- Creating tables
- Filtering and sorting table data
- Using references
- Performing calculations with functions
- Formatting text with functions
- Creating charts
- Taking the practice exam