Converting a list into a table (from buttons on the Home or Insert tabs) ensures that the data is treated as an entity, provides handy formatting tools and simplifies sorting, filtering, and formula creation. Data added in a row adjacent to the bottom or to the right side automatically becomes part of the table.
- [Voiceover] On this Worksheet called Table Conversion,…we've got a list of data.…And clicking on a cell, double-clicking its bottom edge,…we can see it goes down to row 762.…If you work with lists,…particularly lists that grow and shrink,…you can treat the data as a unit more comprehensively…if you convert the data to a table.…Now converting data to a table…means that all of this data here…is going to have a certain look,…it will automatically allow us to add to the table,…either at the bottom or on the right hand side,…and always be treating the data as a unit, as an entity.…
Now, if you have worked with…some of the data management features in Excel,…there's always that concern,…"Is all my data being treated together?"…In other words, do I have to scroll up and down…and check for empty rows and that sort of thing?…Or did I add that data at the bottom,…is it going to be sorted if I sort all the data?…If you convert data to a table,…you don't worry about those issues nearly as often.…So, before converting data to a table,…
- Prepping data for analysis
- Multiple-key sorting
- Sorting by rows or by columns
- Setting single- and multi-level subtotals
- Using text, numeric, and date filters
- Creating custom filters
- Filtering tables using slicers
- Using Advanced Filter
- Eliminating duplicate data
- Using SUMIF and COUNTIF functions for quick data analysis
- Working with the database functions such as DSUM and DMAX
Skill Level Intermediate
Working with Real-Time Data in Excelwith Chris Dutton1h 18m Intermediate
Learning Microsoft Power BI Desktop (2016)with Gini von Courter2h 52m Intermediate
1. Data Preparation
2. Sorting Data
3. Creating Automatic Subtotals in Sorted Lists
4. Filtering Data
5. Advanced Filter
6. Eliminating Duplicate Data
7. Data Analysis Tools
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.