Excel spreadsheet programming training and help
We also have Free
training videos on this site ( visit the
Home page
or the
Training Page)
Spreadsheet programming errors can cost a company millions and as such it is essential to have employees attend relevant workshops or training seminars to ensure that they can handle the advanced Excel spreadsheet programming functions adequately. Besides the free training videos, we also offer advanced training courses as well as financial modeling services to clients.
User Graphical Interface
Most users will access spreadsheet programming via the Excel graphical interface whilst a small number of users will manipulate objects on an advanced level through the Excel Objects option. It is possible to program with the use of Macros in Excel, but if you want to tap into the depth of power locked into Excel, it is best to go the Visual Basic route. This allows for true financial analysis of information stored in the company database. |
|
Functionality offered by Excel
Excel lends itself as an excellent application for financial modeling and database applications because of its analytical functionalities. This makes it the ideal tool for finance related departments. Tools such as VLookup, financial functions such as PMT and more ensure excellent functionality. Make use of our training videos to learn about Data tables and working for instance with “what if “ scenarios. To learn how to use this effectively as part of spreadsheet programming and more book one of our training courses or view our online tips. In addition you will benefit from the online training videos for auditing and power courses specifically for external and internal auditing departments. If you need consultation assistance, don’t hesitate. Contact us for expert advice.
|
