00:00Peace be upon you and welcome back to the Excel program.
00:05In the previous video, we learned how to draw simple tables and set their settings as we like.
00:11Okay, the time will come when we start taking ready-made settings and applying them so that we do not get tired a lot while making our own tables.
00:19Let's begin
00:21For example, I will say that if I want this space to be my table and I want it to take the form of specific cells
00:28The words in it have a specific format.
00:31I start to define it and from here I have the patterns
00:34We create patterns for an area, a cell, or multiple cells, as we like.
00:39I see four patterns appearing with me, and if I press the watch, more patterns will appear for me.
00:45All styles mean here, for example, the style I am standing on.
00:49Why is the color of the arms so light and the words on them will be in black to this degree?
00:56Ok, I can make it orange, for example, and the words on it white.
01:00Can I make it, for example, a second shade of orange, or green, etc.?
01:04Let's try this degree, for example.
01:06I will write
01:08It will show me the shape of the writings that were in this text.
01:12Ok, come on, change it
01:14Choose something else for him, for example, the book in his hand
01:17We see that it has changed spontaneously.
01:19I don't need to stand on it and change it
01:21Very beautiful
01:23No, I won't say anything
01:25We will start by printing something else on it called the coordination table.
01:29This is a professional, religiously-based, and easy-to-use jadul.
01:33They have a variety of shapes and colors that I can choose from.
01:39For example, choose this shape for him.
01:41He tells me that it will be from cell B2 to cell G20.
01:47I will tell them OK
01:49If you want it to contain heads
01:51I will teach her here
01:53I will tell them OK
01:55The heads, as you can see, have marks on my hands.
01:57We'll take it later
01:59This is the filter mark.
02:01Okay, if it doesn't have heads.
02:03Okay, what do you mean, can we leave something else?
02:07Okay
02:08Ok, very nice
02:10If I wanted to take back my words
02:12Oil control
02:16Do you see how many times we have to return to the original paper?
02:18Let's make it, for example, another green shape.
02:20It will start to apply to me
02:26good
02:28This is what the ready-made table looks like.
02:30I can make a table for myself
02:32Or I can make a table for myself
02:34It is very easy to make my own layout.
02:36It is here in Excel.
02:38I start telling him to format it as a table.
02:40Here is a new jadole pattern.
02:42He tells me that the new table pattern
02:44How is this done?
02:46He tells me that the full table pattern
02:48I never find a way to coordinate it once.
02:50Or first column layout
02:52Second column layout and so on
02:54I tell him, for example, to plan the complete table.
02:56And coordination
02:58I start by finding the formats I want.
03:00For example, borders
03:02There are borders everywhere.
03:04Start pressing like this
03:06Borders on the vacant lot from all directions
03:08Well the borders are wide
03:10Her color
03:12It will be purple in color.
03:14Why do I know?
03:16Black will change
03:18Who was in purple
03:20Okay packing
03:22We will make it a filling, for example.
03:24In additional colors
03:26Choose it to fill
03:28For example, it is light in color.
03:30I tell him here, okay?
03:32And here again I agree
03:34And he says to him, "Okay."
03:36Now I have a new table format
03:38If you knew, for example, about the area of this
03:40I told him to format it as a table
03:42I found something above its name dedicated
03:44These are the arrangements I made.
03:46Yes, and I will tell him ok
03:48It will descend upon her
03:50So we are normal as if we are doing
03:52Our design and save it in it
03:54Table formats and answers
03:56When we carry
Comments