Online Course in Accounting Excel
Uses of Excel in the Field of Accounting with the Creation of a Complete Accounting System that Works Automatically
- English and Arabic
- With Certificate
Tutor Name
UdemyAbout the Course
Udemy announces an online course in the field of Excel accounting. In this course, you will learn about the uses of the Excel program in the field of accounting without the need for prior knowledge of the program. The course will be divided into three levels:
- Level One: The introductory level, in which you will study the basic skills of the Excel program from scratch:
- The importance of the program
- The program interface
- Selection
- Data entry and transfers
- Basic arithmetic operations: addition, subtraction, multiplication, division.
- Working with columns and rows and merging cells
- Font formats
- Cell frames and colors
- Adding images
- Adding backgrounds
- Save the file
- Level Two: Advanced level, and in this level you will study for more than three hours advanced skills and functions that will qualify you to:
- IF function
- And function
- OR function
- Sumif function
- Sumifs function
- Subtotal function
- Sumproduct function
- Conditional formats
- Hyperlink
- Pivot Table
- Colum lookup functions
- Colums lookup functions
- Row lookup functions
- Rows lookup functions
- Vlookup functions
- Hlookup functions
- Index lookup functions
- Match lookup functions
- Offest lookup functions
- Choose lookup functions
- Printing stages
- Save the file with a secret number
- PMT financial functions
- PV financial functions
- FV financial functions
- Rate financial functions
- NPER financial functions
- Protection Data
- Iferror
- Isnumber
- IsText
- Isnontext
- Isblank
- Isodd
- Iseven
- Isformula
- Islogicalr
- Averageif
- Averageifs
- Countif
- Countifs
- Level Three: Accounting Program at this level you will create a complete accounting system that works automatically with accurate results, which does not require accounting experience to work on it, just enter the daily entries and you will get all the different lists and analyses, and the program will consist of the following parts:
- Account Tree
- American Daily
- Trial Balance
- Analyses
- Class Cards
- Depreciation Statement
- Income Statement
- Balance Sheet
This course targets:
- Accountants
- College of Commerce students
- Accounting College students
- Small business owners
- Medium business owners
- Data entry clerks
- Managers at all levels
- Those wishing to work in the field of freelance work
- Those dealing with accounts and rules Data
To apply for this opportunity, click on Add to Cart on the official website, then go to the cart, fill in your data and pay the course fee, which is E£ 399.99
See more available fellowships on For9a
See more available events and conferences on For9a
See more available jobs on For9a
Taught by
Udemy, Inc. is a for-profit massive open online course provider aimed at professional adults and students. It was founded in May 2010. Its global community and course catalog get bigger every day. It is committed to changing the future of learning for the better. As well, it helps organizations of all types and sizes prepare for the path ahead.
Read more.