إضافة صورة وتنسيق واجهة الجدول

Shereen Elmasry

يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)

Transcript

00:00This is how the video shows the general form of the table in which we will make salaries.

00:07Come on, in this video, we will start completing the general form of the table together.

00:12I want us to start doing some coordination.

00:16We start by adding Villjo or the first company logo to be present with this table.

00:22How do we do this? Come on, let's watch Lion Ball.

00:25First of all, I want to increase the space before my table.

00:29I will add rows above it or increase the space of the row above it so that it goes down a little

00:38Like this

00:40This is a good space to be able to move around.

00:43I will write the company name for him. For example, Al-Muttahidoon Company, any random name, and that’s it.

00:52Of course, you do not see anything, and neither do I. We will start by burying the line Control One from the keyboard or Control One.

01:01I will start by making the font size, for example, 36, like this:

01:10And I will start merging this cell from here. I will start making it a merger center.

01:16Ok, this is the company name. We want to add the company logo. To add a logo or an image.

01:23I will start by telling him from insert picture

01:26I chose the picture I wanted

01:29I will assume that this is a picture of the company logo. Insert

01:34Of course, it comes down to me in its normal size.

01:36I will start by dotting the i's and the t's

01:39Clouds because of its smaller size

01:41Put it in the size I want

01:43For example

01:44Okay, so far it's nice

01:47We want to make the whole space behind white.

01:50My utility is the only thing that has limits

01:53I will start to select all or select all with control A from the keyboard

01:58Like this

01:59I started to make it a control one so that it would bring me the settings menu.

02:05I will tell him border

02:06I want the entire border color to be white.

02:10First, I tell him that I have limits in everything.

02:13Cells and all directions

02:16Then I make my color white

02:18So the white color will not be seen.

02:20It will not be seen then

02:21It will not be seen then

02:23I will start teaching on all borders again

02:26Like this

02:29I will tell him okay

02:33Now all the borders are white.

02:37Okay, very nice. I will start now. After that, my borders are mine. I am the only one who will bloom. My schedule.

02:43I know about it

02:45From the beginning of deductions

02:48For example, this is the range I want: Control 1

02:54And I will tell him that my borders will be black.

02:58And he knows it again

03:03And also make the font size twenty

03:06We say this is twenty-two workers

03:08Okay, great

03:09You will stay with me like this

03:11Ok, I will start by creating my data and taking a specific color so that it is different for deductions from the extra

03:20And I will start by making the extra space

03:25So I started to teach her and tell him to make a Mirgand Center for me.

03:31It remained like this

03:33Raise this a little

03:37Here I want the deductions to start taking on a different color.

03:40I will start to stand on it or determine it

03:42Control 1 on the keyboard

03:44I will tell him the color of jasmine, which is the color of filling

03:46I will leave it and take this color, for example

03:49And he says to him okay

03:51We got the third degree

03:53For deductions cells

03:58Can I leave it?

04:00I took it a lighter color

04:02I take the color degrees and play with them.

04:04Control 1 again

04:06Take the second degree

04:08As for the cells

04:11Make it a shade of the same color

04:13Control 1 on the keyboard

04:15I will make it the faintest degree

04:17Almost in shape

04:32We almost fainted

04:34We numb the degree

04:37Control 1

04:39I can make it a little lighter in color.

04:45It is a waste of color that is more dark

04:51And here for the column I will make it color

04:55Control 1 on the keyboard

04:58I will make it green

05:01And the waste will be fainter than him

05:05Here for the limits in this part

05:09So I start to tell him control 1

05:11I will make it white

05:17He can

05:19I will do my best to succeed over the borders.

05:23Control 1

05:25I will make it white

05:29I can do it

05:33Al-Dahhan

05:47I will do it

05:50And here for him is the header part

05:56I will start by making it a different color

06:00ctrl+1 will give him the grade

06:06For example, this degree, and I tell him okay

06:09Here I will know that Ctrl+1 will give it the lightest shade

06:13And here for him this column I can start giving him the same green color

06:19Control 1 on the keyboard will turn green.

06:23And makes the header darker than it

06:26Okay

06:28So we have created the shape of the table and we will start by adding the logo to it. It could be a smaller logo that is a bit bigger.

06:38Very nice, I will start by putting my data here, the serial number, and let us know how to make a serial number

06:46Here is the name of the employee. Leave the name of the first employee, Hadeer, for whom we made the second sheet, so after that.

06:52In the next video, we will start calculating its deductions. Come on, try it.

06:56We we ...

Category

Transcript

Recommended