How to use group and outline in Microsoft Excel. Group rows and columns and save views

This video explains how to use group and outline in Microsoft Excel. The tutorial explains how to group rows and columns and save custom views. The tutor covers examples of a simple group followed by a two-layer group. The final part of the video explains how to use the Auto Group feature. Grouping and Outlining is great way to manage large data sets. Thousands of rows or columns can be collapsed into one or two summary lines of information. When you Save a view, you will be able to quickly return to collapsed areas of the data set by selecting the saved view.

If you want to support me, check this out: patreon.com/itseasy

Playlists for this channel:

Access: youtube.com/watch?v=WyFj2eeMfSI&list=PLK99l…

Excel: youtube.com/watch?v=yKobsDbGbyM&list=PLK99l…

Word: youtube.com/watch?v=1yB2yP_5LQ0&list=PLK99l…

Visio: youtube.com/watch?v=ucHD0C4xeBY&list=PLK99l…

Project: youtube.com/watch?v=5Fmgei_PagI&list=PLK99l…

PowerPoint: youtube.com/watch?v=fOhiNLAzVAQ&list=PLK99l…

Publisher: youtube.com/watch?v=I1-DPJTSvg4&list=PLK99l…

OneNote: youtube.com/watch?v=JS5Y_BSEbgg&list=PLK99l…

Office 365: youtube.com/watch?v=fphQ0jmv0-8&list=PLK99l…

#itseasytraining

Classroom based courses can be arranged at itseasy.co.uk/

Courses are available through Microsoft Teams, Online and Face to face in the UK

Online courses at itseasytraining.teachable.com/

Udemy Courses udemy.com/user/stephen-saxton/

Training Guide Books

Excel for New Managers
amazon.co.uk/Excel-New-Managers-understanding-M…

Microsoft Project Overview amazon.co.uk/Microsoft-Project-Overview-need-ab…

Microsoft Visio Basic amazon.co.uk/Microsoft-Visio-Basics-Stephen-Sax…

Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv