00:00Welcome to the first lecture of Project 2
00:06We will work together on the employees’ attendance and departure and start making their accounts.
00:13Okay, we will start together. The first thing in this lecture is to learn about the keyboard shortcut for formatting cells.
00:20We will draw together his attendance and departure schedule.
00:24How do we know how to do the rest of the special cell formats and merge the cells?
00:31A new worksheet, which is Sheet 2. We will start by naming Sheet 2 so that its name is Attendance and Departure.
00:43After that, we will start to change the direction of my sheet from the north side.
00:48Leave it on the right side, I'll come back to you sheet right to left
00:52So we will start by increasing the size of the cells so that you can see and the font will be large.
00:58The first thing we will start with is that I specify the cells
01:02What I need to start with is to make the font size bigger.
01:05The speech begins to appear with you in the recording.
01:08We start by pressing ctrl 1 from the keyboard ctrl 1
01:12The cell formatting screen will start to appear.
01:16Choose here my font size 20 or 24 to make it large
01:22And I start by telling him okay
01:24So the cells start to be the large size you see.
01:28I want to start making attendance and departure in the form of tables
01:32The tables will show the days of the week in detail, the time of attendance each day, and the time of departure.
01:39We calculate the employee’s absence and we calculate the delay. How do I do all of this?
01:44Let's start together. The first thing we will write about here is the first week.
01:52I started to see the format of the cells. I hope it is a date format.
01:58For example, the date will start from the first day of September, which will be 19201.
02:10She came to me in a short date format.
02:14I will then start merging this cell with the cell next to it.
02:18Because today we have two cells for attendance and departure.
02:22A time to come and a time to leave
02:25I will start by specifying these two mixtures from the tab called here
02:30I will start telling him to make me a Mirgan Center
02:32Do me a cell fusion
02:34And I will start to determine as well
02:37Six cells of the same shape are combined.
02:41So he stays for the seven days of the first week
02:44Give me one, two, three, four, five
02:47Give me six
02:49Seven guide us where we need to go
02:51I will start to pull so that he can answer me
02:54the date
02:56Of course, if it appeared to me like this
02:58We are never afraid, we just increase the size of the cell
03:01Ours will start to appear with me
03:04The shape of history
03:06And here too, the same thing
03:16And so on
03:17Or I can find the most appropriate size or dimensions for the column and start doing it in all the cells so that it is distinctive.
03:27Here, for example, this size is good, or this size, I start to know Clicky Min on it
03:32And I started to tell him about the column's width.
03:35He tells me fifteen seventy-one
03:37I will make him a cabbie
03:38I will start to define all the columns next to it.
03:41And start clicking on me
03:43Kolam Wits Column View
03:45And he did it for him
03:46Wookie
03:47As all works are the same size.
03:51So these are my days or my history
03:56I will start making another one for him later. I have another class.
04:01So he can start bringing me the names of the days
04:06Here I know about this
04:08Click me
04:09And I started to tell him I'm happy
04:11Then he brings me another row above it.
04:13I will also start doing the same thing, I do a blood test.
04:21quickly
04:26Like this
04:28So I did a blood test of all the cells.
04:30I will start writing to him
04:31I'll see here, I have one nine
04:33What day of the week was this?
04:36And I started to work on it
04:38One nine, that was on Tuesday
04:47And I start to withdraw
04:48To bring me the rest of the week
04:50So I did the first part
04:53I will start by seeing the time of arrival and departure
04:56Ok, what is my check-in and check-out time?
04:59You will have taken the time coordination
05:02So I start by specifying all the cells.
05:04Which will have attendance and departure
05:06All right
05:08Format sales or control one from the keyboard
05:11I will start by choosing the format of my data here.
05:17Instead of it being a number, I make it custom
05:20And who chose for him
05:23Which is H H M M S S
05:26I like the clock layout
05:28Minutes and seconds
05:31The H represents the hour
05:33H H which is the time
05:34In coordination with her son
05:35Like super 12, three for the
05:37Three for the star line
05:39And the minute is the minute in the yearly calendar
05:42Here is the s which are the seconds
05:44By the Sunnah
05:45I'll start telling him okay
05:47Here I start to put the time when the employee came at eight in the morning, so it remains zero eight
05:54Zero zero zero zero zero
05:58That's the time she came. It's time to leave. Let her go. It's six o'clock. It's 4 o'clock.
06:04Our attendance and departure time is fixed for work, which is 8 hours.
06:10So I start walking at 4:00 PM
06:13So I start setting the time for attendance and departure for all employees.
06:22Here we learned in this video the shortcut for formatting cells with Ctrl+1.
06:28How do we know that we are merging cells from Mergent Center?
06:32We can also mediate the words in the cells. I will start by specifying my cells.
06:38My coordination tells him that it should be in the middle in a vertical and horizontal position.
06:43Or to the right or left, as you like
06:46This is the alignment of the words.
06:50Or from Ctrl 1
06:52I will start to tell him alignment and start to see the horizontal position
06:57It will be center and the vertical position will also be center
07:01And I start to tell him okay
07:03So I will start setting the time of attendance and departure for all days of the week.
07:09I will come back to you in the second video to complete the attendance and departure project together.
07:15Click patch
