From the course: Excel Online Tips and Tricks (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Simplify views with Groupings
From the course: Excel Online Tips and Tricks (Microsoft 365)
Simplify views with Groupings
- [Instructor] Excel for the web has a heap of cool features that makes it really easy to manage your data. One of these features is called groupings. And if you'd like to follow along with me, then make sure you have the Excel group file open. At the moment, this list of employee data can be seen on one screen, which is really cool. But over time, if we keep adding new fields of data, then we may wish to condense what appears on the screen, just to make it easier to navigate. Many folks I know will simply go ahead and highlight the columns that they wish to not see, and then hide them. Now, this is okay, but sometimes you only want to hide them temporarily, and then see them again. So, an alternative to hiding the columns, is to group them. I'll show you what I mean, just make sure that the columns you wish to keep together have been selected. I'm going to make sure that columns E through to I are selected, and then go ahead…
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.