Nairobi Training. Advanced Excel Financial Modeling, Quick Books & Microsoft Dynamics Navision August 13th-24th, 2018

About ASPM.
The Africa School of Project Management (ASPM) was established in the year 2000 in Kenya as a membership based professional management organisation. The school was formed to address capacity building needs among development partners, donor organizations, Government agencies, International and private sector firms in Africa.

The school has been pivotal in capacity building in South Sudan, South Africa, Botswana, Eritrea, Ethiopia, Kenya, Uganda, Congo, Somalia, Liberia,The Gambia, Tanzania, Pakistan, Burundi and Rwanda. The school has trained over 12,000 staffs who are involved in different projects and also conducted surveys, evaluations and research in different projects and businesses in Africa.

Course Preamble.
Introduction.
Advanced Excel Financial Modeling
This will be a comprehensive, Advanced and practical training course for finance staff, departmental heads and other staff whose roles necessitate periodic reports or otherwise and whose functionality imperatively revolves around use of Excel Spreadsheets. The course aims to impart skills that will among other things lead to objective reporting and improved use of excel spreadsheets.

Microsoft Excel has countless finance value adding features and the expert trainers will aim to select the most powerful and relevant tools and cover these while ensuring the practical sessions enable learners to emerge from the training more empowered.

Finance Advanced in Microsoft Dynamics Navision.
This course provides learners with the tools to set up the financial management application area. The focus is on the advanced financial functions within the organization such as multicurrency, cost accounting, cash flow forecast, and the VAT rate change tool. Further, this course focuses on internal reporting and analysis functionality in addition to the means for sharing data outside of the Microsoft Dynamics NAV environment, either through XBRL—a language for tagging financial data—or by exporting data to Microsoft Office Excel 2010.

Quick Books
This course enables participants to be exposed to the true potential of the QuickBooks Financial Software.

Broad Course Objectives

  • QuickBooks Products and System Requirements Clean and Conversion File Setup
  • Customizing Preferences
  • Sales Cycle – Invoicing Customers, Customer Payments, Bank Deposits
  • Procurement Cycle – Purchase Orders, Entering Bills, Paying Bills, Writing Checks
  • Tips and Tricks on Unique Customer and Vendor Transactions
  • Inventory Management Payroll Services
  • Payroll Setup and Processing Sales Tax
  • Data File Management Data Security Measures Year-End Procedures

Fee information
The tuition fee is USD 960 Exclusive 16% VAT for one weeks course.

How to Register:
Kindly apply through the following link or drop us mail at [email protected] or through http://www.aspm.co.ke/index.php/online-application