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.
Ready Reference
A set of tables providing quick access to key technical information on shortcuts, format codes, operators, function information.
FROSTED Checklist
A checklist of critical elements in building robust and transparent models and analyses in an easy to remember acronym.
Excel Fundamentals
Short written and video articles presenting fundamental technical knowledge about Excel data, formatting and formulas.
Excel Function Reference
Technical information on the use of Excel worksheet functions, their arguments, return values, value types,errors returned and troubleshooting tips.
Excel How To
Short written and video articles that demonstrate how to undertake common tasks in modelling, analysis and presentation. It also includes quick tips on how to fix common problems and to set options in Excel .
VBA Fundamentals
Short written and video articles presenting fundamental technical knowledge about VBA, the programming environment and working with the object model.
VBA How To
Short written and video articles that demonstrate how to undertake common tasks in programming in VBA.
