In this video, staff author Jess Stratton shows uses what Excel Tables are, and why you'd want to use one. She'll cover creation, sorting, filtering, and adding totals.
- [Narrator] An Excel table is a powerful feature…that takes a lot of manual work…out of manipulating your data.…Once your data is converted to an Excel table…it makes the jump to a pivot table easy.…It also let's you work with your data easily.…Let's see it in action.…I have here a nice spreadsheet full of data…with my mouse clicked anywhere inside the spreadsheet.…From the home ribbon tab I'll click format as table.…From here I'll choose a style.…I can either use the cells listed in the dialogue box…to make sure my table is fully selected or…I can see the green dashed lines.…
I'll scroll to make sure all of my data is selected.…And because I have a header row in row one…I'm going to leave My table has headers checked.…I'll click okay,…and my Excel table has been created.…Now let's talk about the benefits of doing it this way.…The first benefit is that…it's very easy to create total rows.…I'm going to scroll all the way down to the bottom.…Here I have a column full of stays,…and even though I'm scrolling through this Excel sheet…
- Identify which option allows you to download all of your Google files at once.
- Explain what happens when you double-click the border on the right side of a column.
- List the formula that will copy the contents of one cell into the current cell.
- Identify the location where an excel file needs to be stored to work on it simultaneously with another user.