Making a table in Excel is as easy as highlighting data, going to the "Insert" tab and clicking on "Table." Select specific fields when making a table in Microsoft Excel with IT help from a software developer in this free video on using computers.
Hi, my name is Dave Andrews. Today I'm going to show you how to make a table in Excel. Let's begin by opening up Excel. We'll just click on the start button. We'll go to All Programs. Find Microsoft Office. And let's just launch Excel. Now a table will grant you a whole lot more capabilities for working with your data in Excel than just a regular spreadsheet will. We'll type in some data here, let's just say we're managing our employees, and their number of sales. I'm going to type in some employee names. Now, let's create a table based upon this data that I've just entered To do so, highlight the data using your mouse, go to the insert tab at the top, just click on table. It's going to ask you what fields you want to make your table. I've already got those fields selected, so I'm going to say okay. Now, as you could see, our table - our appearance here has changed a little bit with the headers being highlighted, we've also got some different colors for the rows to kind of distinguish them. Now, what a table will allow you to do that you couldn't do before with your basic spreadsheet is you can click on this little drop down right here, and you can create filters. Let's say I only want to show Dave's records. I'm going to uncheck all of them and then just click on Dave. Now all that we're saying now is Dave, the other two employees have disappeared. They're still there, they're just filtered out. To remove our filter, let's click on that again, and just check clear filters. All my employees have showed up again. That's just one simply easy use that you could do with tables. My name is Dave Andrews and I've just showed you how to create a table in Excel.
- Things You Can Do With Microsoft Excel
- How to Use Excel to Calculate APR
- How to Make Windows Media Player Your Default Player
- How to Partition a Laptop Hard Drive
- How to Use External Hard Drives
- How to Wipe a Hard Drive
- How to Make Frequency Tables
- How to Reboot a Laptop
- How to Use PowerPoint
- How to Reboot a Computer Hard Drive
- How to Make a Table in Excel