From the course: Excel for Sales Professionals
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
What is a table?
- [Instructor] Throughout this course in templates and importing data, we've been working with Excel tables. But what exactly are tables? Tables are dynamic data containers that automatically adjust as you add or remove data. This becomes incredibly important when you think about creating reports that can automatically adjust to the amount of data that you have at any given period. With tables, there's no need to manually adjust anything. A table doesn't care if it's 500 rows one week or a 1,000 the next week. So you don't need to worry about that dynamic. You let the Excel table handle it for you. And it does it all internally so you don't to even bother looking to see how big or how small it is. Tables take care of all that for you. Tables can be quickly formatted with their own set of styles including alternate row shading called banding like you see here. There's some other table elements that we'll show you in just a second. First, I'm gonna click on the raw data sheet tab that…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.