From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Work with tables
From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)
Work with tables
- [Instructor] A lot of the data that we work with in Excel lives in tables like this table. In this case, we have a sales report and when we look at a table like this, what distinguishes it from a budget for example, is that this data is organized with columns and each row is an individual record that has information about each of those columns. So if I select, for example, the Solar Phone Charger row, this is the information about the product, the size, the cost per unit, and so on. Now, by having this data in a table, I can sort and filter it and I can format it very easily. So if I wanted to change the format, I'd just choose any cell in my table, click Format as Table. And if I wanted to have, for example, yellow or orange with gray rows, or if I don't want the alternating rows anymore, I choose the color I do want, perhaps the color I had originally. And then I go to the Table Design tab and turn off Banded Rows.…
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.