Spreadsheet Skills and Financial Modelling

Pretoria
9 mars to 20 mars
Kigali -Rwanda
9 décembre to 20 décembre
Pretoria
13 janvier to 24 janvier
Overview: 

Spreadsheet Skills for Finance Personal is a comprehensive training workshop designed to provide delegates with a good insight into the latest and advanced features available in Microsoft Spreadsheet. Spreadsheet Skills are predominantly in Micro Soft Excel and can be intimidating, complex and confusing with so many features and tools available to use.

The ATI Spreadsheet Skills for Finance Personnel lays the foundation, and advanced features of Excel Spreadsheet that can be applied in any corporate financial data analysis, statistics, and visualization, while building pragmatic solutions to common business problems

This training workshop offers plenty of screenshots that explain how to use a particular feature, in a step-by-step manner that will be provided to our esteemed delegates as take-aways for future referencing in the various workplaces

Target Audience: 

The course is designed for all Financial personnel who depend heavily on Spreadsheets, MS-Excel to prepare charts, tables, and professional reports that involve complex data. This training workshop will benefit all those readers who use MS-Excel regularly to analyze data, Accounting and finance professionals in public practice or industry

Course Outcomes: 

Upon completing this workshop, the delegates should be able to:

 

  • Make use of spreadsheet tools and financial spreadsheets such as data tables, conditional formatting, custom formats, charts, and auditing tools
  • Use data validation methodology to ensure that excel spreadsheet inputs are within defined and acceptable parameter limits
  • Create controls into workbooks to extend and improve those workbooks’ user-interfaces as favourites for daily application
  • Automate recurring processes, customize reporting according to Key Performance Indicators (KPI) and use the most powerful features of Excel
  • Know which features and functions should be used for various high-level tasks at different levels, accounting and financial functions
  • Enhance, customize and extend the Excel user interface through modifications to the Excel environment, the creation of custom Financial user forms
  • Adding VBA projects to your workbooks, automate and extend the Excel environment to supercharge the Excel models