00:00Welcome to the fifth and final practical application.
00:03Through this application, we will learn together how we do the American daily routine.
00:08We enter our data into it and use functions to get the total result for him every month.
00:15Finally, we will make a spreadsheet in which we will collect all our months, so that we will have a daily total for the whole year.
00:24First, we will create a new worksheet and click on New or the plus sign below.
00:30Then I start to change the direction of the honey from the Beige Lay Out She Treat to Latif
00:36I will start putting my fields or column names here, I will make them a series for example
00:43History and numbers the plot
00:49After that, the statement
00:54And the difference
00:58Then I start telling him the total.
01:03And I started to bury the size of the font and it took up the space that I wanted or that I expected
01:10Control A
01:11I leave my space or font size to be 20 for this space
01:18Can I make this text vertical instead of horizontal?
01:23I tell him text up
01:26After that, I start to take each statement of mine into two columns, so that I will have the columns as credit and debit.
01:35I start to tell him the box
01:42I have the bank
01:45goods
01:50I also have debtors
01:53Of course, my size can increase or decrease depending on the place itself. There is no problem.
01:58There are fixed assets.
02:03There is capital, sales and purchases.
02:12Sales and Purchases
02:16So I start putting the data to the end.
02:21This is the project definition.
02:24In the next video
02:25We will start with some coordination.
02:27We start to coordinate the data in the American daily.
02:32For the first month
02:32It is January
Comments