مقدمة التطبيق العملي 5- اليومية الأمريكية

Shereen Elmasry

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

Transcript

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

Category

Transcript

Recommended