{"id":5498,"date":"2012-05-29T21:46:59","date_gmt":"2012-05-29T21:46:59","guid":{"rendered":"https:\/\/www.financial-fluency.co.uk\/?page_id=5498"},"modified":"2023-01-26T12:44:33","modified_gmt":"2023-01-26T12:44:33","slug":"spreadsheet-modelling-skills-for-finance","status":"publish","type":"page","link":"https:\/\/www.financial-fluency.co.uk\/financial-training-courses\/open-training-courses\/spreadsheet-modelling-skills-for-finance\/","title":{"rendered":"Spreadsheet Modelling Skills for Finance"},"content":{"rendered":"
\u2022 Are you a finance professional?
\n\u2022 Do you use spreadsheet models?
\n\u2022 Do you want to learn how to build spreadsheet models?
\n\u2022 Do you need to achieve consistency in models across your team?
\n\u2022 Do you want to incorporate best practice into your models?
\n\u2022 Do you want others to be able to use your models in the future?
\n
\nSpreadsheet modelling (sometimes referred to as financial modelling) is essentially a set of best practice techniques to achieve consistency across your spreadsheets. The two of the key benefits of spreadsheet modelling are ‘control’ and ‘succession planning’.<\/p>\n
Spreadsheet Control<\/strong> Succession planning for Spreadsheets<\/strong> This training course builds on our Spreadsheet (Excel) Skills for Finance course<\/a>.<\/p>\n It is designed for experienced excel users who need to learning modelling techniques.<\/p>\n Spreadsheets are fantastic business tools and we hardly utilise their potential. This course aims to ‘get you up to speed’ and give you an insight into excel’s true potential.<\/p>\n <\/a><\/p>\n This is a very practical hands-on course which is delivered by actually building a live spreadsheet excel model. We will use an illustrative financial model, used for forecasting financial statements throughout the course.<\/p>\n \u2022 A basic level of excel and IT literacy is assumed. We take an open friendly and enthusiastic approach to learning with spreadsheets. We believe that people learn more effectively when they are enjoying themselves. We make excel interesting for you.<\/p>\n We love questions and welcome as many as possible. We encourage an open atmosphere which in our experience accelerates the learning process.<\/p>\n We always use a large practical spreadsheet model on this course we believe this really helps our clients to understand concepts. We find that people only really learn when they test their understanding through practice.<\/p>\n
\nSpreadsheet models are built with controls in mind and with the aim of eliminating spreadsheet errors.<\/p>\n
\nSpreadsheet models are designed so they are easy to understand and use, with a transparent design and documentation. This ensures that they can be used across teams and over time as people leave and join the team.<\/p>\nSpreadsheet modelling course details<\/h3>\n
\nThe course covers the following areas:
\n\u2022 Design basics
\n\u2022 Design principles
\n\u2022 Key elements of model structure
\n\u2022 Building the Framework
\n\u2022 Set up the model structure
\n\u2022 Cell conventions
\n\u2022 Building the Schedules
\n\u2022 Naming conventions
\n\u2022 The financial statements
\n\u2022 Analysis and Presentation<\/p>\nEntry requirements for spreadsheet modelling course<\/h3>\n
\n\u2022 Delegates must have already attended our Spreadsheet (Excel) Skills for Finance training course<\/a> or pass an entry interview with our presenter. This is a fast paced course and we need to make sure that all delegates have a minimum level of expertise before attending.
\n\u2022 Delegates should bring a laptop with excel loaded.
\n\u2022 Laptops can be provided, if required, for an additional fee if required.
\n\u2022 We limit the course to 10 delegates to ensure enough individual attention is given to each person.<\/p>\nCourse delivery for spreadsheet modelling<\/h3>\n
Example of previous delegate’s feedback on spreadsheet course<\/h3>\n
\n
\n
\n
\n
\n<\/p>\n