From the course: Excel for Sales Professionals
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Automatic rows and columns
From the course: Excel for Sales Professionals
Automatic rows and columns
- [Instructor] For this movie, we're going to work with the chapter three, auto rows and columns video. One of the huge advantages to Excel tables as mentioned earlier, is that they're dynamic. But they're not just dynamic in terms of importing data from external sources or CSV files. They're also dynamic in terms of you adding data or your sales reps adding data. So I'm going to go ctrl, arrow down, and I'm going to come down to row 51, and I'm going to start entering in order information. Notice as I start typing J, Excel auto-senses that I have the opportunity to enter Jan Kotas. So all I need to do is press Tab, and I'm going to start typing Company, and I want to do Company A for Jan, I'm going to do Grains, we'll just repeat this one. If you notice, the table has automatically expanded itself. It's not quite so evident here because it's a white row, but if I do it again, and we just repeat this order, you'll see its table's automatically expanded. So now any pivot tables, any…
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.