QUICKBOOKS ACCOUNTING SOFTWARE & ADVANCED EXCEL COURSE OUTLINE The objective of this course is to enable Accounts & Finance Graduates, especially those who wants to enhance their capabilities with the hands on experience of using Financial Software& Advance Excel and to those who wants to go abroad (Middle East) for better job opportunity in this field. You will learn that how you can re-design (Customize) an accounting software from start to end and then operate efficiently. QuickBooks Enterprise Solution is a widely used Financial Software not only in Pakistan but also in Middle East and many companies looking for such experts who can manage their Accounts & Finance Departments' work through this software and must equipped with the skills of using advance excel.
COURSE FACILITATOR Mr. Muhammad Suleman Ikram is professionally, ASSOCIATE COST AND MANAGEMENT ACCOUNTANT (ACMA) with the wide range of experience of implementation of QuickBooks Software in different Local & International SMEs & Private Ltd Companies, i.e. Transportation Companies, Printing Presses, Trading Concerns (Both Local & Import-Export),& Garments Manufacturing Company along with In-House Trainings exposure. COURSE COVERAGE
QuickBooks Accounting Software Course Content: A complete "CASE STUDY" based training will be conducted based on the following contents by focusing on real time problems faced by users. 1. Introduction to QuickBooks 2. Important Info about Q.B 3. Basic Accounting Principles 4. Accounting Principles followed by QuickBooks 5. Understanding the Environment of Q.B 6. General Ledger (G/L) Module 7. Inventory Module 8. Receivable Module 9. Accounts Payable Module 10. Cash & Bank Module
Head Office Address: Office # 9, Level # 10, Arfa Software Technology Park, Ferozpur Road Lahore For Contact Call: 0320-1443744| 0321-9533335 | 042-35948425 Email:
[email protected] www.pnytrainings.com
11. Fixed Assets Module 12. Payroll Module 13. Administrative Module 14. Miscellaneous Module a. Reporting Module b. Templates Designing c. Others
Advance Excel Training Content: 1. Brief review of Basic Excel features. 2. Naming Ranges 3. Working with functions a. Sum, Avg, and other relevant formulas b. Financial Formulas c. Logical Formulas d. Date & Time e. Lookup & Reference formulas 4. Advanced Formulas and Using Data Ranges 5. Pivot Tables 6. Workbook for multiple users 7. Advanced Formatting 8. Data Validation 9. Macros
COURSE DURATION:
>
2 Days Classes in a Week for Professionals & Students.
>
Class Assignments, Scenario base Case Study & Final Exam.
>
Course Duration: 6 Weeks
>> Participants, who will complete the course will get PNY Trainings Certificate and referred in relevant industry for jobs and internships.
Head Office Address: Office # 9, Level # 10, Arfa Software Technology Park, Ferozpur Road Lahore For Contact Call: 0320-1443744| 0321-9533335 | 042-35948425 Email:
[email protected] www.pnytrainings.com