The Clarkson ITT Wiki is a reference library that includes technical reference materials and articles, tutorials and lessons on the use of Excel, Power BI and Visual Basic for Applications for modelling, analysis, reporting and dashboarding. It includes articles on PowerPoint and Word on subjects that are relevant to financial professionals' work related to these subject areas.
It is integrated with our subscription program - The Learning Habit - and some of this content forms part of the Learning Pathways provided by that program. A part of the wiki is accessible to the public, some is available free of charge to those with a subscription to our site, and some of the content is available only to alumni of our courses and subscribers to The Learning Habit .
The sections below describe the various elements of the wiki and provide links to index entries for those parts of the wiki. All articles within the wiki are tagged, and clicking on the tags will display a list of related articles. The articles may also be searched using the search box at the top of each web page on this site.
A set of tables providing quick access to key technical information on shortcuts, format codes, operators, function information.
Short written and video articles presenting solutions to common issues which are simple and easy to implement.
A checklist of critical elements in building robust and transparent models and analyses in an easy to remember acronym.
Short written and video articles presenting fundamental technical knowledge about Excel data, formatting and formulas.
Short articles that demonstrate how to undertake common tasks in modelling, analysis and presentation.
Technical information on the use of Excel worksheet functions, their arguments, return values, value types and the errors rerurned.
Short written and video articles presenting fundamental technical knowledge about VBA.
Short articles that demonstrate how to undertake common tasks in programming in VBA.
A set of study guides to assist the user in traversing the materials provided in the Wiki and in The Learning Habit .