Excel for Accountants

Excel for Accountants (3)

Financial Modelling in Microsoft Excel

9 July 2018, 12:18 am Written by
Published in Excel for Accountants
 

What is this about?

Financial Modelling is an interactive programme that involves instruction, discussion and extensive participant activity. It is aimed at developing knowledge and skills in building a financial model by making a decision regarding investment in a project or company.

Participants will also learn effective auditing techniques on existing models. The “mouse less” excel techniques taught as part of this training, when employed dramatically reduces model coding time and are indispensable to the effective use of financial spreadsheets for any industry or sector.

Why should you enroll?

The programme aims at addressing different training needs of the employees in terms of empowering them with data processing and modelling skills. This in turn will greatly increase return on investment (ROI) for your organisation and improve career advancement prospects for learners. All the basics of advanced Excel are covered, enabling the delegates to move on to an exhaustive treatment of the main modelling techniques available thus building financial models that are robust, tested and scalable.

What are the topics covered?

  • Introduction and overview to Financial Modelling
  • Model Tools & Functions
  • Financial Functions
  • Modelling Techniques
  • Rebuilding and Inherited Model
  • Bullet proofing your model
  • Scenarios and Sensitivity Analysis
  • Presentation of Model Output

Credits Awarded

2 credits

What is the duration?

This is a 2.5 days course

Who should attend?

  • Financial Managers
  • Chartered Accountants
  • Management Accountants
  • Cost Accountants
  • Technical Accountants
  • Financial Accountants
  • Financial Officers
  • Financial Planners
  • Financial Controllers
  • Financial Project Administrators
  • Finance Supervisors
  • Financial and Business Analysts
 
 

Email us at This email address is being protected from spambots. You need JavaScript enabled to view it. or call +267 363 5406 for a customised annual training plan for 2017 at no extra cost.

 
 

Computerized Accounting – Sage Pastel

9 July 2018, 12:17 am Written by
Published in Excel for Accountants
 

What is this about?

This course introduces students to the computer, windows, email and internet as well as a study of Microsoft Office as an accounting tool. Being able to keep the books of a business on a computerised accounting software package is essential for any bookkeeper. The course also includes an in depth study of dedicated computerised accounting using industry leading software packages.

Why should you enroll?

The introduction of computerized accounting systems provide major advantages such as speed and accuracy of operation, and perhaps more importantly, the ability to see the real-time state of the company’s financial position. The Computerized Accounting (Sage Pastel) course will provide learners with knowledge of the business concepts and office skills in the key areas of accounting. In this 5 days course, learners will learn how to use Sage Pastel software along with other essential skills and techniques needed in this profession.

What are the topics covered?

  • Basic PC concepts
  • Working with MS Windows OS
  • Working with the Internet and Microsoft Internet Explorer and Microsoft Outlook
  • Working with Microsoft Word
  • Working with Microsoft Excel
  • Working with Microsoft PowerPoint
  • Installation and registration
  • Pastel language
  • Creating and setting up a company
  • Create and maintain general ledger accounts
  • Create and maintain supplier accounts
  • Create and maintain customer accounts
  • Create and maintain inventory items
  • Take on balances and journals
  • Supplier processing
  • Customer processing
  • Cash book, petty cash and journal
  • Month end procedures
  • Year end procedures

Credits Awarded

10 credits

What is the duration?

This is a 5 days course

Who should attend?

  • Accountants
  • Financial Analysts
  • Portifolio Managers
  • Securities Analysts
  • Pension Fund Managers
  • Auditors
 
 

Email us at This email address is being protected from spambots. You need JavaScript enabled to view it. or call +267 363 5406 for a customised annual training plan for 2017 at no extra cost.

 
 
 

What is this about?

Advanced financial modelling is an interactive training programme, which involves instruction, discussion, and extensive participant activity, which aims to enhance your knowledge and skills in building a financial model. In the ever changing business environment, being able to accurately model and forecast the volatile economic inputs is a critical skill for business professionals. Build on your existing modelling skills and apply new technique to better analyse financial data, predict revenues & cost and assess risk to justify business decisions in the most efficient and effective way

Why should you enroll?

The programme aims at addressing various skills building on your existing modelling skills and learning new techniques to better analyse financial data, predict revenues, assess risk and justify business decision in the most efficient and effective way. Its built on your knowledge of advanced excel tool and functions and incorporates these into complex and dynamic financial models. This will help increase return on investment (ROI) for your organisation and improve your career advancement prospects and learn new techniques that will streamline your next data analysis project. Learn to unleash the power of Excel to your advantage.

What are the topics covered?

  • Overview of best practice Financial Modelling
  • Advance Tool and Function in Excel
  • Rebuild an Inherited Model
  • Creating Waterfall Chart
  • Scenarios & Sensitivity Analysis
  • Practical Financial Modelling
  • Factory Rollout Model

Credits Awarded

2 credits

What is the duration?

This is a 2.5 days course

Who should attend?

  • Financial Managers
  • Chartered Accountants
  • Management Accountants
  • Cost Accountants
  • Technical Accountants
  • Financial Accountants
  • Financial Officers
  • Financial Planners
  • Financial Controllers
  • Financial Project Administrators
  • Finance Supervisors
  • Financial and Business Analysts
 
 

Email us at This email address is being protected from spambots. You need JavaScript enabled to view it. or call +267 363 5406 for a customised annual training plan for 2017 at no extra cost.