How well are you able to exploit the power of Microsoft Excel in your accounting or financial reporting role? Do you dread month end and year end because of the financial reporting hassle? Join us this December 8th to 9th and put your fears to rest. This Financial Reporting with Excel course has been designed to give participants a cost effective, flexible, and powerful solution to their organizations financial reporting needs. This course resolves many financial reporting challenges faced in various organizations by offering participants the flexibility and ease of creating their own solutions without the need of a large and costly system implementation.

WHY ATTEND THIS TRAINING?
Participants to this two day training will be able to develop Excel-based management reporting solutions to help their organizations automate and turn all the great data collected each day into useful information for making decisions, and monitoring operations.
Armed with knowledge from this training, participants will be able to;

• Generate Financial Reports with greater accuracy
• Save time & money in their financial reporting process;
• Understand what's happening in their businesses; and therefore,
• Make decisions with confidence.

WHAT YOU WILL LEARN FROM THIS COURSE
With this course participants can be assured a comprehensive study experience which will prepare them for any financial reporting and analysis role. They will gain;

• Practical knowledge on how to effectively automate their financial reporting by building various management reports, annual accounts and notes to the accounts based on a single Trial balance input
• An understanding of various error checking methods to ensure all the reports produced using this methodology are easily reconcilable with the various notes and sub reports.
• Practical knowledge and understanding of the tools, techniques and functions in Excel that are of greatest benefit to finance and accounting including their practical application.
• Good understanding of how to interface Microsoft Excel with other office applications like Microsoft Word and Power Point.
• New skills and confidence at the workplace.

COURSE OUTLINE
This two day training will focus on equipping participants (majorly, accountants and finance staff) with the necessary knowledge and skills they need to perform the tasks they typically do on a regular basis to achieve period end financial reports in a shorter time frame, but with greater accuracy. The training will cover the following areas from extraction of the trial balance to production of management accounts, final accounts and related notes.

• Excel basics and best practice;
• Review of Key functions; LOGICAL, DATE, LOOKUP Etc
• Financial reports; Understanding information flow and requirements
• Understanding the structure of your Trial balance, account codes and financial reports
• Setting up your financial reporting templates
• Automating production of notes to the accounts
• Linking your financial reports information to Ms Word or power point file.

WHO SHOULD ATTEND?

Finance Directors CFO’s Accountants Business Analysts Finance and Cost Analysts

Finance Managers Business Bankers Auditors and Investigators School bursars Finance & Accounting Staff

 
WHAT YOU’LL NEED
This course is not for beginners seeking to learn Microsoft Excel functionality. Participants should have some experience and basic understanding of Microsoft® Excel. Come with your own laptop loaded with office 2007 or above.

FEE: Enroll for this course at a discounted rate of UGX: 500,000 only per participant. Download brochure for payment details