Announcement No. 19 The Directorate of Training and Qualification announces the establishment of a training course entitled Financial Accounting using Excel (American Journal)

#Idlib_University

#Directorate_Training_Qualification

Announcement No. / 19 /

The Directorate of Training and Rehabilitation at Idlib University announces the establishment of a #training_course_entitled_Financial_Accounting_using_Excel

(American daily)

Training axes: for students of the College of Administrative Sciences and the Technical Institute of Financial and Administrative Sciences

• Reminder of the principles of writing the accounting entry.
  1. Simple and compound constraint.
• The method of inserting papers for all months of the accounting cycle is linked to generalizing the creation of the journal to the remaining months and the use of conditional functions in the posting and balance operations.
• How to create accounting entry writing columns with amount columns.
• The method of opening columns for each account within the accounting cycle.
• The method of adding account names as a list to facilitate the selection of the account type when separating the accounting entry data.
• How to create a function to collect and calculate amounts from each account.
• Create a function to give the total amounts from each account in each party (debit – credit).
• Create a general ledger sheet and use advanced functions to transfer data from the journal.
• Use advanced functions to automatically balance accounts.
• Create a trial balance sheet with balances and totals and use advanced search functions to give the result automatically.
• Create an income statement, position, and financial income statement using Pivot Tables.
• Giving the student the method of amending the accounts and financial statements in the American Journal to add the accounts to suit the company for which the accounting cycle is assigned (the American Journal).

By the end of the course, participants will be able to:

• Establishing a complete accounting cycle to suit the company for which the accounting cycle is assigned, starting from the journal, passing through the trial balance, until reaching the income statement and financial position.
• What distinguishes the scientific material for this training is the use of advanced and conditional functions that will do all the arithmetic and conditional operations automatically, as the user of the financial cycle only has to separate the accounting entry data in the right place.
• Get financial reports as a statement of financial position at any time without any effort.

Coach: “Mr. Mohamed Anan.”

Target group: financial managers, accountants, and workers in the financial field in general, and for students of the College of Administrative Sciences and the Technical Institute for Financial and Administrative Sciences.

Training duration: / 24 / training hours.

Training time: Training is on Thursday and Friday or in the evening after 2:00 pm in consultation with the trainees.

Training fee: $10.

Training type: In-person.

Training location: to be determined when the number is completed.

Required number: 25-30 trainees.

Registration period: from the date of issuance of the advertisement until the completion of the number.

How to register: in person with the Directorate of Training and Rehabilitation at the Presidency of Idlib University.

To contact or inquire: Program Director a. Amer Summaq / +380 95 652 4315/ Watts.