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 HabITT - and some of this content forms part of the 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 HabITT.
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 Function Reference
Technical information on the use of Excel worksheet functions, their arguments, return values, value types,errors returned and troubleshooting tips.
LAMBDA Library
A library of LAMBDAs ready to copy and paste into your own projects to simplify formulas in common modelling and analytical tasks.
Tools & Components Library
A library of tools, add-ins and components to install or copy and paste into your own projects to simplify common modelling and analytical tasks.
Excel Fundamentals
Short written and video articles presenting fundamental technical knowledge about Excel data, formatting and formulas.
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 .
Category Indexes
Wiki Index by Category
The category tags listed in the category list provide access to lists of articles tagged by subject area.
Function Index by Category
Technical information on the use of Excel worksheet functions, their arguments, return values, value types,errors returned and troubleshooting tips.