مقدمة التطبيق الثاني في الاكسيل المحاسبي

Shereen Elmasry

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

Transcript

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

Category

Transcript

Recommended