التنسيق الشرطي في الاكسيل المحاسبي

Shereen Elmasry

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

Transcript

00:00We learned together in the previous video how we make plans for the annual performance rate.

00:07In this video, we want to delete the charts we created using a keyboard shortcut.

00:13We start to format my cell chart.

00:16Let's start first with the charts that are opened using keyboard shortcuts.

00:23I start by standing on each one of them

00:26Here is Chart 3

00:28We do the rest of the keys

00:30He asks me, are you sure? I'll tell him.

00:33Here I stand on chart 3

00:36I will start by doing the rest of the keys.

00:40Beautiful and strong

00:42There is something new with us. We are used to getting to know her.

00:45Chart formatting of cells

00:47We knew before that when I want to change the color of the data inside the cells

00:52From here I start changing the color of the writing to the color I want

00:56We also know that from here I will start to change the color of the cell itself.

01:01This is a change that I make manually at the beginning.

01:05Okay, if I want to have a badge format

01:07This means that the coordination will be related to a specific thing.

01:10I will tell him, for example, that the value here is higher than a certain thing or lower than a certain thing.

01:16Start by giving it a distinctive color or shape from the rest of the cell.

01:20For example, here is the annual performance rate for all employees.

01:25I will start by specifying it and I will start by going to the tab called here

01:30I have something called conditioning.

01:33Conditional formatting means conditional coordination and has several options.

01:36We will start to see it together

01:38When I click on it, the first thing that appears is the highlight sales rolls.

01:42The principles on which I base my color for the cell

01:47It is the first new thing that is bigger than a specific thing.

01:51Can I write it to him and tell him it is greater than, for example, 95%?

01:57After I choose the quantity, I start choosing the color.

02:01Is it light red, bright red, yellow, yellow, green or burgundy?

02:07Choose the color I want

02:09I tell him, for example, green and okay

02:13The one that is greater than 95% takes the green color.

02:17Ok, I will start by making it a control Z to remove this stuff.

02:21Or I tell him Clear Rolls

02:23And I start to choose if it is one of the cells that I have selected

02:26Not from the devil at all

02:28Not from this table

02:30I will start telling him from the cells that I am specified on

02:33Ok, I'll go back again to the conditioning formula.

02:36I have something called "list than"

02:38Not than means less than

02:40It will always be the opposite. Can I tell him?

02:42Those who are less than the specified rating

02:44Start by giving him a specific format.

02:46The one who is less than, for example

02:4880%

02:50Or less than 88%

02:52Start by turning yellow

02:56So he began to work

02:58These colors

03:00Okay, here, if we pay attention to what is less than

03:0288% took coloring

03:04This is a normal thing for empty cells.

03:06Give it a color or a distinction

03:08Because it assumes that all empty cells have a value of zero.

03:12come back again

03:14And I start to tell him

03:16clear rules

03:18from selected cells

03:20Something that was said

03:22On the cells that I specified

03:24Come back again so I can continue with you

03:26conditional formatting

03:28I have between

03:30And come back again

03:32And come back again

03:36And come back again

03:38Enjoy

03:42Persians

03:44Keep it red

03:46It is done

04:04He takes the color or number for example three

04:07And so on

04:09good

04:10I'll start telling him here.

04:12Or I work for him

04:14cancel

04:15As I like

04:16conditional formatting

04:18has a date occurring

04:19It is the date of a certain occurrence.

04:21If I had history

04:23For example, sales

04:25or delivery date

04:26Or a date of birth

04:28I will start by telling him the date of the occurrence.

04:30And I start to define for him

04:32Date is yesterday

04:34Yesterday

04:35or today

04:36Today's date

04:37or tomorrow

04:38early

04:39or in the last 7 days

04:40or last week

04:41Last week

04:42or this week

04:43This week

04:44next week

04:45Next week

04:46last month

04:47Last month

04:49this month

04:50This month

04:51or next month

04:52Next month

04:53And I start to choose the color

04:56And go back again in duplicate values

04:59If I have duplicate values

05:01He starts to define it.

05:03Here let me know before I tell him

05:05okay

05:06And I can say to him unique

05:07So let me know about the individual values.

05:10cancel

05:12I have top bottom rules after that.

05:14From its name, the highest and lowest values

05:16Can I tell him the top 10 values?

05:18And I can tell him the top 10 values or strengthening ratios.

05:33Can I tell him top 3 or 2?

05:35And so on

05:36I have bottom 10 items, the least 10 values

05:40bottom 10 percentage

05:45I have above average

05:47Which is above the table

05:48He calculates the values for this

05:50And the one above the table

05:52He starts to distinguish between a certain color.

05:54or blue average

05:56Which is less than the mud

05:58And I start to determine what I want

06:02I have data bars

06:04It starts by giving a certain color.

06:07The chart remains the same on my values depending on the big and small

06:12I have color skills and I have specific colors in my hand.

06:16These colors also indicate values.

06:19So here I have the red color which has the least value.

06:22Yellow color slightly higher values

06:25Green color highest values

06:27Icon sets are a group of icons.

06:30Indicates the highest and lowest values.

06:33So here I am in the secondary performance rate

06:36I start by expressing it with highlight sales rules.

06:39And I start to tell him if he is greater than

06:42Bigger than

06:44for example

06:4695 or 96%

06:48I start by giving it the red color and okay

06:52Here I have one male or one female employee left

06:55What is the name of Mona, who is an employee?

06:58And the red color became

07:01It is possible if I have many employees and they are tired

07:05I want to start filtering my employee data.

07:10So I start from here

07:12What should I tell him? Filter by color for me.

07:14Filter me by color

07:16Just choose the color

07:18Those who bring the highest performance to me

07:21And we can still promote them.

07:23We can give them any incentives.

07:25good

07:26Can I also use Conditional Formaring?

07:29Or chart coordination

07:31In the same months

07:32I will start to see their performance rate.

07:34This employee during the months

07:36It is expressed by icons, for example.

07:38or as a chart

07:40I will start telling him again from the Conditional Formaring

07:42icon sets

07:44We can express it in the form of a graph like this.

07:48We can choose the shapes of the stocks for it.

07:51Of course, red has the lowest values and yellow has the highest values.

07:55Green has the highest values.

07:57So I see what I want

07:59Here, for example, I chose this graphic shape.

08:02As it shows every month how her performance is

08:08We would have finished the charting

08:11Come on, try it

Category

Transcript

Recommended