From the course: Monday Productivity Pointers
Join today to access over 22,500 courses taught by industry experts.
Use Excel tables for less manual work
From the course: Monday Productivity Pointers
Use Excel tables for less manual work
- [Jess Straton] My name is Jess Straton and welcome to this week's Monday Productivity Pointers. This week I'm going to talk about Excel tables. It may sound a little unnecessary and redundant to have a table in something that's almost a table to begin with. But there are benefits and time savers to using a table instead of a named range to easily group with and work with your data. Let's start with some data. This is a type that is perfect for an Excel table. It has column headings, each bit of data is on its own row, it looks like the type of data that you might want to filter one day, and it's nice and tidy. To create a table, place your cursor anywhere in the data, change to the insert ribbon tab and choose table. It's going to select everything that should be part of that table. You can change this range. For example you might have other data on your Excel sheet that you don't want to be part of your table and that's fine. I'm also going to leave this checked. My table has…
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.