00:00When we work with Excel spreadsheets, we sometimes have a lot of data and many columns, which makes us unable to focus when we come to review them.
00:10Excel solves for us a very important thing called the detailed plan.
00:15This outline starts by grouping the columns and rows for a specific topic so that I can close and open them whenever I like.
00:23I want to do it from the tab called Data. I will tell it to collect.
00:27This makes my chart so I can open it with a plus sign and close it with a minus sign.
00:35This is for the columns and rows, the same thing. I will select it and tell it to group.
00:40So it starts to show me what is extra and what is missing, so I start to control it the way I want.
00:45If I wanted to remove it, I would go and make him disassemble it for me.
00:49For rows and columns it's the same.
00:53I will start to determine my range and then I will come back again and tell him to kill me
00:57The assembly is very easy and organizes our data very nicely.
01:03Born on the topic
Comments