Once the magic of Excel spreadsheets is uncovered, it's hard to imagine living without it. Just about any … More
eHow launches Android app: Get the best of eHow on the go.
Summary: In Microsoft Excel, a table can be made by highlighting data, going to 'insert,' and clicking on 'table.' Create an Excel table and use it for filtering with tips from a software developer in this free video on computer software solutions.
Dave Andrews is a software developer with a business and Web site selling programs and other computer services in Franklin, Tenn. Having worked in the IT industry for more than 8...read more
"Hi my name is Dave Andrews, today I'm going to show you how to create an Excel table. To being let's open up Excel. Click on the start button at the bottom, go to all programs, Microsoft office, let's select Excel. I'm going to type in a little bit of data here. Let's say our column is called sales, another one is called days absent, let's put in our sales employees. We've got three employees. Now to insert our Excel table let's highlight our data, go to insert, and just say table. Make sure that my table has headers has been checked, and say okay. Here's our Excel table. Excel tables allow you to do many cool things such as filtering. Let's say I only want to see William's data, to do so click on this little drop down, and uncheck everybody but William. You can only see William now in your data. It's that' easy to add a table in Excel. My name is Dave Andrews, and I've just showed you how to create a table in Excel."
eHow Article: How to Create an Excel Table