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
Comments