الأنماط والجداول الجاهزة  في الاكسيل - video Dailymotion

Shereen Elmasry

يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.

Transcript

00:00Peace be upon you and welcome back to the Excel program

00:05In the video, we learned how to draw simple tables and put the numbers as we like.

00:11Okay, let's start by taking ready-made settings and applying them so that we don't get tired a lot while making the tables.

00:19Let's begin

00:21If I want the space to be my tables and we take the form of a specific cell and we format it in a specific way

00:31I reply to it and it comes from here to me patterns

00:35Patterns by area, cell, or multiple cells

00:40There are four patterns on my back and pressing the watch removes more patterns.

00:45All the pattern I stand on is light blue and the space words will be black in degree

00:56Ok, I can make it orange, for example, and the space text will be white.

01:00Can I make it, for example, a second shade of orange, or green, or something like that?

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 the text.

01:12Ok, come on, change it

01:14For example, he thought of something else, writing something that had a bottle in it.

01:17And you can see that it changed automatically

01:19I don't need to stand on it and change it

01:21Very beautiful

01:22No, don't say that

01:24We will start printing something else on it called the table layout.

01:29This is a table format that will make you forget the table professionally.

01:34They have a variety of shapes and colors.

01:36I might be the most dangerous thing about it

01:38For example, this is the most dangerous form for him

01:41It will be from cell B2 to cell G20.

01:46I will tell them ok

01:47If I want it to contain heads

01:50I will teach the table

01:52I will tell them ok

01:54Heads as you can see

01:56My hands have these marks on them

01:57I'll take it later

01:58This is the filter mark.

02:00If it does not contain heads

02:03I'll take it okay

02:05I'll take it okay

02:07Okay

02:08Beautiful

02:09strong

02:10If I want to take back my words

02:12Control Z

02:13How many times will I take it?

02:17Let's go back to the main paper.

02:19I'll take it to the table

02:21to choose

02:22I'll take it

02:24I'll take it

02:25Apply with me

02:26This form

02:29The form of the prepared table

02:31A table may work.

02:32Or you might work a table.

02:34easy

02:35Because there is a special coordination for it

02:36Available in the previous ones

02:37I start to tell him

02:39Format as table

02:41Here is a new table style.

02:43I'll take it

02:44New table style

02:46Full table layout and formatting at once or first column layout and second column layout

02:53Full table layout and formatting

02:58I'll start finding the formats I want.

03:01For example, borders are borders everywhere.

03:04I will start to push these boundaries on the cells from all sides.

03:09These borders are wide.

03:11I will be a color type type stage

03:15Column layout I will change the black color to

03:20I will plan the column to fill.

03:23In additional color

03:27Column layouts for filling in light color

03:30I can do it once I feel

03:34And the column plans for filling

03:36She needs to format a new table.

03:38I will find the format as a table.

03:41I will find a custom format.

03:44These are the formats I made.

03:47I will find a coordination on it

03:49How to format table formats

03:54And we save it in table formats.

03:56It must be time to carry

الأنماط والجداول الجاهزة في الاكسيل

Category

Transcript

Be the first to comment

Recommended