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…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Converting Google Sheets to Excel format
- Working anywhere with Excel Online
- Working with sheets
- Creating an Excel table
- Applying conditional formatting
- Working with formulas
- Working with charts and sparklines
- Sharing files and collaborating with others
- Reviewing and tracking changes