From the course: Excel 2016 for the Mac: Managing and Analyzing Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Use tables for formatting and data-handling features - Microsoft Excel for Mac Tutorial
From the course: Excel 2016 for the Mac: Managing and Analyzing Data
Use tables for formatting and data-handling features
- [Instructor] There's a feature in Excel called table, and on this worksheet called Table Conversion, we're looking at a list here similar to some of the ones we've seen in prior movies. Let's imagine we work with this list often. We add rows on the bottom at different times, we delete rows from within. Sometimes we expand it on the right. If you want to treat the data as a unit, and also achieve some additional formatting capabilities that make it easier to work with, consider converting a list into a table. Before doing that, make sure that the list you're about to convert has no empty rows or empty columns within it, and you might encounter this feature in at least two locations in the ribbon menu system. On the Home tab off to the right you'll see format as table. You could also see it on the Insert tab, or you could start it simply by pressing control T. I'll press control T right now. Where is the data for your table? Excel nearly always gets this correct, from A1 in the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.