ÇßÓíá ãÍÇÓÈí ãÊÞÏã ÇæäáÇíä
ÝÞØ ÈÜ 350 ÌäíÉ ÈÏáÇ ãä 550 ÌäíÉ


ãÍÊæíÇÊ ÇáßæÑÓ
-----------------
(1)- ßíÝíÉ ÊÕãíã æÇÌåÉ ááÈÑäÇãÌ ÇáãÍÇÓÈí Interface for program
(2)- Ïáíá ÇáÍÓÇÈÇÊ chart of account
(3)- ÏÝÊÑ ÇáíæãíÉ æßíÝíÉ ÑÈØåÇ áÓäå ßÇãáå American journal
(4)- ÊÍáíáÇÊ ááÍÓÇÈÇÊ. ( ÇáÇÓÊÇÐ ÇáãÓÇÚÏ ) Assistant Ledger
1- ÊÍáíá ÇáäÞÏíå cash analysis
2- ÊÍáíá ÇáÈäæß banks analysis
3- ÊÍáíá ÇáãÔÊÑíÇÊ purchases analysis
4- ÊÍáíá ÇáãÈíÚÇÊ sales analysis
5- ÊÍáíá ÇáÚãáÇÁ customer analysis
6- ÊÍáíá ÇáãæÑÏíä vendors analysis
7-ÊÍáíá ÌÇÑí ÇáÔÑßÇÁ Partners Drawing Accounts
8-ÊÍáíá ÇæÑÇÞ ÇáÞÈÖ notes receivable
9- ÊÍáíá ÇæÑÇÞ ÇáÏÝÚ notes payable
10- ÊÍáíá ÔíßÇÊ ÊÍÊ ÇáÊÍÕíá checks under collection
11- ÊÍáíá ãÕÑæÝÇÊ ÇÏÇÑíå æÚãæãíÉ General and administrative expenses
(5) - ÏÝÊÑ ÇáÇÓÊÇÐ ÇáÚÇã general ledger
(6) - ãíÒÇä ÇáãÑÇÌÚÉ trial balance
(7) - ÞÇÆãÉ ÇáÏÎá income statement
(8)- ÞÇÆãÉ ÇáãÑßÒ ÇáãÇáí balance sheet
åÏÝ ÇáßæÑÓ
ÇáæÕæá Çáì ßíÝíÉ ÊÕãíã ÈÑäÇãÌ ãÍÇÓÈí ãÊßÇãá ÈÏÇíÉ ãä ÏÝÊÑ ÇáíæãíÉ Çáí ÞÇÆãÉ ÇáãÑßÒ ÇáãÇáí ÈÇáÊØÈíÞ Úáí ÇãËáÉ ÚãáíÉ ãä æÇÞÚ ÔÑßÇÊ ÝÚáíÉ æÇÓÊÎÏÇã ÇáÏæÇá ÇáãÊÞÏãå Ýí ÈÑäÇãÌ ÇáÇßÓíá


åÏíÉ ÇáßæÑÓ
- ÇÏÇÉ ÈÍË ÓÑíÚ ÏÇÎá Çí ÞÇÆãÉ ãäÓÏáÉ ÈãÌÑÏ ßÊÇÈå Çæá ÍÑÝ íÙåÑ äÊÇÆÌ ÇáÈÍË ãä ÞÇÆãÉ ãäÓÏáÉ æãáÝ ÔÑÍ ßíÝíÉ ÇÖÇÝÉ åÐå ÇáÇÏÇÉ Ýì ÈÑäÇãÌ ÇáÇßÓíá


ÇáÏæÇá æÇáæÙÇÆÝ ÇáãÊÞÏãÉ Ýì ÈÑäÇãÌ ÇáÇßÓíá ÇáãÓÊÎÏãÉ Ýí ÊÕãíã ÇáÈÑäÇãÌ


Vlookup ÏÇáÉ
hlookup ÏÇáÉ
match ÏÇáÉ
index ÏÇáÉ
sutotal ÏÇáÉ
If ÏÇáÉ
If + and ÏÇáÉ
If + or ÏÇáÉ
If + vlookup ÏÇáÉ
Iferror ÏÇáÉ
If + sum ÏÇáÉ
Sum ÏÇáÉ
Sumif ÏÇáÉ
len ÏÇáÉ
small ÏÇáÉ
large ÏÇáÉ
average ÏÇáÉ
max ÏÇáÉ
min ÏÇáÉ
count ÏÇáÉ
Data validation ÇáÊÍÞÞ ãä ÇáÈíÇäÇÊ

Conditional formatting ÇáÊäÓíÞ ÇáÔÑØí


ááÍÌÒ
01141666911


ÇáãÍÇÖÑ
=====
ÒíäÈ ÚÇØÝ Íáãí
ãÍÇÖÑ ãÍÇÓÈÉ ÇáÇáßÊÑæäíå
ÍÇÕáÉ Úáì ÏÑÇÓÇÊ ÚáíÇ Ýì ÇáãÍÇÓÈÉ æÇáãÑÇÌÚÉ æÇáÖÑÇÆÈ
ãÍÇÖÑå Ýì ÇáÚÏíÏ ãä ÇáãÑÇßÒ ÇáÊÚáíãíÉ


ÑÇÈØ ÇáÞäÇÉ Úáí ÇáíæÊíæÈ
https://www.youtube.com/user/zeinaba...able_polymer=1


ÑÇÈØ ÕÝÍÉ ÇáÝíÓ Èæß
https://www.facebook.com/zeinabhelmy479/