What extactly does Structured Spreadsheet Modelling and Implementation mean?
Structured Spreadsheet. Excel’s relative lack of structure hinders many users from using the program as well as they might. It limits the extensibility of a spreadsheet, and its ability to be shared. SSMI methodology focuses on teaching developers how to structure their spreadsheets. A well-constructed spreadsheet should be quick and easy for people to understand—so it can be easily handed off to other developers, or understood by colleagues, bosses, clients, auditors, etc.
Modelling. The basis of the SSMI methodology is the separation of creative and mechanical tasks. The activity of spreadsheet modelling—the creative process—is how you conceptualize the problem. The idea is to build the model without even touching Excel. This allows you to focus on the conceptual process, and relieves you of the need to refer to the software.
Implementation. This is the industry term for translating the conceptual model of the problem into a spreadsheet. Since effective implementation depends almost totally on effective modelling, the SSMI methodology renders this mechanical process relatively straightforward.
Why the SSMI methodology matters?
Using this methodology has many benefits—both for users (the people whose work depends on the spreadsheets), and even more for developers (the people who create the spreadsheets). When developers follow SSMI methods, both they and the users find it faster and easier to:
Understand what they’re doing when they create a spreadsheet, which reduces the probability of errors;
Review a spreadsheet, and test it for errors;
Explain to others how a spreadsheet works;
Modify a spreadsheet to adapt it to changing situations;
Maintain a spreadsheet throughout its lifecycle;
Manage a spreadsheet in an organizational setting.
What you can learn from this online course?
After you complete the course, you will be able to
- Identify the importance and the two components of the planning phase of the SSMI methodology
- Identify the theoretical basis of the suggested implementation process in the SSMI methodology
- Plan the development processes, including developing and implementing simple models, repeating sub-models and temporal models according to the case
- Modify a model in three steps
- Use advanced modelling techniques for irregular situations
- Look for errors in the spreadsheet
What is special about this online course?
- High-level interactivity. During the learning process, you will not just be sitting in front of the desk, like watching a movie. you will be contantly engaged in practices, such as answering quizzes in a program, drawing models on a paper and comparing your work with our solutions.
- Immediate and detailed feedback. We provide you many in-course practices and just-in-time feedback to check whether you trully understand the concepts. We explain each answer in detials, instead of just showing you "Correct" or "Incorrect"and letting you to figure out why by yourself.
- Real-life cases. All of our case study descriptions are based on and adapted from real-life cases, in order to give you a context and help you transfer what you learned to your daily work.
- Worked-out examples. You are not be working on your own. Of course, if you would like to challenge yourself, feel free to skip the guide and start from the scratch. However, if you need help, we support you with worked-out examples to guide you step-by-stey in order to facilitate your application of the new methodology.