يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In the video above, we learned how we create or prepare the conditions for entering data for each commission.
00:07We also include the message that appears to the user so that he knows the type of data he should enter or the error message.
00:14In this video, we will start creating the overall format for our file, and we will start putting in the equations for calculating the debit balance.
00:24Let's start first, so that I can put my coordination, I will start by looking
00:28If I put two colors on it, for example, the first color will come and the second color will come
00:34The two colors without borders. I made copies of this arrangement in the space I wanted.
00:44Total area, for example, but up to 20
00:48As for the classes that we have done, we will do the same thing here in green.
00:55And here in orange, I will make borders for them, and I will make copies for this coordination, and I will start that I
01:03I put my coordination on the rest of the columns and here the same thing, both colors
01:10Users or I can also use lighter shades than them
01:16I will start by setting boundaries for it and transferring the rest of its space to row number 20.
01:32In this way, it's very good. After that, I will start to return the difference equation again.
01:38If you think that I am making a comparison between the creditor and the debtor, I will tell him to do so.
01:44If the creditor is equal to the debtor and the intermediary begins to see if the creditor is equal to the debtor or not, it is possible to increase the space for it a little.
01:55The time appeared with me here true. Okay, I want to do the total calculation for the debtor and it appears in all the columns. What do I start with? I will stop on the last row.
02:09And I will start by specifying it in all the columns, and before I start, I will enter any of my data points and tell it from data validation.
02:18Start by accepting any value for me so that it all becomes any value
02:26Make sure there is no error message or error alert.
02:30And then I will start here, that I use the sum function, I will tell it to equal sum so that it will make me a group of all the items in the column.
02:37Close the box and enter
02:41This should be 0. Okay, as for the other columns, I will start to withdraw until I finish my columns.
02:50Very nice, I created my first account in my devil in January
02:56Then I will start calculating the total of the creditor and the total of the debit here.
03:01He has the first row and so on for the second rows.
03:05How do I do this? Here, I want to calculate only the creditor and here only the debtor.
03:10I have a formula called sum F. Let's understand it first, then we can start working on the debit and credit.
03:17The sum F function starts by calculating the data in a specific range based on a condition that I set for it.
03:24I mean, I tell him to collect the data for me, whether this data is only credit or only debit.
03:30So I will start by saying how I use it. I will tell it to equal sum F.
03:34I will open a cost for him. I want him to collect his data, the creditor and the debtor, so I will start to inform him about the waste of the creditor and the debtor.
03:43I know all about it
03:49This is the shape
03:51And I started to go back to my coffee pot
03:54I will make it a comma or a semicolon
03:57He asked me about the criteria. The criteria means the condition.
04:00My condition is that if a word is placed between punctuation marks
04:03Or I start by choosing a cell that contains this word from the same writing
04:07I will start clicking on the cell that contains the creditor because I consider him the creditor
04:13After that, I will start to do my comma or my burst comma. It tells me sum range.
04:19sum range is the range in which we will sum. I will start by specifying it in the first row because I want the data of the first row.
04:26Like this
04:30And the course is closed
04:32But before I press Enter, let's take into account something that I chose here in Sum If, or the first range in which the header row is located, or the row that contains the names of the data, which are debit and credit.
04:45When I go to drag my function down, it will start adding my row every time, instead of 4, it will be 5, 6, and so on.
04:54So, you will change the range for me and it will cause me a problem in the function, so I will start to specify it on the range and press F4 on the keyboard
05:02So that it starts to install it for me to this extent, no matter how low I go, it starts to take the same row, which is my row.
05:11Four or number Four, and as for the cell that contains the chart, I will also start by installing it so that it does not start changing the cell for me every now and then
05:20Press F4 on the keyboard as well.
05:22The range of this class will of course change because we will start to withdraw
05:27Each row will calculate its own data, press Enter.
05:31So for me the creditor
05:33Can I do it for all grades? I will start by withdrawing up to grade 19.
05:38I will start doing the same thing again in the city. I will write it with you again so that it will be proven to you.
05:46I will tell him it is equal to some F
05:48I will open a box and tell him to add up the range of the debit and credit.
05:55Which is my header or the row that contains the data name
05:59I will go back to the coffee pot again
06:02I will make a comma or semicolon for him
06:06And I will start to make my own separation for him
06:12The range will be for the class you are in, which is the fifth class.
06:16I will start to define it
06:18And come back again and close the coffee pot course
06:24As we said and agreed with each other, we will install the first term.
06:30The one that has the hydroxy acid in it, so it won't happen again with me
06:32I hit F4 after I select it and here
06:36I also selected the cell that contains the condition and pressed F4.
06:40And I asked him to enter
06:42So you start to apply with me
06:44The same thing, I will start by dragging to apply it to the cell below.
06:48So I've finished the January thing
06:52So that I don't repeat this evil again, I will start doing it myself
06:56Click me
06:57And I start to tell him, "Good luck, Cap."
06:59I want to make a copy of it, so I tell him, Creator Cabby, make a copy for me.
07:03Move to the end and I'll tell him okay
07:06The second version I will call February
07:10I started changing the data in it so that it is consistent with the data for February.
